What is efficient way to connect to SAP extractor and load data into adls gen2 using adf pipeline

Praveena Uppalapati [ELB] 51

I want to load data from SAP extractors into the adls gen2 lake storage using data factory pipeline. Could someone help me with the efficient way for this process.

1 answer

KranthiPakala-MSFT 46,597 Reputation points Microsoft Employee

2021-08-16T10:15:39.467+00:00
Hi @Praveena Uppalapati [ELB] ,

Welcome to Microsoft Q&A forum and thanks for your query.

Not sure if you have got a chance to see this whitepaper, Please go through this whitepaper published by ADF product team on various SAP data integration scenarios using Azure Data Factory.

SAP Data Integration using Azure Data Factory.

This should help provide you insights on how to use Azure Data Factory for SAP data integration. Do let us know if you have further query.

Thank you

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.
Please sign in to rate this answer.
Praveena Uppalapati [ELB] 51 Reputation points

2021-08-16T10:58:20.723+00:00

@KranthiPakala-MSFT Thank you for the response. Already I have gone through the whitepaper.

I could see from the documentation that I can access SAP extractors from SAP ECC connection.
I have large volumes of data to be loaded from SAP extractors, where in SAP ECC connection is slow compared to SAP table Connection and also recommended for low volumes of data.
So please recommend if there is any optimal and efficient way to load data from SAP extractors.

KranthiPakala-MSFT 46,597 Reputation points Microsoft Employee

2021-08-19T02:58:01.58+00:00

Thanks for getting back @Praveena Uppalapati [ELB] .

I am not familiar with SAP extractors, but as per my conversation with internal team, if it is some upper layer program to view the data, you could utilize SAP Table connector by considering to write custom RFC yourself to extract the data.

For more info about custom function module please refer to this doc: https://learn.microsoft.com/azure/data-factory/connector-sap-table#create-custom-function-module

Do let us know if you have further query.

Thank you

KranthiPakala-MSFT 46,597 Reputation points Microsoft Employee

2021-08-24T02:50:01.223+00:00

Hi @Praveena Uppalapati [ELB] ,

We still have not heard back from you. Just wanted to check if the above suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thanks

Praveena Uppalapati [ELB] 51 Reputation points

2021-09-30T06:17:32.143+00:00

Thanks for the response. we still cant access SAP extractors. But your answer helped us create a view on our own from SAP table connection. Thank you.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

What is efficient way to connect to SAP extractor and load data into adls gen2 using adf pipeline

1 answer

Your answer