Skip to Content
0

Best method to Extract data Daily from S4HANA to SQL DB

Mar 15, 2017 at 03:08 AM

732

avatar image

Hi, I am looking for SAP best practices to extract data from S4HANA. Please note I am not referring to one time extract of full data. I am referring to daily extract where we can pull all delta everyday. Below are the method I have analyzed and what I think about them.

For some reason if we need to load data into SQL server for other system to consume data. I am looking to extract delta every time.

1) We can have SLT or SAP replication server to Load table with date time. Then use SAP DS to pull data from there into SQL DB. SLT would insert triggers and SAP Replication server means one more install. License cost too.

2) Or we can have DXC but it needs activation of embedded SAP BW. Not sure if DXC works well with SAP Data Services. Surely additional embedded SAP BW activation. Plus can we do delta like one more column with date time.

3) We can use old ODP method but looks like SAP is slowly deprecating this method. This worked well for delta and SAP Data Services in previous versions.

4) SAP recommends CDS (Core Data Services ) method and VDM over it. Not sure if this can be used in SAP Data Services and how we can have delta pull from this. I don't want to pull all data every time and then load only delta in SQL DB. I need a way to get delta.

Any help would be greatly appreciated.

Thanks,

Kalpesh

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

2 Answers

Dirk Venken
Mar 15, 2017 at 10:09 AM
0

The different alternatives discussed in https://blogs.sap.com/2017/03/13/extracting-data-from-sap-ecc/ apply to S4HANA, too.

Share
10 |10000 characters needed characters left characters exceeded
Kalpesh Pandey Mar 15, 2017 at 03:07 PM
0

Thanks, This means going forward SAP would support ODP Extractors in S/4HANA too. I referred to below blog.

https://blogs.sap.com/2016/07/07/data-extraction-supportability-of-sap-s4hana-on-premise-edition-1511-fps02/

"In some areas, extractors have been deprecated or can no longer be used with SAP S/4HANA 1511"
Thanks,

Kalpesh

Share
10 |10000 characters needed characters left characters exceeded