Skip to Content
avatar image
Nam Truong

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

Dec 15, 2017 at 12:41 AM | 171 Views | Last edit Dec 20, 2017 at 09:24 PM 2 rev.

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

SAP API Management
SAP HANA | 3rd party
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Elijah Martinez
    Dec 20, 2017 at 09:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Nam Truong
    Feb 22, 2018 at 11:50 PM

    Thanks Elijah ! I will try that.

    Add comment
    10|10000 characters needed characters exceeded