SAP - How to query an SAP transaction using Azure Synapse

Question

Hello Experts,

I need to get data from a SAP transaction, is this possible in Synapse? Is there any SAP connector that helps with this issue?

I tried to use SAP Tables, but it doesn't allow me to get data from an SAP transaction.

How can I overcome this problem?

Thanks for listening.

Answer 1

Hi Rafael Martins de Mendonça,

Thank you for posting query in Microsoft Q&A Platform.

Synapse Pipelines has in built connectors for below SAP family products. Click here to know more about same.

I am not much familiar with SAP products. So, I would request you to choose a connector from above list which can get data from SAP transaction.
If any of above connector cannot get you data from SAP transaction as it may not belongs to above products. Then you need consider finding SDKs or REST APIs which can interact with SAP transaction and gives you data back.

If APIs are there for SAP transaction, then Use web activity or REST Connector dataset in copy activity to make API call and get data from it. OR Consider writing your own code in and execute it using custom activity. The custom activity runs your customized code logic on an Azure Batch pool of virtual machines. OR You can consider writing your own code in Azure Functions and execute same using Azure Function activity.

Hope this helps.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.