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.
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.
To capture a data change stream from Oracle, a Debezium server is created with an Oracle CDC connector, which populates an AWS Kinesis stream.
- Create an Oracle AWS RDS instance & ARCHIVELOG
- Setup SQL PLUS
- Configure Oracle LogMiner
- Create Kinesis Streams in AWS
- Download Debezium server
- Edit the conf/application.properties
- Download Oracle JDBC Driver
- Create components for Decodable
For more detailed information, please refer to the Oracle CDC example in the Decodable GitHub repository.
Sign in to the Decodable Web Console and follow the configuration steps provided for the AWS Kinesis Connector 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.
|Delivery guarantee||exactly once|
Updated about 1 year ago