Video about CDC for Oracle Databases in SSIS 2012

This video presentation Rakesh Parida (MSFT) demonstrates how to perform CDC for Oracle databases using SSIS 2012. You'll learn how the CDC features work, how to create and administer the CDC service, as well as how to use logs and traces to troubleshoot the service.

Must have ALTER DATABASE privilege on the Oracle target. Only will find that out after much effort has been expended.

Zork

15 Jul 2014 8:59 PM

The video is helpful for setting up the CDC service, but that's only half the battle. Is there a follow up video that shows how to use the CDC components in an SSIS package to process the changes in an Oracle database? My google-fu is weak. The only examples I saw showed SQL to SQL, not Oracle to SQL.