Push updates to SAP Tables from Azure SQL

Question

Hello Team,

I'm trying to prepare design for pushing updates to SAP Tables from Azure SQL on schedule basis. I need your help to see what are the option I can go with in terms of Azure services.

I'm thinking to get this task by below services. Please share your thought on best approach.

1. Develop Azure function which will connect to Azure SQL and compare the SAP table, calculate the delta and push the changes accordingly. 

2. I believe I can do the same thing with logic Apps as well. Correct?

3. I believe I can do the same thing with Azure Data lake and Azure Pipe lines too. Correct?

Request you for your input.

Thanks.

Answer 1

Hello Team,

I'm trying to prepare design for pushing updates to SAP Tables from Azure SQL on schedule basis. I need your help to see what are the option I can go with in terms of Azure services.

I'm thinking to get this task by below services. Please share your thought on best approach.

1. Develop Azure function which will connect to Azure SQL and compare the SAP table, calculate the delta and push the changes accordingly. 

2. I believe I can do the same thing with logic Apps as well. Correct?

3. I believe I can do the same thing with Azure Data lake and Azure Pipe lines too. Correct?

Request you for your input.

Thanks.

Good day <?!?>

First, it will give better feeling to have name or manful nickname and not to speak with "abc" and random number

Regarding your question, please clarify :

Where are the table which you want "pushing updates to SAP Tables"?!? Are these tables in the Azure SQL Database?

Where do you take the data from and to where. Please clarify the architecture again since it is not clear to me from your original message and the options which you mentioned

If the data is in Azure SQL Database or SQL Server on premises and you want to sync it with another Azure SQL Database or SQL Server on premises, then all your options make no sense in first glance. Why not simply sync the data using Azure Data sync, Azure Data Factory, SSIS, Replication, and so on... each tool fit to different scenario but none of yours solution make sense for most cases.

Please explain the architecture of your system and we will chose a tool that fit your needs

---

Ronen Ariely  [Personal Site]    [Blog]    [Facebook]    [Linkedin]

Answer 2

Hi Ronen, I'm sorry for my confusing post.

Here is what I'm trying to do.

Source is Azure SQL and destination is SAP HANA tables. I have a couple of columns in source and destination that they are matching. I want to push the updates from Azure SQL Table (a couple of columns) to it's respected SAP HANA Table (Respected 2 columns). I'm thinking to achive this using Azure data factory pipelines. 

Please let me know if you think there a better way to do it. 

Thanks.