Support for Capture and Delivery of YugabyteDB and YugabyteDB Anywhere

Oracle GoldenGate supports capture and delivery for YugabyteDB and Yugabyte DB Anywhere version 2024.2.7.0 and higher. See Prepare YugabyteDB.

Support for Capture and Delivery for EDB Postgres Advanced Server

Oracle GoldenGate supports capture and delivery for EDB Postgres Advanced Server versions 13, 14, 15, 16, and 17.

Embeded AI Service Providers and Models

Oracle GoldenGate web interface provides the option to embed various AI service providers and models, including Gemin, OpenAI, OCI Generative AI, and Voyager AI. See About Oracle GoldenGate AI Service.

Support special number types including +/-INFINITY and NaN for non-Oracle databases

Oracle GoldenGate supports special number types including +/-INFINITY, sNaN and NaN for Extract and Replicat processes for non-Oracle databases. See Supported Special Values by Data Type.

Oracle recommends creating Extract for per-PDB capture rather than Root Level Extract

Setting up Extract with root level access using common user c##ggadmin is not recommended, except when configuring Extract for downstream mining.

This feature supercedes the feature introduced in Release 23.4: May 2024.

Oracle GoldenGate supports capture from standby from PostgreSQL 16 onwards

Oracle GoldenGate supports capture from PostgreSQL standby database from PostgreSQL version 16 and higher.

Oracle GoldenGate Extract supports capture from OCI PostgreSQL

Oracle GoldenGate Extract supported for OCI PostgreSQL.

Support for JSON Relational Duality

Oracle GoldenGate supports replicating full-featured business objects in an event-based, pub/sub architecture with Oracle JSON Relational Duality and GoldenGate Data Streams. This is implemented by combining two new Oracle technology features: Oracle AI Database JSON Relational Duality Views and Oracle GoldenGate Data Streams.

Support for Database Password Plugin

Oracle GoldenGate (starting with 23.5 and higher) includes a user-friendly plugin that enables writing custom code to retrieve database credentials from a third-party vault and then return it in a predefined API to Oracle GoldenGate.

For more information, see Authenticate the Database Connection Using the Database Password Plugin.

Oracle GoldenGate for Sybase supports Microservices Architecture

Oracle GoldenGate for Sybase now supports Microservices Architecture.

Support for MySQL Releases 9.0 and 8.4

Oracle GoldenGate for MySQL now supports releases 9.0 and 8.4.

Support for VECTOR datatype in Oracle GoldenGate for MySQL

Oracle GoldenGate (23.5 onwards) for MySQL 9.0 and higher supports the vector data type.

Oracle GoldenGate for Db2 for i and Oracle GoldenGate for Db2 LUW support Microservices Architecture

Oracle GoldenGate for Db2 for i and Oracle GoldenGate for Db2 LUW now support Microservices Architecture.

Oracle GoldenGate for Oracle TimesTen supports Microservices Architecture

Oracle GoldenGate for Oracle TimesTen now supports Microservices Architecture.

Oracle GoldenGate supports direct connectivity (DSN-less) for SQL Server database connections

Oracle GoldenGate adds direct connectivity support for SQL Server connections, allowing server host/IP and instance port entries for database connections.

For more information see, Add Database Connections.

Oracle GoldenGate for Teradata supports Microservices Architecture

Oracle GoldenGate for Teradata now supports Microservices Architecture.

For more information, see the Installation Requirements for Teradata and Configure Teradata topics in the Oracle GoldenGate Microservices Architecture Documentation.

Oracle GoldenGate support for database artificial intelligence (AI)

Oracle GoldenGate adds artificial intelligence support with the following data types:

• Oracle AI Database uses the new vector data type to store vector embeddings, which are mathematical vector representations of data. Oracle GoldenGate supports capture and delivery of the vector data type for Oracle AI Database to enable real-time vector processing for embedding flow. For more infromation, see Oracle: Details of Support for Oracle Data Types and Objects.

• Oracle GoldenGate can replicate vector data heterogeneously and homogeneously if the embedding algorithm is same in terms of type and dimension, across the databases, allowing migration of vector data from one database to another.

• Oracle GoldenGate also supports the capture and delivery of array, pgvector extension, tsquery and tsvector for PostgreSQL and most vendor derivatives. For more information, see PostgreSQL: Supported Data Types.

Configuration service to store critical configuration data

Oracle GoldenGate now supports a new Configuration Service for managing the configuration files of Oracle GoldenGate for high availability (HA) purposes. For more information, see Configuration Service.

