ORACLE CHANGE DATA CAPTURE

Oracle change data capture is a technology used to accelerate data warehousing, enable real-time data integration across the enterprise, and improve the availability and performance of your databases. When implemented with an efficient, non-intrusive method, Oracle change data capture allows you to carry out the following replication tasks without placing unnecessary overhead on your source systems:

  • Offload analytics queries from production databases to data warehouses, reporting databases or other analytics platforms
  • Perform database migrations, for example to the cloud, with zero downtime
  • Incrementally extract and propagate data from multiple sources into a data warehouse

The Evolution of Built-In Oracle Change Data Capture Technology

For those unfamiliar with Oracle change data capture, we should first explain "what is change data capture?". In the context of Oracle Database, change data capture has come to refer to a built-in technology that was first introduced with the release of Oracle 9i and used to track and record changes applied to user tables in a database. These changes are stored in change tables for consumption by ETL applications, which can then process the data for loading into other databases or data warehouses. Because this first version of Oracle change data capture worked by creating triggers on source tables, many DBAs considered it to be an invasive approach and were reluctant to use it.

With the release of Oracle 10g, a new, less-intrusive method of Oracle change data capture was introduced. This new form of Oracle CDC leveraged the source database's redo logs as well as the built-in Oracle replication tool Oracle Streams to detect and transport change data to a target data repository—without negatively impacting the source system's performance. With the release of Oracle 12c, however, built-in Oracle change data capture is no longer supported (and Oracle Streams is discontinued), leaving Oracle users to pay for Oracle GoldenGate or find an alternative Oracle replication and change data capture solution.

An Affordable, Reliable Oracle Change Data Capture Solution from Qlik (Attunity)

With decades of experience in enterprise data integration and unique change data capture technology, Qlik (Attunity) offers an innovative platform for simple, real-time and universal data extraction and loading.

Our next-generation CDC technology is not only log-based, minimizing impact on your source systems, but also suitable for various types of integration environments including CDC for Oracle and SQL Server. Qlik Replicate (formerly Attunity Replicate) intuitive graphical user interface simplifies data pipeline design while eliminating the need for manual coding.

With Qlik (Attunity) Oracle change data capture technology and easy-to-use data replication platform, you can deliver data changes from your Oracle databases to other databases, data warehouses, and other types of data storage and processing environments—on premises or in the cloud—in batch or in real time. Unlike Oracle GoldenGate, Qlik Replicate (formerly Attunity Replicate) provides comprehensive automation of the replication process across all platforms, not just Oracle environments. And Unlike Oracle GoldenGate, we require no disruptive or hard-to-maintain agents on either source or target systems. Enable real-time data integration across your organization with Qlik (Attunity) reliable, scalable, high-performance replication architecture.