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 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.2 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.3 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.4 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.5 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.5.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.5.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.6 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.6.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.