Skip to Content

Best method to Extract data Daily from S4HANA to SQL DB

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 15, 2017 at 10:09 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15, 2017 at 03:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded