Skip to Content

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
Capture.PNG

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

Capture.PNG

Testing a destination

Capture.PNG

Capture.PNG

Capture.PNG

Capture.PNG

You can also test a created destination without edit mode

Capture.PNG

Capture.PNG

Capture.PNG

Capture.PNG

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Sibylle Brehm

    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

    (0) 
  2. Michael Devine

    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/
    (0) 

Leave a Reply