2 What’s New in this Release

This chapter describes the features, enhancements, and changes made to Oracle GoldenGate for Distributed Applications and Analytics (GG for DAA). Oracle updates the release notes periodically after the software release. This document is accurate at the time of publication.

2.1 Release 26ai (23.26.2) — May 2026

Iceberg Handler with ADLS EntraID Support

Oracle GoldenGate for Big Data now supports Azure EntraID authentication for the Iceberg handler when connecting to Azure Storage endpoints. Users can configure authentication using tenantId, clientId, and clientSecret, enabling more secure and flexible access management for Azure-based deployments.

Support for SQL based operation aggregation for AI Data Platform

Oracle Intelligent Data Lake now supports SQL-based aggregation capabilities, enabling users to perform advanced data aggregation and analysis using SQL. This enhancement provides greater flexibility for processing large-scale data sets and supports improved analytics and data-driven decision-making workflows.

Need to support OATH authentication in GGS for Kafka

Oracle GoldenGate for Big Data now supports OAUTH authentication for Kafka connections, enabling secure connectivity to Kafka environments that require token-based authentication. This enhancement improves security and expands compatibility with modern Kafka deployments and authentication standards.

Support for Mapping to Boolean in GGDAA snowflake streaming handler

Oracle GoldenGate for Big Data includes enhancements to the Snowflake streaming handler to improve support for BOOLEAN data mappings. These updates address issues related to replication of BOOLEAN values from source databases to Snowflake, improving data consistency and reliability for streaming replication workflows.

Apache Iceberg v3 Support

Oracle GoldenGate for Big Data now supports Apache Iceberg v3, enabling improved compatibility with modern data lake environments. This enhancement provides support for the latest Iceberg table format capabilities, helping improve interoperability, scalability, and performance for big data integration workflows.

Support ${primarykeysmap} metacolumns keyword

Oracle GoldenGate for Big Data now supports the ${primarykeysmap} metacolumn keyword, enabling primary key column names and values to be generated in JSON map format. This enhancement improves structured metadata handling and simplifies downstream data integration and processing workflows.

Kafka Connect Handler to produce the Kafka message key as a record

Oracle GoldenGate for Big Data now supports structured Kafka message keys through the new keyMetaColumnsTemplate configuration parameter for the Kafka Connect Handler. This enhancement enables primary key values to be generated as structured records instead of strings when integrating with Confluent Schema Registry, improving schema flexibility, data consistency, and downstream application compatibility.

Delivery to Pub/Sub fails unless scopes are explicitly

Oracle GoldenGate for Big Data includes enhancements to the Google Pub/Sub handler to improve authentication and connectivity reliability. These updates add support for explicit OAuth scope configuration, helping resolve authentication and connection timeout issues when delivering data to Google Pub/Sub environments.

GGDAA | Stage/Merge targets to support column names with any character (/,$,#,@ or non-Ascii) supported by the target database

Oracle GoldenGate for Big Data now includes enhanced support for column names containing special characters in stage/merge replication workflows for supported targets such as Snowflake. This enhancement improves compatibility with existing source schemas and helps ensure reliable replication for environments using non-standard column naming conventions.

Caching issue with special character support enhancement#37985126

Oracle GoldenGate for Big Data includes enhancements to improve handling of special characters in column names during Avro formatting and replication workflows. These updates help improve replication reliability and compatibility for multi-table environments and targets such as Snowflake when source schemas contain non-standard column naming conventions.

New Section for Kafka Document: Configuration Considerations and Best Practices

Introduces a dedicated Kafka best practices section covering configuration tuning, deployment guidance, operational recommendations, and production considerations for Kafka integrations.

GGDAA | Doc | Iceberg | REST Catalog based on AWS S3 Tables

Adds documentation for Apache Iceberg REST Catalog integration using AWS S3 Tables, including configuration examples and deployment guidance.

Best Practices for Cloud Object Storage Replication

Adds a new best practices section describing optimal configuration, scalability, and operational recommendations for Cloud Object Storage replication deployments.

Add documentation for Iceberg Uniform Table Format support for AI Data Platform

Documents support for Iceberg Uniform Table Format integration with AI Data Platform environments and associated configuration guidance

Oracle GoldenGate Java Delivery

Introduces or expands Oracle GoldenGate Java Delivery documentation, including architecture, configuration, and usage guidance.

2.2 Release 26ai (23.26.1.0.1) — March 2026

Support encryption of sensitive data in Iceberg REST Catalog properties file

The Oracle GoldenGate for DAA targets now supports encryption of sensitive data in Iceberg REST Catalog properties file.

Support COPY INTO in AWS Redshift using Parquet file

The Oracle GoldenGate for DAA now supports COPY INTO in AWS Redshift using Parquet file.

2.3 Release 26ai (23.26.1) — February 2026

Azure Synapse Microsoft Entra ID Authentication support

Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) now supports the Azure Synapse handler with Microsoft Entra authentication as a secure option.

