As firms collect increasing quantities and varieties of data, their IT departments are under pressure to process and deliver fresh data to line-of-business users faster than ever before. In order to meet the data delivery needs of their organization, they're leveraging a combination of data integration approaches to improve data availability and enable real-time data synchronization across the organization. Change data capture is one of those approaches.
What is change data capture? Change data capture is a technology used for identifying and capturing changes made to data in a database and—depending on the tool employed—delivering those changes to another database or other type of data repository. By allowing you to capture and extract only changed data, change data capture eliminates or reduces the need for batch windows, replacing bulk load updates with continuous streaming or incremental loading of data. Change data capture helps you improve efficiency by reducing redundant data replication and delivery, reducing data warehousing costs and facilitating real-time data integration across your data stores.
Although some database vendors offer embedded technology for change data capture, many do not or have ceased supporting built-in CDC—as is the case with Oracle Change Data Capture. And so, in order to implement change data capture in Oracle and many other database environments, firms must find a robust and reliable third-party CDC solution.
Finding the right change data capture solution for your particular requirements can be difficult. Here are some key capabilities to look for:
If you're looking for one powerful and affordable tool that can provide you with all of the above features and more, Qlik Replicate (formerly Attunity Replicate) is the solution for you. Qlik Replicate (formerly Attunity Replicate) is a high-performance data replication platform featuring our next-generation change data capture technology. Qlik (Attunity) CDC is log-based and efficient, allowing you to capture and deliver data changes in real time without degrading the performance of your source systems.
Our CDC for database replication technology is also versatile, enabling real-time data integration and event processing initiatives across a variety of enterprise data sources including mainframes. You can implement Oracle, SQL Server or DB2 CDC using one easy-to-use tool. Our intuitive visual interface makes it easy to set up, monitor, and manage your data pipelines, eliminating the need for scripting and ensuring quick time-to-value.