WHAT IS CHANGE DATA CAPTURE?

If you're in the market for a data integration solution, you might have come across the term change data capture or its abbreviation CDC and might be wondering, "What is change data capture?" Change data capture refers to the process of identifying, capturing, and delivering changes made to a database, application, or mainframe system to a target database, data warehouse, or other type of data repository. By copying and loading only these changed records from the source to the target, change data capture minimizes the need for bulk load updating of a data warehouse or data mart and allows for real-time data integration.

What Is Change Data Capture: Enabling Real-Time Analytics in the Enterprise Data Warehouse

Change data capture is getting increasing attention from businesses faced with growing amounts of data to process—and less time to do it in. To stay competitive today, enterprises must strive to make the most up-to-date and complete data available to their front-line business users. And once they learn more about "what is change data capture", we think they'll realize that leveraging Qlik Replicate (formerly Attunity Replicate) advanced CDC technology is the easiest, most efficient way to do that.

What Is Change Data Capture: Minimizing Time-Consuming Batch Processing

To support business intelligence reporting and analytics, companies rely on the data warehouse as a centralized repository of data collected from multiple data sources. Typically, an ETL tool is used to extract data from these sources, cleanse and transform the data into a format usable by other systems, and load the transformed data into the data warehouse. Typically implemented in batches at night, ETL processes can be cumbersome, time-consuming and disruptive to other data warehouse processes, even with the use of an ETL automation tool.

In today's global, connected, always-on marketplace, competitive companies are struggling to process massive amounts of data in shrinking batch windows. With the log-based CDC capabilities of Qlik Replicate (formerly Attunity Replicate), enterprises can minimize the amount of data that needs to be processed by their ETL solution, improving operating efficiency and reducing costs while enabling real-time data integration and real-time data warehousing—all without impacting the performance of source systems.

What Is Change Data Capture: Achieving Real-Time Data Integration and Event Capture

Chosen as the Best Change Data Capture Solution by Database Trends and Applications' readers two years in a row, Replicate is a high-performance data integration platform from Qlik (Attunity).

At Qlik (Attunity), we've invested over 15 years in redefining "what is change data capture" for the enterprise. And we've developed a log-based, agentless CDC technology that captures and delivers only committed changes made to your enterprise data sources.

Qlik Replicate (formerly Attunity Replicate) features a low-impact, highly-scalable architecture, integrates seamlessly with your existing ETL integration tools, and is integrated into a wide range of tools through OEM relationships with Microsoft and other platform vendors. Qlik Replicate (formerly Attunity Replicate) is easy-to-use and employs intelligent in-memory transaction streaming, connecting sources to targets with no need to run data through an intermediate server, that maximizes data delivery performance.