Get data out of S4/HANA Cloud

[former_member603683]

Hi All,

we are currently moving over to S4/HANA Cloud and there will be a need for us to extract data out of S4/HANA Cloud and into a SQL Server table. The questions are therefore following:

1. Can we use SQL Server Integration Services (SSIS) to extract data out of S4/HANA Cloud?

2. If the answer to question 1 is a solid "No" then what Integration Tool(s) can be used to achieve our goal?

Thank you in advance for your help it is greatly appreciated!

[former_member603683 · Accepted solution]

Odata connector in Azure Data Factory can successfully be used to pull data from S4 Hana Cloud CDS Views (Odata) and into on-prem sql database(s).

[I044433]

Hi, m84ab1 ,

You can create a custom CDS view in SAP S/4HANA Cloud and enable the checkbox 'External API'. This would give you a OData URL which you can use to read the data from SAP S/4HANA Cloud.

You can visit this blog here that would give you more idea and steps.

Regards
Rohit

[former_member603683]

Hi Rohit,

thank you for your answer. I am familiar with your suggestion, however, how do I move the data via the Odata view and into a table on SQL Server?

[I044433]

Hi Nem,

You would need probably an ETL tool to do that.

Kindly close the question if answered.

Cheers

Rohit