Apache Iceberg Table Type support in Google BigQuery Storage Write

GG for DAA now support the Google Storage Write API that can create external Iceberg Table format. It also enable the Iceberg Table Format creation with BigQuery Storage Write API Handler.

Support special character in Avro staging file

Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) now supports the special characters in Avro staging file.

Additional support for multipart upload in AWS S3

Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) now provides additional support for the multipart upload in AWS S3.

OCI Object Storage support with Iceberg Catalog

Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) now supports the OCI Object Storage support with Iceberg Catalog.

Support Microsoft Fabric Eventstreams as source and target

The eventstreams feature in the Microsoft Fabric Real-Time allows to use real-time events into Fabric, transform them, and then route them to various destinations without writing any code (no-code). Additionally, with Apache Kafka endpoints available on the Eventstream item, it allows to external applications to send or consume real-time events using the Kafka protocol. Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) now supports the Microsoft Fabric Eventstreams as source and target.

Support Google Cloud Managed Service for Apache Kafka as source and target

Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) now supports the Google Cloud Managed Service for Apache Kafka as source and target. The user can establish the connection between Google Cloud Managed Service and OCI using the subnet. User can run the replicate for Apache Kafka using this connection.

Stage/Merge targets to support column names with any character (/,$,#,@ or non-Ascii) supported by the target database

The Oracle GoldenGate for DAA targets now supports the column names with any characters.

Databricks target accesses external table data using direct path queries

Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) Databricks target now accesses staging data in the data files without creating an external table using direct path queries. This approach can simplify setup and potentially avoid external table refresh issues by directly querying AVRO files from the storage location, for example, ADLS Gen2, S3, or GCS.

2.4 Release 23ai (23.10) — November 2025

Support Delivery to Oracle AI Data Platform

GG for DAA now officially supports the Oracle AI Data Platform is in 23.10.x. The Oracle AI Data Platform as a new product offering that brings together data lake, analytics, and orchestration services into one unified platform. For more information, see Oracle AI Data Platform in the Oracle GoldenGate Distributed Applications and Analytics documentation.

Support for Scaling Ingest into Fabric with Partitioning

GG for DAA now supports the partitioning feature to help scale data ingestion into Fabric more efficiently. This feature allows the use of column number in a table as partitioning keys.

Support delivery to OCI Streaming with Apache Kafka

A new connection is added in GG for DAA to support GGS for OCI Streaming with Apache Kafka. In GGS Big Data image, a drop-down target selection for OCI Streaming with Apache Kafka is added.

Support delivering array type into Google BigQuery.

GG for DAA now supports array types for Google BigQuery. Supported datatypes for arrays and UDTs are added for Oracle GoldenGate Postgres.

Support encrypting userid and password in JAAS configuration file

GG for DAA now supports to encrypt the userid and password in the jaas.conf file from the Oracle GoldenGate bigdata side. This feature supports the 'PLAIN', 'SCRAM-SHA-256', and 'SCRAM-SHA-512 sasl.mechanism.

Support for vectors to JSON formatter

GG for DAA now supports vectors to JSON formatter. The vector type is converted to the typed version of the vector based on the available metadata type.

Support for Databricks Open Source JDBC Driver

GG for DAA Databricks handler is now certified with Open Source JDBC Driver.

