We in no way work for Attunity but we were asked to test drive a beta version of their Oracle CDC solution for SSIS. Everybody should know that moving more data than you need to takes too much time and uses resources that may better be employed doing something else. Change data Capture is a technology that is designed to help you identify only the data that has had something done to it and you can therefore move only what is needed. Microsoft have implemented this exact functionality into SQL server 2008 and I really like it there. Attunity though are doing it on Oracle.
DISCLAIMER: This is a BETA release and some of the parts are a bit ugly/difficult to work with. The idea though is definitely right and the product once working does exactly what it says on the tin. They have always been helpful to me when I have had a problem with the product and if that continues then beta testing pain should be eased somewhat.
In due course I am going to be doing some videos around me using the product. If you use Oracle and SSIS then give it a go.
Here is their product description.
Attunity is a Microsoft SQL Server technology partner and the creator of the Microsoft Connectors for Oracle and Teradata, currently available in SQL Server 2008 Enterprise Edition.
Attunity released a beta version of the Attunity Oracle-CDC for SSIS, a product that integrates continually changing Oracle data into SSIS, efficiently and in real-time. Attunity designed the product and integrated it into SSIS to create the simple creation of change data capture (CDC) solutions, accelerate implementation time, and reduce resources and costs. They also utilize log-based CDC so the solution has minimal impact on the Oracle source system. You can use the product to implement enterprise-class data replication, synchronization, and real-time business intelligence (BI) and data warehousing projects, quickly and efficiently, leveraging their existing SQL Server investments and resource skills.
Attunity architected the product specifically for the Microsoft SSIS developer community and the product is available for both SQL Server 2005 and SQL Server 2008. It offers the following key capabilities:
· Log-based, non-intrusive Oracle CDC
· Full integration into SSIS and the Business Intelligence Developer Studio
· Automatic generation of SSIS packages for CDC as well as full-loads of Oracle data
· Filtering of Oracle tables and columns at the source
· Monitoring and control of CDC processing
Click to learn more and download the beta.