How to extract data from 3rd party application into HANA database using API

[nam_truong]

Hello Experts,

Do you have any guidance to use API to extract data from a system of a 3rd party application into HANA database ?

Any detail or suggestion is greatly appreciated.

Thanks

[nam_truong]

Thanks Elijah ! I will try that.

[ElijahM]

Hi Nam,

I am not a HANA expert, so it may be required to to bring in a deeper topic expert, but my recommendation would be to create an OData service in HANA and set up an API connect there.

There are many resources out there to do this, but hopefully you can start with these:

http://help.sap.com/hana/SAP_HANA_XS_REST_API_Reference_en/index.html

http://saphanatutorial.com/how-to-create-sap-hana-odata-service/

The data movement can be accomplished in any number of ways, via an Integration tool like CPI, or you can call the API of the 3rd party service via an API tool, and then push the data into the OData service.

I hope this helps, if additional information is needed can bring in a deeper HANA expert.

Regards,
Elijah