SQL SERVER CDC

What it Means, Why it Matters, Tools, and Best Practices.

What is SQL server CDC ?

SQL Server CDC (change data capture) is a technology built into SQL Server that records insert, update, and delete operations applied to a user table and then stores this changed data in a form consumable by an ETL application such as SQL Server Integration Services (SSIS).

Data Warehouse Automation

Change data capture, or CDC, is a technology that detects and records changes made to a database and replicates them to other databases or applications. Users of SQL Server may be familiar with Microsoft's CDC for SQL Server feature. Microsoft's native change data capture feature is not the only option for CDC in SQL Server environments, however. Today there are innovative third-party solutions for both SQL database replication and change data capture that offer significant advantages over Microsoft's built-in SQL Server CDC functionality.

The Advantages of Using Qlik Replicate and Qlik CDC for SQL Server

Qlik CDC for SQL Server is a log-based change data capture technology that allows you to offload change tables and data distribution from the source database—unlike Microsoft's SQL change data capture function which necessitates the creation of internal change tables. By utilizing database logs to read DML changes, Qlik CDC for SQL Server capability minimizes impact on your source systems, providing you with the most efficient and least resource-intensive approach to change data capture.

Moreover, because CDC for SQL Server is integrated with Qlik Replicate (formerly Attunity Replicate), our high-performance data replication and data ingestion tool, there's no need to write your own polling mechanism. Qlik Replicate works seamlessly with most ETL, EAI, and data integration products and enables optimized ingestion into data warehouses as well as Hadoop and big data platforms by leveraging native utilities and APIs. Qlik Replicate is also easy-to-use, supplying you with an intuitive graphical interface that eliminates the need for manual scripting and empowers your teams with fast, automated data integration capabilities.

The most important difference between Qlik CDC for SQL Server and SQL Server's built-in CDC feature, however, is our solution's support for a wide range of source and target platforms. By offering efficient, affordable data replication for all major relational databases as well as SAP applications, data warehouses, and mainframes, Qlik Replicate lets you standardize on a single strategic solution for all your replication needs. And by allowing you to deliver data to the broadest range of platforms, our solution enables you to consolidate and load data quickly where you want it when you want it.

Popular SQL Server CDC resources

EBOOK

Data Warehouse Automation in Azure for Dummies

ON-DEMAND WEBINAR

Express Scripts Driving Digital Transformation from Mainframe to Microservices

EBOOK

Comparison Guide: Top Cloud Data Warehouses

Leveraging Your SQL Server Investments with Qlik CDC for SSIS

For firms that want to leverage their existing SQL Server licenses and expertise, we offer our log-based, non-invasive CDC technology in a software solution fully integrated with SSIS and Business Intelligence Development Studio. Qlik CDC for SSIS is a powerful data replication solution that enables you to stream changed data across your enterprise data sources and implement real-time BI and data warehousing. Our intuitive wizards simplify and accelerate deployment while helping you create replication solutions that are lightweight and easy to maintain.

See how the Qlik Data Integration Platform helps streamline, automate and accelerate your end-to-end data pipeline.

Want to learn more about our SQL Server CDC technology?