question

WenjianFeng-7847 avatar image
WenjianFeng-7847 asked ·

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

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
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
PRADEEPCHEEKATLA-MSFT answered ·

@WenjianFeng-7847 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.


1 comment Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Okay, got it. Thanks a lot.

0 Votes 0 · ·