hanadata-integration

Data Integration Tool For HANA

Is there a good data integration tool available for SAP HANA which could accomplish the following :

  1. Consuming data periodically (a user defined interval) from REST based web service (A simple URL containing XML)
  2. Parsing the XML and extracting the data
  3. Populating the associated table

I am aware that SQL Server Integration Service is one such tool available for Microsoft SQL Server, which does the above. Would like to know the equivalent in HANA. I did explore SAP Cloud Integration service and Business Object Data Services tool, but would like to have a first hand opinion on the same.

Solution

  • SAP HANA Smart Data Integration (SDI) is a standard product option that you can use for this. As it is a feature of SAP HANA, no additional server is required for this solution. This blog gives a good overview SAP SDI BLOG.

    Data Services can of course also used for that, but would probably be the 'Ferrari for driving to the bakery'.