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.
List of Options
- 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.
- 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.
- 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.
- Create OData service based on an existing OData service.
- Create OData service for REST data source.
- Service Mash-up.
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
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
Hi Midhun,
Nice blog...!
Thanks for sharing 🙂
Regards
Bhargava Krishna
Glad to see this available at last!
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
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
Hi Midhun
Thanks for this informative blog, please provide the HCI cockpit link.
Thanks
Mathew
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
Nice Document. 🙂 Thanks for the Share.
Informative blog.. thanks for sharing..!
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
Very well explained Midhun. Thanks for sharing.
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
Hi,
You can refer to this link to get those enabled: Getting Started with HANA Cloud Integration (HCP Integration Services)
Regards,
Nagesh
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.
Hi Esteban,
Check now, I just saw it appearing in our tenants.
Cheers Marco
Hello, Midhun.
Do you have an idea why "Add OData Service" not available?
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/
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.