Skip to Content
0

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

Dec 15, 2017 at 12:41 AM

70

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Elijah Martinez
Dec 20, 2017 at 09:33 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Feb 22 at 11:50 PM
0

Thanks Elijah ! I will try that.

Share
10 |10000 characters needed characters left characters exceeded