CONTACT US

Oracle Databases: The Past, Present, and Future of Data Replication and Change Data Capture

Stelo_XStream_White_Paper Cover Mockup

Fast, accurate heterogenous data replication and change data capture (CDC) are essential to many extract, transfer, and load (ETL) processes. For Oracle database users, anticipated changes to Oracle’s application programming interface (API) technologies will likely affect your IT solutions and your capability for low-latency data replication. Software developers have three different levels of data technologies to access CDC through Oracle:

  1. Via procedural code triggers, executed in response to database events
  2. By leveraging the API capabilities included with LogMiner, Oracle’s diagnostic tool for accessing and mining database log files
  3. Through XStream (formerly Stream), Oracle’s technology that allows third-party applications to connect to Oracle databases via API

While each of these options can achieve CDC, the first two have tradeoffs that may present data security risks. LogMiner functions are being deprecated and de-supported by Oracle, leaving developers to search for other options. XStream is the option recommended (and supported) by Oracle but requires additional licensing.

Your choice of CDC solution is critical to creating reliability and dependable data pipelines. It determines whether you will have IT system failures, downtime, or business interruptions. If your source database for data replication is Oracle, you need to be aware of these changing technologies and be ready to take action.

In this white paper, you’ll receive:

  • A detailed explanation of the changes to Oracle’s API technologies
  • A comparison of the features of various options
  • A review of the risks associated with each option
  • Recommendations on how to address these changes (and when to address them)

To learn more, complete the form on this page and download this free resource.

Download the White Paper