3

I was wondering if I can use SSIS, as an ETL tool to extract data from Oracle 11g and load it to another Oracle 11g destination, and apply CDC. I have used SSIS CDC with MS SQL; however, I had to enable CDC on the database so I was wondering if I can do the same thing.

Your help is really appreciated.

Hadi
  • 36,233
  • 13
  • 65
  • 124
user2597012
  • 581
  • 4
  • 9
  • 28
  • 2
    https://learn.microsoft.com/en-us/sql/integration-services/change-data-capture/change-data-capture-service-for-oracle-by-attunity – Yahfoufi May 31 '17 at 12:45

1 Answers1

0

You can follow the following Microsoft Docs Topics to learn more on Microsoft SQL Server 2012 Change Data Capture for Oracle by Attunity

This link contains helpful information on how to setup and use this component. so i think this is what you are looking for.

Also to work with oracle using SSIS 2012 you have to download the oracle connectors:

Yahfoufi
  • 2,220
  • 1
  • 22
  • 41
  • Thanks for your help, it is really useful. However, I am stuck at enabling CDC with Oracle 11g as our DBA says that we don't have a "stream". So Is it possible to apply this when we don't have a stream? – user2597012 Jun 05 '17 at 12:09
  • @user2597012 really sorry, i don't have a good experience in SSIS, i don't know exactly if that can be done. – Yahfoufi Jun 05 '17 at 14:08