How to Retrieve Data from HANA DB Using CAP for OData Service in SAP Business Application Studio?

[anildeep7]

Hi Experts,

I am working on a project where I need to retrieve data from an SAP HANA database using an OData service. I plan to use an OData adapter in SAP CPI (Cloud Platform Integration) for this purpose. From my understanding, I need to create a CAP (Cloud Application Programming) project in SAP Business Application Studio to expose the data via an OData service.

Could someone guide me through the steps to achieve this? Additionally, if there are any comprehensive documentation or tutorials available, please share them.

Thank you in advance for your assistance!

Best regards,

Anildeep

SAP HANA Cloud, SAP HANA database SAP HANA service for SAP BTP SAP Business Application Studio Cloud Integration SAP Integration Suite SAP Cloud Application Programming Model 

[gregorw]

Can you provide more details on your usecase? Any reason why you would also add SAP Cloud Integration into the mix here?

[anildeep7]

Hi @gregorw,

I am working on creating an application where data from SAP SuccessFactors is available in SAP Build Apps. The application will need to perform CRUD (Create, Read, Update, Delete) operations on this data. As an SAP Integration Suite consultant, I am looking to avoid performing CRUD operations directly within SAP Build Apps. Instead, I plan to handle these operations using SAP Cloud Integration, as there will be no of calls to Third Party Systems, The SAP Build Apps will primarily be used for showcasing the data.

I understand that SAP Cloud Integration can easily handle CRUD operations with SAP HANA Cloud using the JDBC Adapter. However, I am facing a challenge in showcasing the data in SAP Build Apps, as there is no JDBC adapter available there.

so could you please advise me on how can i create OData service out of HANA DB.

Thanks,

Anildeep

[gregorw]

https://cap.cloud.sap/docs/