locked
Partial Replication of Oracle 12C on-prem DW to Azure SQL DB RRS feed

  • Question

  • I am looking for options to replicate a part of our on-prem Oracle DW (lets say last 2 months) to a SQL Database on Azure. I have a number of Question I need help with?

    1. Currently the on-prem DW is updated with a informatica batch process scheduled to run every night. Can ADF (or any other solution) be used to update the DB on Azure.

    2. Does ADF support incremental updates and would it affect the on-going transactions on the on-prem DW

    3. can anyone share some case studies with me 

    Thanks

    Wednesday, March 20, 2019 3:46 PM

All replies