on 03-15-2017 3:08 AM
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
Thanks, This means going forward SAP would support ODP Extractors in S/4HANA too. I referred to below blog.
"In some areas, extractors have been deprecated or can no longer be used with SAP S/4HANA 1511"
Thanks,
Kalpesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The different alternatives discussed in https://blogs.sap.com/2017/03/13/extracting-data-from-sap-ecc/ apply to S4HANA, too.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can VirtDB Mass Data Extractor Tool be used to directly extract from CDS Views to SQL Server?
https://virtdb.com/efficient-delta-extractions-sap/
Thanks,
Sri
User | Count |
---|---|
93 | |
11 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.