Getting S/4HANA Cloud Data via OData with ABAP CDS Views, with SAP CPI into SQL Server

[venkat_kodi]

Hi all,
We have new SAP S/4HANA Cloud as source system and we want to get this data via OData Services & ABAP CDS Views, with SAP CPI into SQL Server. How to get this S/4HANA data into SQL Server, please?

Regards,
Venkat.

[OwenLiu]

We helped you to accept the answer, since there were no updates after 7 days.

You can unaccept it anytime if you have further questions.

[PrasanthM · Accepted solution]

Hi Venkat,

If you want to utilize SAP Cloud Integration(Formerly SAP CPI), you can leverage the released APIs in SAP S/4HANA Cloud which are listed in API hub to pull the data you require and then send it to SQL Server. Additionally, if you want to pull the data from CDS views, you can create custom CDS views and pull the data by exposing the CDS views via custom communication scenarios.

You could do this by designing the iflow based on your requirement.

As an example, you can follow the blogs https://blogs.sap.com/2022/09/06/extract-and-integrate-data-from-sap-s-4hana-cloud-using-cpi-part-i/ and https://blogs.sap.com/2022/09/06/extract-and-integrate-data-from-sap-s-4hana-cloud-by-using-cpi-part...

Best Regards,

Prasanth

[venkat_kodi]

Hi Andrew,

Thanks for reply and I think you didn't understand my question clearly, please. I want to get S/4HANA Cloud data into SQL Server with SAP Cloud Platform Integration (CPI) after creating the ABAP CDS View & OData Services for it, please.

Regards,

Venkat.

[andrewfloriano]

Hello Venkat,

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

Also, HANA DB can connect via SDA to MSSQL. If you want to connect via MSSQL to HANA DB, you can use the HANA Client.

For more information please check:

https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.03/en-US/66a4169b84b2466892e1af9781...

Kind Regards,