An insight into Destinations for Northwind / ES4 services for use with SAP HCP / Web IDE
Introduction : This document will provide you access to the common OData destinations that you can simply import and use !
Target audience : Beginners and experts alike
Date created : 05.09.216
Note for the readers : This is a living document and I will keep on updating it iteratively. If you find across any content that is not covered or if you have any free / public destination that can be used for demo purposes, please let me know via comments and I will update the document.
HCP = Hana Cloud Platform
1). Services from https://services.odata.org
Service | Link to service |
---|---|
Northwind service The Northwind database |
https://services.odata.org/Northwind/Northwind.svc/ |
Sample OData Service (read-only) Categories, Product and Supplier data |
https://services.odata.org/OData/OData.svc/ |
Sample OData Service (read / write)
Categories, Product and Supplier data |
https://services.odata.org/v3/odata/odata.svc |
2). services from SAP ES4 System
The exposed services need one time signup but authentication every time you use the service. Please sign up with details provide in below link.
Sign up and get started with the SAP Gateway – Demo Consumption System
https://scn.sap.com/docs/DOC-40986
More details about exposed SAP ES4 services
https://scn.sap.com/docs/DOC-31221
Service | Link to service |
---|---|
(EPM) Enterprise Procurement Model (QCRUD) | https://sapes4.sapdevcenter.com/sap/opu/odata/IWBEP/GWSAMPLE_BASIC/?sap-ds-debug=true |
SAP Flight data (read only) | https://sapes4.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/? sap-ds-debug=true |
(EPM) Enterprise Procurement Model (read only) | https://sapes4.sapdevcenter.com/sap/opu/odata/IWBEP/GWDEMO/ ?sap-ds-debug=true |
It is interesting to note that these links still work if you remove “?sap-ds-debug=true” at the trailing end. Adding “?sap-ds-debug=true” provides some more information than the URL without it.
Link to ready to import destination file
I would recommend you to try to create your own destination from scratch. But if you face any problems just download the above file and import into your HCP destinations.
Destination | Link to ready to import destination file |
---|---|
services.odata.org / Northwind | https://drive.google.com/file/d/0BypiX-Op9BuWQ3lIU1ZYbGljdkk/view?usp=sharing |
ES4 | https://drive.google.com/file/d/0BypiX-Op9BuWM2ZVWFg5UkM2ZGs/view?usp=sharing Please put in your own username in the destination. I have removed mine. |
Importing the destination
If you open the file with Notepad it just has the following information. No rocket science involved so far.
services.odata.org | ES4 |
---|---|
# #Mon Sep 05 11:11:35 UTC 2016 Name=northwind URL=https://services.odata.org/ ProxyType=Internet Type=HTTP CloudConnectorVersion=2 Authentication=NoAuthentication Description=northwind OData Service |
#Password=<< Existing password/certificate removed on Export >> # #Mon Sep 05 21:39:46 UTC 2016 Description=ES4 Demo System Type=HTTP Authentication=BasicAuthentication WebIDEUsage=odata_gen,odata_abap,bsp_execute_abap Name=es4 WebIDEEnabled=true CloudConnectorVersion=1 ProxyType=Internet URL=https://sapes4.sapdevcenter.com/ User= WebIDESystem=ES4 |
Please note the “/” at the end of the URL
Testing a destination
You can also test a created destination without edit mode
New NetWeaver Information at SAP.com
Very Helpfull