Loading data incrementally from an on-premise Oracle database

pmscorca 237 Reputation points


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.
8,522 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,256 Reputation points Microsoft Employee

    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



    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.