Data streaming service

Oracle GoldenGate introduces the data streaming service. This service enables simplified access to database change records, provides continuous ETL, and real-time analytics over a web socket connection. For more information, see About Data Streaming Service.

Monitor Oracle GoldenGate statistics

Oracle GoldenGate supports StatsD, which is an open-source network daemon that listens for statistics, like counters and timers, sent over TCP and sends aggregates to one or more pluggable backend services. Oracle GoldenGate Microservice Architecture sends metrics to the Performance Metrics Service and writes metrics in StatsD format to a StatsD daemon or a time series databases that supports ingestion of StatsD metrics.

For more information, see Using StatsD with OGG

Trail file management

Oracle GoldenGate has introduced the ability to manage trail files directly, including the ability to create archive tasks and delete trail files.

For more information, see Trail File Management.

Support for new TRANLOGOPTIONS parameter

Oracle GoldenGate adds support for the new TRANLOGOPTIONS EXCLUDEFILTERTABLE parameter. This parameter replaces the TRANLOGOPTIONS FILTERTABLE parameter but supports the same functionality. For more information, see TRANLOGOPTIONS.

Support for Db2 version 13 for z/OS

Oracle GoldenGate now supports Db2 version 13 for z/OS.

Support for new DISTINCT data type

Oracle GoldenGate now supports the new DISTINCT data type for Db2 for i, Db2 LUW, and Db2 z/OS.

New user interface for Oracle GoldenGate Microservices Architecture

The Oracle GoldenGate Microservices Architecture web interface has been renewed with improved capabilities and enhanced user experience.

Oracle GoldenGate features for Oracle AI Database

• Oracle GoldenGate supports Lock-free Reservable Columns

  Lock-free reservable columns are supported with Oracle GoldenGate. For more information, see Support for Lock-free Reservation.

• Oracle GoldenGate supports Blockchain and Immutable Tables

  Blockchain and immutable tables are supported. For more information, see Tables, Views, and Materialized Views.

• Support for Oracle SQL Domains

  Oracle GoldenGate supports Oracle SQL Domains. For more information, see Details of Support for Oracle Data Types and Objects.

• Support for Boolean data type

  Oracle GoldenGate supports Boolean data type. For more information, see Details of Support for Oracle Data Types and Objects.

• Oracle GoldenGate supports tables with 4K columns for Oracle AI Database

  Oracle GoldenGate supports tables with 4K columns for Oracle AI Database. For more information, see Tables, Views, and Materialized Views.

• Support for Oracle AI Database online DDL

  Oracle GoldenGate Extract and Replicat processes can manage replication for DDL operations in cases where minimal supplemental logging is enabled. This provides more flexibility for online application upgrades using Edition Based Redefinition.

  For more information, see Using Edition-Based Redefinition section in Oracle GoldenGate Microservices Documentation.

• JSON diff data type is supported with Oracle GoldenGate

  JSON diff data type is supported with Oracle GoldenGate. For more information, see Details of Support for Oracle Data Types and Objects.

• Oracle GoldenGate works with per-PDB Extract level users only

  Oracle GoldenGate captures using per-PDB Extract only. Root level access using common user (c##ggadmin) is not available. For more information, see Configure Multitenant Container Database in the Oracle GoldenGate Microservices Documentation.

  This feature has been updated. See Release 23.9: September 2025 for details.

• Support for VECTOR data type

  Oracle GoldenGate now supports VECTOR data type to store vector embeddings.

Integrated health checks and alerts for integrated Replicat and Extract in Oracle GoldenGate Microservices

Diagnose and troubleshoot integrated Replicat and Extract processes in Oracle AI Database from Oracle GoldenGate Microservices.

DDL notification on target tables for Replicat

Starting with Oracle GoldenGate, Replicat uses efficient table DDL change notification to invalidate any cached metadata when you perform a DDL operation on the target table.

For details, see DDL Notification on Target Tables .

Support coexistence of Oracle GoldenGate with Data Guard Pluggable Database (DGPDB)

Oracle AI Database functionality has been extended to allow using Oracle GoldenGate in a PDB-based Data Guard (DGPDB) environment in parallel. See Support for DGPDB.

New CHKPTDUMP utility

Oracle GoldenGate includes a new utility called chkptdump, which enables dumping content from checkpoint files. For details, see Location of Programs and Utilities Accessible from the Admin Client.