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.