Helpful information and examples on how to use SQL Server Integration Services.
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.
The video is availble online at http://technet.microsoft.com/en-us/sqlserver/jj218898.aspx .
For more information about the CDC for Oracle, see the CDC for Oracle in SQL Server 2012 blog post by Rakesh.
Must have ALTER DATABASE privilege on the Oracle target. Only will find that out after much effort has been expended.
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.