Skip to Content
0

Extract Data From S/4HANA 1709 using MS SSIS

Feb 21 at 08:50 AM

169

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Chandrababu naidu marasa Feb 28 at 12:11 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 28 at 12:02 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded