This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 30%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
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.
An Azure service for ingesting, preparing, and transforming data at scale.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
@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.
@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
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 !
@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,
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.
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