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 [email protected] 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.
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.
- 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.
Configure A Kinesis Source
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|
Additional Oracle CDC Support
If you are interested in a direct Decodable Connector for Oracle CDC, please contact [email protected] or join our Slack community and let us know!
Updated 5 months ago