Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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
    Former Member
    Feb 22 at 11:50 PM

    Thanks Elijah ! I will try that.

    Add comment
    10|10000 characters needed characters exceeded