[If you’re using SSIS to pull data out of Oracle then this may be of interest to you.]
In SQL Server 2008 Microsoft introduced a feature called Change Data Capture (CDC) which basically enables you to query a SQL Server table from within SSIS and ask for all rows that have been created or changed since a given point-in-time. Attunity have now released a product called Oracle-CDC for SSIS that purportedly allows you to do the same with a table stored in Oracle too.
Features include:
- Non-intrusive, log-based Oracle CDC for Oracle 9i, 10g, and 11g
- Full integration into SSIS and the Business Intelligence Developer Studio
- Generation of SSIS packages for processing Oracle data, reducing development efforts and ensuring best practice implementation
- Automatic synchronization of full-load and CDC processing
- Monitoring and control of CDC processing
If you’re interested in knowing more then Attunity are running a webinar on 3rd June, details are at https://www1.gotomeeting.com/register/543263673.
Attunity are the company that provide the officially sanctioned Microsoft connectors for Oracle and Teradata so they have a pretty good pedigree; Oracle-CDC might just be worth paying attention to.
-Jamie