Best way of regular data download from S4HC to MS SQL Server or Azure server

[Attila_Jakosa1]

We are in an implementation stage with ##S4HC Public Cloud and we have a BI system with the previous ERP, which we would like to continue feeding with data from SA

We need regular(daily/weekly) - preferably automated - data extractions of some data (eg. sales, production). The only way way we found so far is with using APIs. This does not seem to be a very efficient way for bigger volume data extraction (lot of overhead with json or xml data format vs. for example csv).

What would be the best way achieving this. We have MS SQL servers in house to store/transform data or at the worst case we can utilize an Azure Server.

Any help or pointers is much appreciated, Thx Attila

[Jerry_Lowery]

Hi Attila,

The recommended way of data extraction is via Extract CDS Views.

How to discover view for extraction:

https://blogs.sap.com/2019/06/06/discover-cds-view-based-extractors-from-sap-s4hana-cloud/

https://blogs.sap.com/2022/01/07/finding-the-right-cds-extractor-in-sap-s-4hana/

2884410 - CDS based data extraction: Delta capability

In the View Browser, you would want to look for views with the #DataExtraction attribute. Ideally you want the ones that support Change Data Capture (CDC).

Here a couple of blogs:

https://blogs.sap.com/2017/10/09/abap-core-data-services-part-2virtual-data-model-types/

Which is part of the series:

https://blogs.sap.com/2017/09/09/abap-core-data-services-introduction-abap-cds-view/

I also found this blog very informative:

https://blogs.sap.com/2018/03/19/s4-embedded-analytics-the-virtual-data-model/

There are several supporting Best Practices:
Core Data Services-Based Extraction with SAP S/4HANA Cloud (35D)

ABAP Core Data Services Extraction for SAP HANA (6N4)

ABAP Core Data Services Extraction for SAP Datasphere (53L)

ABAP Core Data Services Extraction for SAP Data Intelligence (53M)

Usually that means you are going with an OnPrem BW from SAP or Datasphere, etc.

Or you need a middleware that supports CDC (Azure might have a connector to do this )

Lastly, what is your use case? As you have probably seen, there are many reports and reporting analytics now built-in to S/4HANA Cloud public edition. Do you really need the separate BI if the reporting is already built in? What analytics are missing? or is the requirement a carry over from the "way we used to do it"?

https://community.sap.com/t5/technology-blogs-by-sap/embedded-analytics-sap-analytics-cloud-in-sap-s...

Please let us know if this helps

Thank you
Jerry