Skip to Content
avatar image
Former Member

Extract Data From S/4HANA 1709 using MS SSIS

Feb 21, 2018 at 08:50 AM | 385 Views

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

SAP Data Services
SAP S/4HANA | SAP Cloud Platform Integration tools | SAP HANA | BW (SAP Business Warehouse) | thomas jung | florian pfeffer | lars breddemann
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Chandrababu naidu marasa
    Feb 28, 2018 at 12:11 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 28, 2018 at 12:02 PM

    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/50f4ee6253134d3cafa25b9444f0c5a9.html

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

    Best Regards

    Madhusudan

    Add comment
    10|10000 characters needed characters exceeded