How to copy data from Azure SQL Database to SAP system using Azure Data Factory?

Question

How to copy data from Azure SQL Database to SAP system using Azure Data Factory?

Atharva Jadhav 20

I am looking for a way to copy data from Azure SQL Database table to SAP system using Azure Data Factory pipeline (Push model). Is this possible? When checked in linked services I cannot find SAP connectors in SINK DATASET. Unfortunately I am unable to find any articles on this. Any insights or suggestions would be greatly appreciated. Thank you.

User's image

MartinJaffer-MSFT 26,236 Reputation points

2023-03-24T21:11:13.66+00:00

@Atharva Jadhav Did any of my suggestions help you? If it resolved your issue, please mark as accepted answer. If you found your own solution, please share it with the community.

2 answers

Your answer

MartinJaffer-MSFT 26,236 Reputation points

2023-03-24T21:11:13.66+00:00

@Atharva Jadhav Did any of my suggestions help you? If it resolved your issue, please mark as accepted answer. If you found your own solution, please share it with the community.

Answer 1

MartinJaffer-MSFT 26,236

@Atharva Jadhav Hello and welcome to Microsoft Q&A.

As I understand, you are having difficulty finding details on what SAP connectors are supported as source or sink.

For this, I recommend checking the Source/Sink Matrix in Connector Overview article. For SAP in specific, here is a link to SAP connectors overview.

There are many SAP variants. in the below, checkmark ✓ is supported, dash - is not. It is in the form of (Source) / (Sink)

SAP Business Warehouse Open Hub	✓/−
SAP Business Warehouse via MDX	✓/−
SAP HANA	✓/✓
SAP Table	✓/−
SAP Cloud for Customer (C4C)	✓/✓
SAP ECC	✓/−
SAP CDC		(Mapping Data Flows Only) ✓/-

Another option is SAP in Logic Apps. This document feels slightly intimidating to me, but it sounds like it has more sink support.

If you let me know which SAP type, maybe I can come up with another solution,

Atharva Jadhav 20 Reputation points

2023-03-16T07:09:12.69+00:00

Hi @MartinJaffer-MSFT and thanks for your response. I wish to load data into a SAP table from an Azure SQLDB using ADF.

The SAP type would be a SAP Table.

Hence, I was looking for a SAP table connector in the SINK, but it is not available. Is there any other way to achieve this?

I am wondering if an ODBC connector can be used to copy data to the SAP table activity.
MartinJaffer-MSFT 26,236 Reputation points

2023-03-16T23:35:16.7566667+00:00

Hmm, ODBC can write to HANA Table... I'm finding allusions to using ODBC to write to Table, but almost all articles are for reading using ODBC. This is on the SAP site. There are also mentions of using ABAP as intermediary..

I don't have a SAP instance to try with, so my knowledge of SAP side is limited.

Okay. Time to get creative. If pushing to SAP is hard, how about SAP pulling from SQL or other Azure bits.
These SAP provided connectors use ODBC. I get the feeling ADF could push ODBC.

Ahh I found a tutorial on directly connecting SAP and SQL. Without Data Factory. T

Answer 2

MartinJaffer-MSFT 26,236

@Atharva Jadhav Found it!

There is a connector on the SAP side for Azure SQL Database. With this you should be able to pull from SQL without using Data Factory

Atharva Jadhav 20 Reputation points

2023-03-23T12:56:22.1566667+00:00

Hi, @MartinJaffer-MSFT

Thanks a lot for all the inputs !

To implement pull model using Azure Logic App and RFC function in SAP from ASQLDB is the way forward for now. Will keep you posted.

Cheers !

Share via

How to copy data from Azure SQL Database to SAP system using Azure Data Factory?

2 answers

Your answer