CDC for ETL

Change Data Capture That Works Seamlessly With Any ETL Tool

Attunity provides change data capture (CDC) software that complements ETL tools, allowing enterprises to design real-time and efficient data integration solutions, delivering timely information to the people who need it.

Leveraging Attunity CDC (formerly Attunity Stream) log-based CDC technology, the solution captures only the changes made to underlying source systems, eliminating the need for periodic batch jobs and freeing up valuable batch windows. Furthermore, it works seamlessly with any ETL tool by providing change tables that can be read using SQL, enabling changes to be processed in mini-batch, micro-batch, or in a continuous stream.

Attunity Solutions - CDC for ETL
 


Key Benefits

  • Provides real-time information to support operational business intelligence
  • Eliminates the need for batch windows
  • Designed for minimal impact on source systems
  • Available for many data sources and platforms
  • Supports all the leading ETL products
  • Leverages existing ETL investments
  • Reduces the required ETL resources and respective costs
  • Lower the risk of bulk process failures
  • Easy and cost-effective implementation

Leading ETL vendors including IBM, Oracle, and Business Objects have chosen to rely on Attunity CDC technology to extend their ETL offering. In addition, Attunity works closely with Microsoft SQL Server Integration Services (SSIS) for which a dedicated CDC accelerator is now available.


Supported ETL Tools

Attunity CDC works with the following ETL tools:

  • IBM WebSphere DataStage (formerly Ascential DataStage)
  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft SQL Server Data Transformation Services (DTS)
  • Oracle Data Integrator (formerly Sunopsis)
  • Oracle Warehouse Builder (OWB)
  • BusinessObjects Data Integrator/Services
  • SyncSort DMExpress
  • Expressor
  • Talend
  • Cognos DecisionStream
  • Informatica PowerCenter
  • SAS Data Integration Server
  • OpenText/Hummingbird Genio
  • Embarcadero DT/Studio