Share via

Loading data incrementally from an on-premise Oracle database

pmscorca 1,007 Reputation points
2023-04-27T20:22:04.3533333+00:00

Hi,

I need to load data incrementally from an on-premise Oracle database.

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
    2023-04-28T18:47:06.4+00:00

    Hello @pmscorca ,

    Thanks for the question and using MS Q&A platform.

    You can use ADF to get the job done, you have to use a Self hosted intergration runtime (SHIR) so that ADF can communicate with the in-premise network .

    User's image

    Once you have SHIR , you will have to implement watermark logic to pull data from Oracle and write the same to sink using copy activity. Please read about the same here

    Thanks

    Himanshu

    Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues. 

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.