ReplTip — Attunity CDC to replace Oracle Publishing

ReplTip — Attunity CDC to replace Oracle Publishing

By Taiyeb Zakir
Microsoft SQL Escalation Support

Starting with SQL 2012, Heterogeneous Replication to non-SQL Server Subscribers and Oracle Publishing is deprecated. To move data from Oracle to SQL, Attunity provides a feature called Change Data Capture for Oracle and it is shipped with SQL 2012 / SQL 2014 RTM media. This feature allows using Change Data Capture in a SQL Server database, with an Oracle
database as the source of data. One notable advantage of this feature is that very low data latency can be achieved; another is that knowledge of Oracle is not required for ETL development To get more details see links below

http://social.technet.microsoft.com/wiki/contents/articles/7644.microsoft-sql-server-2012-change-data-capture-for-oracle-by-attunity-topics-en-us.aspx

CDC for Oracle

Databases using SQL Server Integration Services 2012 (SQL Server Video)

http://technet.microsoft.com/en-us/sqlserver/jj218898.aspx

By Rakesh Parida

Blog Overviews

http://copperblueblog.com/category/cdc/

http://www.mattmasson.com/index.php/2011/12/cdc-in-ssis-for-sql-server-2012-2/