GoldenGate 23ai Microservices Architecture - coming soon
REST API management, microservices deployment model, and migration from classic GoldenGate to 23ai.
What is Oracle GoldenGate?
Oracle GoldenGate is Oracle's enterprise CDC and data replication product. It reads transaction logs from source databases and streams change records to targets in near real time - other Oracle databases, Kafka, PostgreSQL, flat files, and more. It's been in production at large scale for decades and shows up most often in financial services and telecoms where the Oracle support contract already covers the license cost.
GoldenGate supports heterogeneous replication - from Oracle to Oracle, Oracle to PostgreSQL, Oracle to Kafka, Oracle to flat files, and many other combinations. That flexibility is what makes it a common choice for zero-downtime migrations, active-active multi-master configurations, and feeding data warehouses from operational Oracle systems.
GoldenGate 23ai consolidated the product line under one architecture. You can run it on-premises as always, or use OCI GoldenGate - the fully managed Oracle Cloud version that removes the infrastructure overhead. For Kafka targets, GoldenGate 23ai includes a Kafka handler with Avro and JSON output and Confluent Schema Registry integration.
GoldenGate Architecture
A GoldenGate pipeline has three main process groups. The Extract process runs near the source database, reads the redo logs, and writes committed DML and DDL changes into GoldenGate's trail files. The Data Pump is an optional secondary Extract that reads trail files and forwards them across the network to the target side. The Replicat process reads trail files at the target and applies changes to the destination - a database, a Kafka topic, or another supported system.
Trail files act as a durable buffer between Extract and Replicat, so both processes can run at their own pace and recover independently. The Manager process keeps everything running, and in 23ai deployments the Admin Client provides a REST API for configuration and management.
GoldenGate vs Debezium
| Dimension | Oracle GoldenGate | Debezium |
|---|---|---|
| License | Commercial (Oracle) | Apache 2.0 (open-source) |
| Cost | High (per-processor) | Free |
| Oracle support | Native - deep Oracle integration | LogMiner or XStream (requires GG license) |
| Heterogeneous targets | Many (Oracle, PG, Kafka, files…) | Kafka, HTTP, Kinesis, Pub/Sub… |
| Latency | Sub-second | Seconds (LogMiner), sub-second (XStream) |
| Operational model | Oracle support + DBA expertise | Community, Red Hat subscription optional |
If you already have a GoldenGate license through your Oracle support contract, it's often the natural choice - especially for Oracle-to-Oracle replication or zero-downtime migrations. If you're building a new event-driven pipeline targeting Kafka and don't want to pay for a GoldenGate license, Debezium on LogMiner is the typical starting point.
Guides & Research
In-depth GoldenGate guides are in progress. Topics are drawn from production architecture and migration research.
GoldenGate CDC for Oracle Exadata - coming soon
Architecture patterns and performance considerations for GoldenGate Extract on Exadata, including Smart Scan interactions and log management.
GoldenGate Licensing Explained - coming soon
Detailed breakdown of GoldenGate license options, processor metric, OCI GoldenGate pricing, and how XStream licensing relates to GoldenGate.
GoldenGate vs Debezium: Full Comparison - coming soon
Decision framework for choosing between GoldenGate and open-source CDC tools, with architecture diagrams and cost modelling.
Frequently Asked Questions
Oracle GoldenGate is used for real-time database replication, zero-downtime migrations, active-active multi-master configurations, disaster recovery, and feeding data warehouses or analytics platforms from operational Oracle systems. It supports heterogeneous replication between Oracle and many non-Oracle databases.
GoldenGate is priced per processor and typically bundled with Oracle support contracts - on-premises costs range from tens of thousands to hundreds of thousands of dollars a year depending on processor count and options. OCI GoldenGate uses a consumption-based OCPU-hour model, which is simpler to predict for cloud-only deployments.
GoldenGate is commercially licensed with deep Oracle support, decades of production history, and native support for active-active replication and database-to-database targets. Debezium is open-source and built for Kafka and HTTP pipeline architectures. In practice, GoldenGate wins when the license is already covered by an existing Oracle contract or when you need Oracle-to-Oracle replication - Debezium wins when you're starting fresh and cost matters.
Yes. GoldenGate for Big Data (included in GoldenGate 23ai) provides a Kafka handler that delivers change events directly to Kafka topics in Avro, JSON, or other formats. It integrates with Confluent Schema Registry and supports partitioning by key column.
OCI GoldenGate is Oracle's fully managed GoldenGate service on Oracle Cloud Infrastructure. It handles patching, scaling, and monitoring automatically and is available on a consumption-based OCPU model. It supports replication between on-premises Oracle databases and cloud targets including Autonomous Database, Object Storage, and streaming services.