Cloud data integration API initial and delta call with postman

[Jacky_Liu]

Hello Cloud data integration api PE or expert ,

From S4HC 2002 , Cloud data integration(CDI) api exposed(communication scenario: sap_com_0531) . We can use DI(BTP data intelligence) to call it realize initial and delta extract .

My question is how to use code like Python Java , C# to call CDI in S4HC to realize initial and delta extract cds from S4HC . The reason is some middle customer don't have BTP DI, but they have requirement in data integration between S4HC and third party analysis system .

Best regards!

Jacky Liu

[Jacky_Liu · Accepted solution]

Hi, Jerry,

I have emailed to Hanna, Shady and he suggested the following linkage . This document explain the method . We need to create subscription first , then we can get the delta token .

Thanks for checking into this again!

https://wiki.wdf.sap.corp/wiki/display/bw4ds/Cloud+Data+Integration+for+ABAP+CDS

Best regards!

Jacky Liu

[Jacky_Liu]

Hi, Jerry,

Thanks for the information !

There is odata cloud data integration API(CDI) whose communication scenario is sap_com_0531 which can be consumed by BTP data intelligence . The overview of S4C cdi is in the following blog . I can extract data from CDI with postman . But I don't know how to use delta ETL from CDI .

Part 2 – SAP S/4HANA Cloud Data Integration Overview | SAP Blogs

https://my300018-api.saps4hanacloud.cn/sap/opu/odata4/sap/cdi_cds/cdi_cds/sap/c_purchaseorderitemdex...

Best regards!

Jacky Liu

[Jerry_Lowery]

Hi Jacky

Sounds like the communication arrangement you are interested in is SAP_COM_0042.

This blog has some good explanation.

https://blogs.sap.com/2019/12/13/cds-based-data-extraction-part-i-overview/

When you enable SAP_COM_0042, a number of RFCs and SOAP interfaces are exposed.

In this case you would need to emulate the communication interface between BW and S/4HANA Cloud.

Basically you would need to create an SAP ODP Connector.

Another option is to expose the desired/custom CDS views as ODATA services and use the built in OData operations for $top and $skip and also to filter by date. This approach is not recommend for mass data extraction, so careful testing and monitoring would be necessary to avoid performance impacts.

I hope this information is helpful for you

Thank you Jerry