SQL CDC, or SQL change data capture, refers to the processes and technologies used for detecting and capturing changes made to a SQL Server database. In 2008, Microsoft introduced SQL Server change data capture, a technology designed to make it easier for users of SQL Server to capture and record (Data Manipulation Language) DML changes and provide the details of those changes to other systems in an easily consumable format.
In the past, database administrators and developers were forced to use SQL replication, timestamp fields, database triggers, or complex queries to implement SQL CDC. With log-based solutions like SQL Server CDC or Qlik (Attunity) universal SQL CDC technology, however, they can now track, record, and make changed data consumable by SSIS and other ETL tools, without having to write scripts or place unnecessary overhead on source systems.
Log-based SQL CDC accesses the transaction log associated with a SQL Server database in order to detect and capture INSERT, UPDATE, and DELETE statements. With Microsoft's native SQL CDC tool, a Capture job reads changes from the transaction log and populates staging or CDC tables on the source system with the appropriate changed data. Because the changed data accumulates on the source system until deleted by a Cleanup job, high volumes of changes can strain available disk space and processing power. Users also contend with complex troubleshooting and maintenance processes.
With Qlik (Attunity) zero-footprint architecture, there's no need to install agents on your source or target systems. And our log-based, low-impact SQL CDC technology allows you to capture and deliver changed data to a wide range of target platforms, without adversely affecting the performance of your source systems. Our non-intrusive CDC technology combined with in-memory stream processing and our resilient WAN transfer engine improve the performance of high-volume data delivery and boost transfer speeds to off-premises and cloud-based platforms.
Qlik (Attunity) SQL CDC capabilities are easy to use, accelerating implementation and time-to-value. Built into Qlik Replicate (formerly Attunity Replicate), our universal data replication and ingestion platform, Qlik (Attunity) CDC for SQL Server is accessible from a user-friendly web-based monitoring console, featuring a graphical user interface that streamlines and simplifies configuration, monitoring, and troubleshooting tasks.
Qlik Replicate (formerly Attunity Replicate) is also extremely flexible and highly automated, allowing you to deliver CDC data at near-zero latency, in sequences of transactions or in optimized batches, and to replicate schema changes dynamically to target systems. Qlik Replicate (formerly Attunity Replicate) also can convert source updates to a live message stream to Kafka message brokers, which in turn can feed one or more Big Data targets. Suitable not only for MSSQL replication but also for Oracle and DB2 replication tasks, Qlik Replicate (formerly Attunity Replicate) supports the widest range of source and target platforms, including all major relational databases, data warehouses, Hadoop distributions, and cloud storage platforms.