I am doing some work at the moment working out options to enable Change Data Capture (CDC) within Microsoft SQL Server 2012. As always there are a number of blogs, articles etc on the web that give you a head start.
As I find the ones that are useful I will add them here.
CDC for Oracle Data Sources
Microsoft SSIS 2012 (Enterprise Edition) has OEM’d the Attunity CDC capability to provide CDC transactions from Oracle data sources:
Quick cheat sheet on how to install the various components – http://blogs.msdn.com/b/mattm/archive/2012/03/26/cdc-for-oracle-in-sql-server-2012.aspx
Technical Video showing how the Attunity CDC module for Oracle works within the Microsoft Stack. – http://technet.microsoft.com/en-us/sqlserver/jj218898.aspx
CDC for SQL Server Data Sources
Using CDC within SSIS Flows