SSIS CDC with Oracle 11g
I was wondering if I could use SSIS as an ETL tool to extract data from Oracle 11g and load it into another Oracle 11g destination and apply CDC. I used SSIS CDC with MS SQL; however I had to include CDC in the database, so I was wondering if I could do the same.
Your help is really appreciated.
+3
source to share
1 answer
You can follow the following Microsoft Docs topics to learn more about Microsoft SQL Server 2012. Capturing Data for Oracle with Attunity.
- https://social.technet.microsoft.com/wiki/contents/articles/7644.microsoft-sql-server-2012-change-data-capture-for-oracle-by-attunity-topics.aspx
- https://docs.microsoft.com/en-us/sql/integration-services/change-data-capture/change-data-capture-service-for-oracle-by-attunity
This link contains useful information on how to set up and use this component. so I think this is what you are looking for.
Also to work with oracle using SSIS 2012 you need to download the oracle connectors:
+1
source to share