Oracle 12C本地DW到Azure SQL DB的部分复制 [英] Partial Replication of Oracle 12C on-prem DW to Azure SQL DB
问题描述
我正在寻找将部分我们的本地Oracle DW(比如说最近2个月)复制到Azure上的SQL数据库的选项。我有一些问题需要帮助吗?
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。目前,本地DW已更新,其中包含计划每晚运行的信息批处理。可以使用ADF(或任何其他解决方案)更新Azure上的数据库。
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。 ADF是否支持增量更新,是否会影响本地DW上的正在进行的事务
2. Does ADF support incremental updates and would it affect the on-going transactions on the on-prem DW
3。任何人都可以与我分享一些案例研究
3. can anyone share some case studies with me
谢谢
推荐答案
您好WMIBW并感谢您提出问题。
Hello WMIBW and thank you for your questions.
1. 数据 可以安排工厂定期从您的Oracle数据库中提取。 此文档 特别提及"Oracle 12c R1
(12.1)"。
1. Data Factory can be scheduled to pull from your Oracle database regularly. This doc specifically mentions "Oracle 12c R1 (12.1)".
2. Here is a tutorial on how to do incremental loads.
这篇关于Oracle 12C本地DW到Azure SQL DB的部分复制的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!