Skip to Content
Author's profile photo Midhun VP

Introduction to Creating OData Service in HANA Cloud Integration

The OData Provisioning feature in HCI is designed for today’s increasing demand to consume data from various data sources in a simple and standard way. This feature converts non-OData protocols to OData protocols.

 

Using this feature, applications like Fiori and HANA Cloud Platform Mobile Services will be able to consume data from different data sources such as SOAP and REST as OData services.

 

2016-04-13_12-40-55 (2).jpg

List of Options

  1. Create OData service based on an existing SOAP Service.
    • You can import a SOAP WSDL file to the HCI wizard to create OData model or you could create an OData edmx file from scratch and define SOAP as backend.   /wp-content/uploads/2016/04/2016_04_13_14_11_07_928777.jpg
    • That means, your applications can consume data from a SOAP data source as OData service. (Note that composite and multipart SOAP services are not supported.)
    • You can see it in action here.
  2. Create OData service based on an existing OData service.
    • This feature is useful when you want to modify and existing OData service. Ex. If Products is an OData collection with 100 properties, you can reduce it to 10 properties in the OData service you are exposing via HCI.
    • You can import the edmx (metadata) file to do it. /wp-content/uploads/2016/04/2016_04_13_14_18_46_928809.jpg
  3. Create OData service for REST data source.
    • In the case of REST as the data source, you need to create the edmx file from scratch using OData model editor. i.e OData model cannot be auto-generated based on an existing REST service. /wp-content/uploads/2016/04/2016_04_13_14_21_44_928815.jpg
  4. Service Mash-up.
    • You can create OData service which connects to multiple, different data sources. Hence, a single OData URL can give data from heterogeneous backend systems.
    • After creating OData models you can define data sources as given below./wp-content/uploads/2016/04/2016_04_13_13_36_24_928816.jpg
    • Currently, you can mash up 3 data sources: SOAP, REST and OData.

 

An End to End Demo

This demo shows, how to create OData service from an existing SOAP service and consume it in a mobile app.

 

Steps:

1. How to create OData service from an existing SOAP service using HCI.

2. Then, configure the mobile application in HCPMS.

3. Finally, creating the mobile app using Web IDE.

 

Note: This video was created a couple of months back for my DKOM presentation, so you might find some small UI changes, you can notice that the OData end point URL was created automatically in HCI, but it is not available now. Today you are required to create end point URL manually as mentioned here under section endpoints.

 

Find the documentation here.

If you want to know how to convert SOAP to OData using HCI read this blog.

To know the use case of this feature with HCPMS read this blog.

 

 

Regards, Midhun

SAP Technology RIG

Assigned Tags

      18 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Pretty cool and Long awaited. I am really the first to click "like" here? 😀

      This fills some gaps, great to see "real" iflows behind this, as it should be easy to fit in custom steps (this was something inpossible but often needed in PO iflows).

      Also good to see Mobile backends now use a real Integration capable Plattform (HCI) instead of a static layer. Looking Forward to get my Hands on.

      Cheers

                 Sebastian

      Author's profile photo Bhargava Krishna Talasila
      Bhargava Krishna Talasila

      Hi Midhun,

      Nice blog...!

      Thanks for sharing 🙂


      Regards

      Bhargava Krishna

      Author's profile photo Jocelyn Dart
      Jocelyn Dart

      Glad to see this available at last!

      Author's profile photo Former Member
      Former Member

      Hi Midhun,

      Thanks for sharing the real use case of HCI OData Feature.

      Though this is not actually backend enabled oData service ,but I would like to know whether Is it possible to publish this in Gateway Hub ,using HCI- Odata Provisioning feature , so that if some one wants to consume they can look into repository for consumption ?

      Thanks & Regards
      Rajesh

      Author's profile photo Sai Harish Balantrapu
      Sai Harish Balantrapu

      Hi Rajesh,

      You have an OData service endpoint URL and this service you would want to expose via an ABAP system. If this is the scenario you want to achieve you may use "OData Services Consumption and Integration" of the SAP gateway.

      Please check the below documentation for further details

      http://help.sap.com/saphelp_nw74/helpdata/en/ae/7822518bc72214e10000000a44176d/frameset.htm

      Best Regards,

      Harish

      Author's profile photo Mathew Davis
      Mathew Davis

      Hi Midhun

      Thanks for this informative blog, please provide the HCI cockpit link.

      Thanks

      Mathew

      Author's profile photo Midhun VP
      Midhun VP
      Blog Post Author

      Hi Mathew,

      You can go through this blog to find how to get an HCI trial system: SAP HANA Cloud Integration - Test and learn more about SAP’s cloud based integration solution

      Regards, Midhun

      SAP Technology RIG

      Author's profile photo Raghuraman S
      Raghuraman S

      Nice Document. 🙂 Thanks for the Share.

      Author's profile photo Revathi Chitturi
      Revathi Chitturi

      Informative blog.. thanks for sharing..!

      Author's profile photo Pavan Golesar
      Pavan Golesar

      Hi Midhun,

      Nicely collaborated document for the step-by-step guide. (Exactly what I was looking for).

      Keep up, Again a fantastic post. Cheers. 🙂

      --Pavan Golesar.

      abaper.weebly.com

      Author's profile photo Tahir Öz
      Tahir Öz

      Very well explained Midhun. Thanks for sharing.

      Author's profile photo Vinothkumar T
      Vinothkumar T

      Hi,

      While login to HCI I am getting only Discover option in the dashboard, How to enable Design , monitor and other option .. as i am not able to view the same.

      Regards

      Vinoth

      Author's profile photo Former Member
      Former Member

      Hi,

      You can refer to this link to get those enabled: Getting Started with HANA Cloud Integration (HCP Integration Services)

      Regards,

      Nagesh

      Author's profile photo Esteban Colina
      Esteban Colina

      Hi Midhun,

      This have been a breakthrough to me, just today.   I went to my HCI PI Tenant then tried to create an Odata Artifact  but  on my tenant I cannot see the opcion: Odata Service the only i have are  :  Process integracion,  Data integracion and value mapping.

      I there any way,  I could get the  Odata service option available on my tenant ?

      Thanks you in advanced.

      Author's profile photo Former Member
      Former Member

      Hi Esteban,

       

      Check now, I just saw it appearing in our tenants.

       

      Cheers Marco

      Author's profile photo Former Member
      Former Member

      Hello, Midhun.

      Do you have an idea why "Add OData Service" not available?

      Author's profile photo Midhun VP
      Midhun VP
      Blog Post Author

      This feature is now GA: https://blogs.sap.com/2017/07/17/odata-service-project-vs-integration-project-when-to-use-what-in-cloud-platform-integration/

      Author's profile photo Chaitanya Shinde
      Chaitanya Shinde

      Hi Midhun,

      Thank you for the amazing explanation.

      In our scenario I'm receiving data from third party via RESTful API and I want to consume the same in C4C through HCI. Our scenario matches the third scenario from your blog.

      Can explain more about how to create the edmx file from scratch using OData model editor and map it with the SAOP API in HCI?

      Thanks and Regards.