Organizations want analytics-ready data without the complexity and fragility of traditional ETL workflows. OCI GoldenGate ZeroETL Mirror pipelines were built to do exactly that—deliver fresh, transactionally consistent data into your target databases with minimal engineering overhead. Today, we are excited to announce significant enhancements that further empower data engineers and developers.

Latest enhancements to OCI GoldenGate ZeroETL Mirror pipelines

What is ZeroETL?

ZeroETL is a design pattern that replaces manual ETL (Extract, Transform, Load) jobs with continuous, metadata‑driven change data capture (CDC). ZeroETL Mirror pipelines read committed transactions from the source, preserve transactional ordering, and apply them to the target. The result: lower latency, simpler operations, and higher fidelity without nightly batch windows.

ZeroETL Mirror pipelines can be used in several key use cases:

  • Real-time analytics and BI: Mirror operational data into analytics databases, such as Oracle Autonomous AI Lakehouse, for fresh dashboards without nightly ETL.
  • AI/ML feature stores and RAG (Retrieval Augmented Generation): Keep features synchronized across Oracle Autonomous AI Databases or Oracle AI Databases to power low-latency inference.
  • Multicloud data fabric: Keep data consistent across regions and clouds to support global applications and data locality.
  • Modernization and migration: Stand up a synchronized target during migration to reduce cutover risk and downtime.

Some of the benefits of ZeroETL Mirror pipelines include:

  • Fewer pipelines to build and maintain: Replace hand-coded ETL processes and brittle schedules with managed pipelines powered by OCI GoldenGate.
  • Faster delivery of analytics and applications: Near-real-time mirrors keep targets in sync for dashboards, AI/ML, and microservices.
  • Better data quality and consistency: Transactionally aware replication reduces drift and downstream reprocessing.
  • Lower operational risk: Managed orchestration, monitoring, and error handling reduce on-call toil.
  • Standards, security, and governance: Centralized connections, credentials management, and auditability align with enterprise controls.

What’s new in OCI GoldenGate ZeroETL Mirror pipelines?

OCI GoldenGate ZeroETL Mirror pipelines now support mirroring across the full spectrum of Oracle AI databases and deployment models:

  • Oracle Autonomous AI Databases 19c and 26ai
  • Oracle AI Databases 19c, 21c, 23ai, and 26ai
  • Exadata platforms 19c, 21c, 23ai, and 26ai

These databases can run anywhere: on-premises, on Oracle Cloud Infrastructure (OCI), and across multicloud environments with Oracle Database@AWS, Oracle Database@Azure, and Oracle Database@Google Cloud. This expansion ensures that organizations can seamlessly integrate and replicate data across their Oracle database estate in hybrid and multicloud environments.

In addition, this new ZeroETL Mirror pipelines release adds some usability enhancements:

  • Create connections inline from the Create pipeline page to streamline setup.
  • Choose Shared or Dedicated endpoints to match your network design and throughput needs.

These improvements aim to reduce setup time and provide a more intuitive interface for managing data replication pipelines.

Getting Started with the Enhanced ZeroETL Mirror Pipelines

To use these new capabilities:

  • In the OCI Console, open GoldenGate.
  • Create a ZeroETL Mirror pipeline.
  • Add source and target connections inline from the Create pipeline page.
  • Configure mapping rules and schema inclusion/exclusion (optional).
  • Enable pipeline‑level logging (optional).
  • Start the pipeline.
  • Monitor its performance using the Runtime tab.

Try it now and follow the quickstart Mirror data with ZeroETL mirror pipelines to get started. For a detailed walkthrough, refer to our documentation: Create pipeline resources.

With expanded support for Oracle AI databases across on‑premises, OCI, and major public clouds and with new usability enhancements, OCI GoldenGate ZeroETL Mirror pipelines make it simpler and safer to deliver fresh, consistent data wherever your business needs it. Whether you are enabling real-time analytics, powering AI features, or modernizing across multicloud, ZeroETL provides a consistent pattern that scales with your architecture.

Try it now!