Extract and Integrate Data from SAP S/4HANA Cloud using CDI
For all SAP solutions / applications – especially in the context of the Intelligent Enterprise Suite – it is important to support the data integration provided by SAP Data Intelligence. CDI (Cloud Data Integration) provides data extraction capabilities based on OData services. In addition to the OData specification it adds services to find and manage data extraction services as well as handle full load in packages and delta load. SAP S/4HANA Cloud Edition Communication Scenario is SAP_COM_0531 – enables the access to the CDS view extraction via CDI (available with SAP S/4HANA CE 2002). The application data is made available for further data processing in SAP Data Intelligence pipelines. SAP Data Intelligence contains by default a Pipeline operator, which allows to consume data exposed via CDI directly in Pipelines.
- Analyse the different activities/steps of a business process
- Example process: Order2Cash
Source System: SAP S/4HANA Cloud
Target: Example scenario is to download the data in csv format from SAP Data Intelligence -> System Management tile. SAP Data Intelligence provides various options to extract and integrate data to other target systems e.g., Other SAP systems and 3rd Party Systems.
Example CDS View Data Extractors:
Data Extraction for Sales document Item
Billing Document Item Basic Extraction Data
Process Flow Diagram
Data Flow Diagram
Integration with SAP Data Intelligence via CDI(Cloud Data Integration)
SAP Data Intelligence example for extracting the data from SAP S/4HANA Cloud using Cloud Data Integration option and saving the extracted data in a LOCAL storage.
Step 1: Create a Communication Arrangement using Communication Scenario “SAP_COM_0531” in SAP S/4HANA Cloud.
Step 2: Create a connection of type “CLOUD_DATA_INTEGRATION”.
Step 3: SAP Data Intelligence Pipeline using Cloud Data Integration Operator.
Step 4: Configure the Cloud Data Integration Operator with example CDS view data extractor: C_SALESDOCUMENTSCHEDLINEDEX.
Step 5: Save and execute pipeline.
- Data is extracted from SAP S/4HANA Cloud using Cloud Data Integration option
- File will be created in local storage
- Navigate to System Management from SAP Data Intelligence Launchpad->Files
- Expand folder Files under My workspace to find the created file with extracted data from SAP S/4HANA Cloud.
- Click on the icon “Show Actions” to down the load file into the local storage by using the option “Export File”.
Thank you for this blog. Would this approach also work for getting data from S/4HANA Cloud into Enterprise HANA?
Yes, there are controls to connect with Enterprise HANA in SAP Data Hub and by using those controls the above approach will work for getting data from S/4HANA Cloud into Enterprise HANA.
Thanks & Best Regards,
CDI Presentation how data is getting extracted at this level it looks good , could you pl add how data could flow to legacy system & S/4 HANA to & fro ( eg LIMS-laboratory information system , DCS - distributed control system etc.) .