2.5 Release 23ai (23.9.1) — September 2025

Support for Oracle AI Data Platform

GG for DAA now provides Oracle AI Data Platform as a new product offering that brings together data lake, analytics, and orchestration services into one unified platform. For more information, see Oracle AI Data Platform in the Oracle GoldenGate Distributed Applications and Analytics documentation.

2.6 Release 23ai (23.9) — September 2025

Support for OGG BigData SnowFlake Streaming to Iceberg Tables

GG for DAA Snowflake Streaming handler now supports the additional parameters for writing to Apache Iceberg. For more information, see Snowflake in the Oracle GoldenGate Distributed Applications and Analytics documentation.

2.7 Release 23ai (23.8) — May 2025

Support for Snowflake Timestamps

Oracle GoldenGate for Distributed Applications and Analytics (GG for DAA) now supports Snowflake Timestamps. For more information, see Supported Snowflake Date Datatypes in the Oracle GoldenGate Distributed Applications and Analytics documentation.

Support for Target Selection Updates

GG for DAA now supports format selection for AWS S3, GCS, ADLS, OCI Object Storage, and local file systems. For more information, see Quickstarts-Articles in the Oracle GoldenGate Distributed Applications and Analytics documentation.

Support for AWS DocumentDB Capture

GG for DAA now supports AWS DocumentDB Capture. For more information, see Amazon DocumentDB in the Oracle GoldenGate Distributed Applications and Analytics documentation.

Support for Synapse Stage and Merge, Auto-create Target Tables

GG for DAA now supports Synapse Stage and Merge, Auto-create Target Tables . For more information, see Azure Synapse Analytics in the Oracle GoldenGate Distributed Applications and Analytics documentation.

Support for Add purgeTargetPathOnStartup for Databricks for Amazon S3

GG for DAA now supports purgeTargetPathOnStartup for Databricks for Amazon S3. For more information, see S3 Handler Configuration in the Oracle GoldenGate Distributed Applications and Analytics documentation.

2.8 Release 23ai (23.7) — March 2025

Support for Apache Iceberg Format

Oracle GoldenGate for Distributed Applications and Analytics (GG for DAA) now supports Apache Iceberg Format. For more information, see Iceberg Event Handler in Oracle GoldenGate Distributed Applications and Analytics documentation.

Support for Google BigQuery Streaming API handler

GG for DAA now supports Google BigQuery Streaming API handler with Storage Write API. This handler uses recommended Storage Write API for low latency streaming of insert records without using any staging. For more information, see BigQuery Streaming API with Storage Write API in the Oracle GoldenGate Distributed Applications and Analytics documentation.

Support for Iceberg table type in Snowflake target

GG for DAA now supports automatic creation of Snowflake Iceberg tables by updating certain Snowflake properties. For more information, see Snowflake Iceberg Tables in the Oracle GoldenGate Distributed Applications and Analytics documentation.

Support for Iceberg table type in Databricks target

GG for DAA now supports automatic creation of Databricks Iceberg tables by updating certain Databricks properties. For more information, see Databricks Event Handler Configuration in the Oracle GoldenGate Distributed Applications and Analytics documentation.

Support for Iceberg table type in BigQuery stage/merge target

GG for DAA now supports automatic creation of BigQuery Iceberg tables by updating certain BigQuery properties. For more information, see BigQuery Iceberg Tables in the Oracle GoldenGate Distributed Applications and Analytics documentation.

2.9 Release 23ai (23.6.0.24.11) — November 2024

Support for Mirrored Database in Microsoft Fabric

Oracle GoldenGate for Distributed Applications and Analytics (GG for DAA) enables autoconfiguration to replicate to the mirrored database target. For more information, see OneLake Event Handler Automatic Configuration in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

Support for Lakehouse in Microsoft Fabric

Oracle GoldenGate for Distributed Applications and Analytics enables autoconfiguration to replicate to the Lakehouse target. For more information, see OneLake Event Handler Automatic Configuration in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

Support for delivery to AWS DocumentDB

GG for DAA supports delivery to AWS DocumentDB. For more information, see Amazon DocumentDB in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

Support for OCI Event handler authentication using resource principal

