ADF extract data from an on-premises oracle database into azure SQL database in real time

Wenjian Feng 41 Reputation points
2020-06-02T02:02:42.407+00:00

We have lots of web application on-premises, and its database include: Oracle, SQL Server, MySQL and SAP HANA.

For Oracle DB, is it possible that ADF can extract data in read time?

When there is any update in Oracle database, ADF can SYNC these changes to Azure SQL Database immediately.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,617 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 77,901 Reputation points Microsoft Employee
    2020-06-03T04:39:45.037+00:00

    @Wenjian Feng Welcome to the Microsoft Q&A platform.

    With ADF you can schedule a query to run and get new data, but you'll need to do it to each table you have. A smart idea would be changing the application to insert in Oracle and also in a queue that would trigger your ETL.

    Note: It is a good choice to use ADF if you have limited changes/updates. In case, if you have more changes/updates - we need to do it to each table you have. That's becomes too complicated.

    You may refer SO thread which addressing similar issue: Near real-time ETL of Oracle data to Azure SQL

    Hope this helps. Do let us know if you any further queries.

    ----------------------------------------------------------------------------------------

    Do click on "Accept Answer" and Upvote on the post that helps you, this can be beneficial to other community members.