Need to extract zreports from SAP HANA

Question

Hi,

I have a use-case where I want to extract data from SAP Hana. The use-case is as follows:

I have SAP Hana deployment from where I need to extract data. The data is stored in zreports which are extracted using T-Codes. Now, I want to extract the data from those zreports using Azure Data Factory and store it in Azure Data Lake for further processing.

How can I extract data from zreports which are binded to T-Codes using Azure Data Factory? Any help would be much appreciated.

Answer 1

You need to determine the tables, views, or calculation views that the Z-report accesses and use the SAP HANA connector to extract data directly from these tables or views.

If you have knowledge with SAP Data Services, you can extract data from SAP ECC and load it into ADLS Gen2 (you can face some increase in the costs if you need to handle non-SAP sources separately).

https://learn.microsoft.com/en-us/azure/data-factory/tutorial-hana-to-adls

I found this also (but I am not familiar with it) Theobald's Xtract Universal, you can integrated it with ADF to trigger and automate SAP data movements using command-line interfaces.

https://helpcenter.theobald-software.com/xtract-universal/knowledge-base/adf-integration-using-command-line