Setup sync between oracle and SQL Server / Azure database for postgerSQL using ADF

Question

Setup sync between oracle and SQL Server / Azure database for postgerSQL using ADF

Kriti Bhardwaj 1

We are trying to setup sync between oracle database and Azure database for postgreSQL using ADF. We want whatever changes we made on source should be reflected on destination.
If there is any other way to do the same please provide the documentation.

1 answer

Your answer

Answer 1

ShaikMaheer-MSFT 38,546 Microsoft Employee Moderator

Hi @Kriti Bhardwaj ,

Thank you for posting query in Microsoft Q&A Platform.

Similar kind of implementation documented at below link by considering SQL server and Azure SQL as source and Sink. Could you please take implementaion logic from there and try to use it in your case?
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-change-data-capture-feature-portal

Please let us know how it goes or if any further queries.

Kriti Bhardwaj 1 Reputation point

2021-12-22T12:40:07.527+00:00

This is completely different, here they are implementing CDC on Azure managed instance database and according to that I will need to implement CDC on oracle database, and implementing CDC on oracle is completely a big task in itself. Is there any another way of doing it?
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2021-12-23T17:20:15.073+00:00

Hi @Kriti Bhardwaj ,

Could you please check below documentation logic, where we can use some watermark columns and Lookup activity, Copy activity, Stored procedure activity to achieve incrementally load data.
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-portal

Please let us know how it goes.
Kriti Bhardwaj 1 Reputation point

2021-12-27T05:00:44.497+00:00

Thank you @ShaikMaheer-MSFT . I'll just try this and let you know if it works or not.

Share via

Setup sync between oracle and SQL Server / Azure database for postgerSQL using ADF

1 answer

Your answer