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 http://services.odata.org
| Service | Link to service |
|---|---|
| Northwind service The Northwind database |
http://services.odata.org/Northwind/Northwind.svc/ |
| Sample OData Service (read-only) Categories, Product and Supplier data |
http://services.odata.org/OData/OData.svc/ |
| Sample OData Service (read / write)
Categories, Product and Supplier data |
http://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
http://scn.sap.com/docs/DOC-40986
More details about exposed SAP ES4 services
http://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=http\://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=<YOUR_OWN_USERNAME_HERE_PLEASE> WebIDESystem=ES4 |
Please note the “/” at the end of the URL
Testing a destination
You can also test a created destination without edit mode
Hi Amol, thanks for the nice blog. I noticed that the docs about the ES4 system and how to get access to it are not available any more after the SCN migration. Can you tell me where to find them? Thank you, Sibylle
Sign up and get started with the SAP Gateway – Demo Consumption System
http://scn.sap.com/docs/DOC-40986
More details about exposed SAP ES4 services
http://scn.sap.com/docs/DOC-31221
Hi Amol, can you let me know what is the source of the ODataV4 sample service from SAP ?
???? /sap/opu/odata4/IWBEP/V4_SAMPLE/default/IWBEP/V4_GW_SAMPLE_BASIC/0001/I am not able to access ES4 destination data using Webide.
Kindly help to resolve this issue.
Regards,
Shreya Girdhani
Can I use this ES4 destination to create test data like products or sales orders in ES4 system?
Is the ES4 OData still available? After I log in to the system, I cannot open the OData document
Hi Amol,
The link provided for ES4 Sign Up is not working.Can you Please provide new link from where i can log in.
https://blogs.sap.com/2017/06/16/netweaver-gateway-demo-es5-now-in-beta/