Oracle CDC

Oracle database services and products offer customers cost-optimized and high-performance versions of Oracle Database, the world’s leading converged, multi-model database management system, as well as in-memory, NoSQL and Oracle databases. Oracle Autonomous Database, available on premises via Oracle Cloud@Customer or in the Oracle Cloud Infrastructure, enables customers to simplify relational database environments and reduce management workloads.

If you are interested in a direct Decodable Connector for Oracle CDC, please contact support@decodable.co or join our Slack community and let us know!

Overview

Connector name

oracle-cdc

Type

source

Delivery guarantee

exactly once

Getting Started

Sending a data stream from Oracle CDC to Decodable is accomplished in two stages, first by populating an AWS Kinesis stream with Oracle CDC data, and then by adding and configuring a Kinesis source connector in Decodable.

Create Kinesis Data Source

To capture a data change stream from Oracle, a Debezium server is created with an Oracle CDC connector, which populates an AWS Kinesis stream.

  1. Create an Oracle AWS RDS instance & ARCHIVELOG

  2. Setup SQL PLUS

  3. Configure Oracle LogMiner

  4. Create Kinesis Streams in AWS

  5. Download Debezium server

  6. Edit the conf/application.properties

  7. Download Oracle JDBC Driver

  8. Create components for Decodable

For more detailed information, please refer to the Oracle CDC example in the Decodable GitHub repository.

Configure A Kinesis Source

Sign in to Decodable Web and follow the configuration steps provided for the AWS Kinesis to create a source connector. For examples of using the command line tools or scripting, see the How To guides.

There are multiple ways to implement change data capture (CDC) with Oracle. For more detailed information, see the Oracle GoldenGate Getting Started guide and related documentation.