Oracle source integration

This is a supported integration which requires manual configuration.

If you are interested in native support with a Decodable connector drop us a line or join our Slack community and let us know!

Sending a data stream from Oracle CDC to Decodable is accomplished in two stages:

  1. Populating an Amazon Kinesis stream with Oracle CDC data

  2. Adding and configuring a Kinesis source connector in Decodable.

For more detailed information, see the Oracle CDC example in the Decodable GitHub repository.

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 Amazon Kinesis stream.

  1. Create an Oracle Amazon 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

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.

Configure a Kinesis source

Follow the configuration steps provided for the Amazon Kinesis source connector.