Bug 35846704: PostgreSQL - Support capture from standby from PostgreSQL 16 onwards

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

Bug 31943030: PostgreSQL - Support Capture from OCI PostgreSQL

Oracle GoldenGate Extract supported for OCI PostgreSQL.

Support for JSON Relational Duality

Oracle GoldenGate 23ai 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 Database JSON Relational Duality Views and Oracle GoldenGate Data Streams.

Support for Database Password Plugin

Oracle GoldenGate 23ai (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 23ai for Sybase supports Microservices Architecture

Oracle GoldenGate 23ai for Sybase now supports Microservices Architecture.

Support for MySQL Releases 9.0 and 8.4

Oracle GoldenGate 23ai for MySQL now supports releases 9.0 and 8.4.

Support for VECTOR datatype in Oracle GoldenGate 23ai for MySQL

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

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

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

Oracle GoldenGate 23ai for Oracle TimesTen supports Microservices Architecture

Oracle GoldenGate 23ai for Oracle TimesTen now supports Microservices Architecture.

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

Oracle GoldenGate 23ai 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 23ai for Teradata supports Microservices Architecture

Oracle GoldenGate 23ai 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 for 23ai.

Oracle GoldenGate support for database artificial intelligence (AI)

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

• Oracle Database 23ai uses the new vector data type to store vector embeddings, which are mathematical vector representations of data. Oracle GoldenGate 23ai supports capture and delivery of the vector data type for Oracle Database 23ai 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 23ai 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 23ai 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 23ai 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 23ai 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 23ai 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 23ai 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 23ai 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 23ai now supports Db2 version 13 for z/OS.

Support for new DISTINCT data type

Oracle GoldenGate 23ai 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 23ai features for Oracle Database 23ai

• Oracle GoldenGate supports Lock-free Reservable Columns

  Lock-free reservable columns are supported with Oracle GoldenGate 23ai. 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 Database 23ai

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

• Support for Oracle 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 23ai

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

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

  Oracle GoldenGate 23ai 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.

• Support for VECTOR data type

  Oracle GoldenGate 23ai 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 database from Oracle GoldenGate Microservices.

DDL notification on target tables for Replicat

Starting with Oracle GoldenGate 23ai, 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 Database 23ai 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 23ai 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.