Attunity, the company that makes Microsoft’s SSIS connectors for Oracle and Teradata (read more about those at Connecting to Oracle just got a whole lot better), have released (in beta) a new product called Attunity Oracle-CDC for SSIS. CDC stands for change-data-capture which is a method of easing the retrieval of new or updated data from a system of record by managing the complicated timestamp-based comparisons for you. SQL Server 2008 provides CDC capabilities within the database engine that can be leveraged within SSIS but up until now it was not possible to do the same for Oracle systems. Attunity’s product offers (so they say):
Log-based, non-intrusive Oracle CDC Fully integrated into SSIS and the Business Intelligence Developer Studio Automatic generation of SSIS packages for CDC as well as full-load of Oracle data Filtering of Oracle tables and columns at the source Monitoring and control of CDC processing If you’re using SSIS to extract data from Oracle (as I suspect many SSIS developers are) then it may be well worth evaluating this new product. Go and check it out at http://www.attunity.com/oracle_cdc_for_ssis or read the press release at http://www.attunity.com/press_releases.aspx?newsId=1218
-Jamie