An insight into Destinations for Northwind / ES4 services for use with SAP HCP / Web IDE

[amolgupta]

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