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(89.60000000000001, 14.000000000000002%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Hi,
I have a on-premise application that required to get data from Azure SQL DB and transform it to consume by my application. Is there a way to do it real-time?
![](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(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Hi @Lotus88 , just wanted to check if you need any more details. If any answer helped you, you can mark it 'Accept Answer'.
Yes you can do this with Azure SQL Data Sync. You can enable "Automatic Sync" and set a number for Seconds, Minutes, Hours, or Days in the Sync Frequency section. Please try this step-by-step procedure to setup Azure SQL Data Sync. The tool is free.
Hi, but i need to do some data transformation. My on-premise application is using oracle DB. Can Azure SQL data Sync able to achieve data transformation ?
No, Azure SQL Database can sync only to SQL Server on-premises databases. However, you can create a custum solution using Sync Framework. SQL Data Sync is based on Sync Framework. You can adapt this and this resources to your needs.
You can also try commercial tools like SymmetricDS and consider doing the transformation on the Oracle side.
Hi @Lotus88 , welcome to Microsoft Q&A forum.
Adding on top of @Alberto Morillo answer, we can also use ADF to achieve this requirement. ADF can read from oracle on-premise data source, transform the data as needed and then populate the Azure SQL Database. We can then define the Schedule Trigger based on our scheduling requirement. However there is not a direct step by step document available but below 2 articles can help us create it:
Copy data from and to Oracle by using Azure Data Factory or Azure Synapse Analytics
Copy and transform data in Azure SQL Database by using Azure Data Factory or Azure Synapse Analytics
Referenced Article: Azure data factory: data migration from Oracle 12g to Azure SQL server
Hi, my understanding of ADF can only schedule an interval to sync the data but not real-time right?
No I need to read from Azure SQL DB and write to Oracle DB.
Thanks for replying back and sorry for the miss from my side.
The above links will help us in creating the pipelines that can read from oracle and write to oracle as well. However, for scheduling in ADF it would not be real time, instead we can set up a trigger for every min if that suits your requirements.
Another way to achieve real time sync is to use Azure Logic App, where we can trigger a workflow based on any activity on the table in database. As an example if there is a new record inserted. or any update happened in a table, we can read it through Azure Logic App and then using Oracle Connector we can connect to on-premise Oracle database and replicate it accordingly. Again Logic Apps can also be scheduled.
Use Azure Logic Apps to Detect when a new SQL record is inserted: This can be used to read any change and trigger a workflow.
Get started with the Oracle Database connector: This can be used to perform operations on Oracle database. We again might need to customize these tasks based on our requirements.
Please let us know if this helps or else we can discuss further on the same.
Hi, I did consider Azure logic apps and if insert 1 new record should be ok but the user is going to upload large volume of records like 100K to Azure SQL DB at one shot. Can logic apps handle such a large volume?
Thanks for responding back. Yes Azure Logic App can handle large volume of data but there are different way to efficiently handle larger data sets as mentioned in the below link like Pagination, using Stored procedure, until loop etc.
I would request you to once go through these methods as mentioned in the article and see if they can fir into requirements.