What’s New in OCI GoldenGate – June 2025 Release (with Real-World Examples)


Oracle continues to raise the bar in real-time data replication and streaming with the June 2025 release of Oracle Cloud Infrastructure (OCI) GoldenGate. Whether you’re managing enterprise data lakes, securing connections, or building resilient architectures, the new features unlock fresh opportunities for data engineers and architects.

Here’s a detailed breakdown of the latest capabilities—with real-world examples to show how these features can power your projects.

1. New Connection Types: Expanded Target Ecosystem

OCI GoldenGate now supports the following new connection targets:

  • IBM Db2 for i (AS/400)

  • Apache Iceberg

  • Oracle REST Data Services (ORDS)

  • Google Pub/Sub


Real-World Example:

Apache Iceberg for Modern Analytics
A retail business wants to replicate transactional data from their Autonomous Transaction Processing (ATP) system into an Apache Iceberg data lake.

    Flow: ATP → GoldenGate → Apache Iceberg

➡ Outcome: Enables big data analytics on real-time sales with schema evolution and time travel features.

Google Pub/Sub for Event Streaming
A fintech company sends fraud alerts from their Oracle Database to Google Pub/Sub, which triggers serverless functions on GCP.

Flow: Oracle DB → GoldenGate → Google Pub/Sub

➡ Outcome: Event-driven architecture with real-time responsiveness and minimal lag.

2. New Deployment Type: Db2 for i

To simplify ingestion from IBM Db2 for i, Oracle has introduced a dedicated deployment type. This is a game-changer for mainframe modernization projects.

Real-World Example:

Manufacturing ERP Modernization
A manufacturing enterprise replicates ERP data from Db2 for i into Autonomous Data Warehouse for executive dashboards.

Flow: Db2 for i → GoldenGate → ADW

➡ Outcome: Legacy data becomes available for modern BI tools like Oracle Analytics and Tableau.

3. Local Disaster Recovery (Peer Deployment)

OCI GoldenGate now allows you to configure local peer deployments—two deployments in the same region acting as active-passive HA setup. If the primary fails, the peer automatically takes over.

Real-World Example:

Healthcare System Resilience
A hospital chain replicates patient data across clinics. By enabling peer deployments, data replication continues even if the primary instance fails.
➡ Outcome: Improves uptime and ensures continuous data flow for critical patient records.

4. Vault-Based Secret Management

All connection types now use Oracle Cloud Vault secrets for authentication by default. You can still opt out via Advanced Settings, but the move to secrets aligns with modern security practices.

Real-World Example:

Government Compliance
A federal agency replaces hardcoded passwords with Vault-managed credentials to meet FedRAMP and NIST standards.
➡ Outcome: Enhanced credential governance and zero trust enforcement.

5. Enhanced Connection Options

Oracle has added:

  • Region and Endpoint settings for Amazon S3 targets

  • Amazon DocumentDB as both source and target

➡ These updates allow for tighter integration with AWS ecosystems.

6. Quickstarts for Faster Adoption

Oracle has released guided Quickstarts to help new users ramp up faster:

  • Local Disaster Recovery

  • Db2 for i to ADW replication

  • ATP to Apache Iceberg replication

Real-World Example:

Data Engineering Team POC
A data team wants to evaluate OCI GoldenGate for mainframe data ingestion. They complete a quickstart for Db2 for i → ADW in under a day, skipping the typical setup complexity.
➡ Outcome: Rapid proof of concept, accelerated decision-making.

7. Updated REST API and Engine Versions

GoldenGate’s REST API has been updated to include new features, and the engine versions for all connectors (Oracle, MySQL, PostgreSQL, Db2, Big Data, Stream Analytics) have been refreshed.

Real-World Example:

DevOps Integration
A CI/CD pipeline integrates GoldenGate REST APIs to automate deployment provisioning and scaling. With the new API version, it now includes support for Iceberg and Google Pub/Sub targets.
➡ Outcome: Seamless automation in hybrid data architectures.

Summary Table

Feature Benefit Example Use Case
New Connectors Broader integration ATP → Iceberg / Oracle DB → Pub/Sub
Db2 for i Deployment Mainframe modernization ERP data ingestion into ADW
Peer Deployments (HA) Local disaster recovery Continuous healthcare data replication
Vault Secrets (Default) Stronger security posture Compliance with FedRAMP/NIST
Enhanced AWS Support S3/DocumentDB flexibility Multi-cloud replication
Quickstarts Faster time to value Day-1 POCs for ADW & Iceberg
REST API/Engine Refresh DevOps alignment CI/CD pipeline integration

Final Thoughts

The June 2025 OCI GoldenGate release is a bold step toward greater openness, security, and resilience in modern data platforms. Whether you're integrating with mainframes, building cloud-native pipelines, or adopting zero-trust principles, there's something in this release for every data-forward enterprise.

Comments