Using the OCI Java SDK an authentication can be added using resource principal.

Support for connecting to Oracle NoSQL via ResourcePrincipal

OCI configuration has been modified to connect to Oracle NoSQL via ResourcePrincipal

SHOWSYNTAX support for Stage and Merge targets.

GG for DAA provides SHOWSYNTAX support for Stage and Merge targets.

Support for retrieving credentials through Oracle GoldenGate Plugin Access Module via AUTHSTOREUSERNAME and/or AUTHSTOREPASSWORD.

GG for DAA provides Support for retrieving credentials through Oracle GoldenGate Plugin Access Module via AUTHSTOREUSERNAME and/or AUTHSTOREPASSWORD.

Support for mapping of table data into particular topic/queue in JMS delivery.

GG for DAA supports mapping of table data into into particular topic/queue in JMS delivery. For more information, see Java Message Service - Topic/Queue Name Selection in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

Support for CloudEvents Format

CloudEvents format with Oracle GoldenGate for Distributed Applications and Analytics Kafka handler is now supported. For more information, see Using the Cloud Event Formatter in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

2.10 Release 23ai (23.5) — August 2024

Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) now supports Mongo document formatting

JSON Mongo Document Formatter formats the MongoDB Capture processed documents into a JSON format with only payload information. For more information, see Mongo Document Formatting Details in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

2.11 Release 23ai — July 2024

Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) now supports delivery of change events to Databricks

Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) delivers change events and merge into target tables in Databricks. For more information, see Databricks Event Handler in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

GG for DAA supports delivery to Snowflake via Snowpipe streaming API.

The Snowflake Streaming Handler supports INSERT-only workloads using the Snowpipe Streaming API, which can result in lower load latencies at a lower cost for loading data into Snowflake. For more information, see Snowflake Streaming Handler in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

Improved stage and merge framework

Various improvements were made to the Stage and Merge handlers framework for correctness and resiliency.

Support provided for automatic table creation in the Snowflake handler.

GG for DAA supports creation of target tables in Snowflake based on the incoming/source metadata. For more information, see Using the Snowflake Event Handler in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) now supports delivery of CDC changes to Google Pub Sub

Oracle GoldenGate for Distributed Analytics and Applications (GG for DAA) delivers CDC changes to Google Pub Sub. For more information, see Google Pub Sub in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

Support for delivering change events involving boolean types correctly.

GG for DAA provides support for delivering change events involving boolean types correctly. For more information, see Replicate Data in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

Avro formatting based on schema provided by Avro Metadata Provider is now supported in GG for DAA

Users can now create a custom metadata provider (MDP) to map to an existing Avro schema. For more information, see Avro Metadata Provider in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

GG for DAA introduces a new Stage and Merge operation aggregator property for flush/merge interval for CDC and initial load.

A new gg.aggregate.operations.flush.interval Stage and Merge operation aggregator property has been introduced. For more information, see In-Memory Operation Aggregator (Snowflake, OCI Autonomous Datawarehouse, AWS Redshift, Azure Synapse, and Google Bigquery sections) in Oracle GoldenGate for Distributed Applications and Analytics Documentation.

2.12 Deprecated Items

The following features and properties have been deprecated in these releases of Oracle GoldenGate for Distributed Applications and Analytics (GG for DAA):

2.12.1 Release 23ai (23.6)— November 2024

Starting with the Oracle GoldenGate for Distributed Applications and Analytics 23ai (23.6) release, the Command Event handler has been deprecated.

2.12.2 Release 23ai (23.5)— August 2024

Starting with the 23ai release, the gg.aggregate.operations.flush.interval property is deprecated and is no longer supported. For more information, see the following topics in Oracle GoldenGate for Distributed Applications and Analytics documentation:

2.13 Deferred Items

The following features and properties have been deferred in these releases of Oracle GoldenGate for Distributed Applications and Analytics (GG for DAA):

2.13.1 Release 23ai (23.6)— November 2024

The VECTOR data type support in Snowflake integration (Stage and Merge) has been deferred in the Oracle GoldenGate for Distributed Applications and Analytics 23ai (23.6) release.