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?

[gregorw]

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