Because organizations need timely, accurate business intelligence to stay competitive today, access to the most up-to-date data possible is crucial. And with the proliferation of 24/7 operating hours, the batch windows necessary for updating data warehouses and integrating data across other enterprise data sources are becoming increasingly difficult to accommodate. In Oracle environments, change data capture or CDC for Oracle is a technology that enables companies to transition from bulk load updating to continuous data synchronization and facilitate real-time data warehousing—allowing them to refresh their data stores without interrupting mission-critical operations.
Users of the latest version of Oracle Database may be unfamiliar with change data capture in Oracle environments and wondering "what is change data capture?". Before built-in CDC for Oracle Database was removed from the most popular RDBMS, users were able to leverage Oracle's convenient, log-based change data capture technology.
Introduced with the release of Oracle 10g, this non-intrusive form of CDC in Oracle Database allowed users to detect and capture changes made to user tables—without using database triggers or altering the structure of their tables—by reading DML changes from redo logs. When used in conjunction with Oracle Streams, an Oracle replication tool that was deprecated at the same time built-in CDC with Oracle was abandoned, this log-based change data capture mechanism enabled users to efficiently extract and propagate data changes from their Oracle databases to other databases, data warehouses, or operational data stores—without putting unnecessary overhead on their production systems.
In addition to data warehouse loading, log-based CDC in Oracle can be used for query offloading, distributing data processing, migrating databases with zero downtime, moving data to a secondary database for reporting or analytics, and more.
For those looking to leverage log-based CDC for Oracle but hesitant to pay the high licensing costs of Oracle GoldenGate (Oracle's recommended data integration solutionand replacement for built-in Oracle replication software), Qlik Replicate (formerly Attunity Replicate) might be the right solution for you.
Qlik Replicate (formerly Attunity Replicate) is an economical, high-performance data replication and data ingestion platform that combines our next-generation, log-based CDC for databasereplication with in-memory transaction streaming to provide you with the fastest, least resource-intensive mechanism for capturing and delivering data changes across your data stores. Our solution supports the broadest range of source and target platforms including all major relational databases, MongoDB NoSQL databases, data warehouses, Hadoop distributions, Kafka message brokers, and even mainframes.
Our low-impact CDC functionality integrates seamlessly with most ETL tools on the market and supports event-driven and stream-based processing of data changes. With Qlik Replicate (formerly Attunity Replicate), you can implement change record filtering, choose the change data delivery method most appropriate for each particular situation, and leverage automated end-to-end replication—all through our intuitive graphical UI.