Extract Data From S/4HANA 1709 using MS SSIS

[Former Member]

Hi Experts,

To give a overview of the landscape - We are building a enterprise data warehouse using MSBI.

For this we need to extract data from S/4HANA 1709 and would like to know if we can use SSIS for the same. We would like to use the inbuilt S/4HANA extractors so that delta is taken care of.

SSIS because we have existing enterprise license for the same and we don't want to invest on HCI-DS if this works out.

Any documents, suggestion will help us a lot.

Other source system includes success factor, MS dynamics & SQL server.

Thanks

Madhusudan

[former_member271667]

I have found this when i search on

https://blogs.sap.com/2016/08/05/how-to-connect-microsoft-ssis-with-sap-hana/

I dont think it will takecare of delta data, but i will post you if i get more details on your question

[Former Member]

Hi,

After a bit of research i came across OData Service for extracting ODP Data. Hope this can help others.

https://help.sap.com/viewer/ccc9cdbdc6cd4eceaf1e5485b1bf8f4b/7.5.9/en-US/50f4ee6253134d3cafa25b9444f...

But, i still have a doubt if the OData service can be used to extract delta from ODP

Best Regards

Madhusudan