Included with SQL Server 2005 at no extra cost, SQL Server Integration Services (SSIS) offers a comprehensive, powerful, and competitive solution for data integration and ETL (extract, transform, and load). The successor to Data Transformation Services (DTS), SSIS is a platform for a new generation of high performance data integration technologies.
By adding change data capture (CDC) capabilities to SSIS, you can:
- Source operational data efficiently and in real-time
- Support real-time data warehouses and data marts
- Reduce or totally eliminate batch windows required to move data
- Keep data sources in sync
- Enable event-driven and stream-based processing
The SSIS CDC Accelerator
Attunity’s SSIS CDC Accelerator provides a complete CDC solution integrated with SSIS, supporting sources including Oracle and DB2. Using fully integrated wizards, the solution automatically generates configurations and packages that capture and process only the changes made to your data. The result is a reduction in batch windows which delivers efficient and real-time data integration.
The SSIS CDC Accelerator leverages the proven Attunity Stream CDC product line, and includes integration and management components that provide an end-to-end solution with SSIS.
"The SSIS CDC Accelerator from Attunity is a good example of partners building products that extend the SSIS Data integration platform. Customers will appreciate the increased efficiency and real-time capabilities that change-data-capture (CDC) enables. The product is really easy to use and we are impressed by its functionality and its seamless integration with SSIS."
Donald Farmer
Group Product Manager
Microsoft Corporation
|
Supported Data Sources
- DB2 (Mainframe)
- DB2/400 (AS/400)
- Oracle 9i
- Oracle 10g
- SQL/MP (Tandem)
- SQL Server 2000