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

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:

SSIS Design pattern information

 SSIS Data Flow components and Control Flow task

Troubleshooting Guides

Leave a Comment
  • Please add 3 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Please check to see if it's possible to use CDC with an Oracle Partitioned table.

  • Patris_70 edited Revision 5. Comment: added en-US tag and title

  • Richard Mueller edited Revision 7. Comment: Removed (en-US) from title

  • Is it possible with Oracle table views?

Page 1 of 1 (4 items)