Microsoft SQL Server 2012 Change Data Capture for Oracle by Attunity Topics

Getting Started with CDC for Oracle by Attunity

Overview:

New in SQL Server 2012 is a Change Data Capture for Oracle by Attunity which allows you to continually copy data from Oracle to SQL Server. This feature is helpful in two common business scenarios:

1. Migrating from Oracle database to SQL Server 2012 systems - you can synchronize criticial tables throughout the migration timeframe by copying changes made to the Oracle tables into the SQL Server 2012 tables.
2. Data Warehousing using a SQL Server 2012 system. Changes can be capture from your Oracle database and sent to SQL Server 2012 databases to keep the data warehouse in sync.

Information

Download and Setup information:

• [[articles:Installing Microsoft SQL Server 2012 Change Data Capture for Oracle by Attunity]]
• SQL Server 2012 CDC for Oracle - A review of One Implementation blog by Microsoft Consultant Dimitri Furman

SSIS Design pattern information

• CDC in SSIS for SQL Server 2012 blog by Matt Masson from the SSIS product team

 SSIS Data Flow components and Control Flow task

• CDC Flow Components
• CDC Control Task 

Troubleshooting Guides

• [[articles:Troubleshoot Configuration Issues in Microsoft Change Data Capture for Oracle by Attunity]]
• [[articles:Troubleshoot CDC Instance Errors in Microsoft Change Data Capture for Oracle by Attunity]]