What’s New in this Release

2 What’s New in this Release

This chapter describes the features, enhancements, and changes made to Oracle GoldenGate. Oracle updates the release notes periodically after the software release. This document is accurate at the time of publication.

2.1 19.1.0.0.8 Release — April 2021

Support has been added to mutate permissions to the S3 object ACL using S3 Canned Access Control list

For more information, see Configuring the S3 Event Handler in the Oracle GoldenGate for Big Data User Guide.

Support has been added to trim the parameter contents of the ${columnValue[]} parameters so that whitespace is supported. For more information, see Using Templates to Resolve the Topic Name and Message Key in the Oracle GoldenGate for Big Data User Guide.

Metacolumn support for seqno and rba

The following Metacolumn keywords have been added to resolve the trail file sequence number and rba respectively: ${seqno} and ${rba}. For more information, see Setting Metacolumn Output in the Oracle GoldenGate for Big Data User Guide.

Cassandra database password in Oracle Wallet is now secure

Support has been provided to store the Cassandra database password inside the Oracle Wallet.

2.2 19.1.0.0.7 Release — November 2020

Support has been added for all the available COPY SQL S3 authorization.

The Redshift Event Handler has been enhanced to support all the available COPY SQL S3 authorization mechanisms. For more information, see Redshift COPY SQL Authorization in Using Oracle GoldenGate for Big Data.

Schema Mapping for BigQuery Handler has been updated.

The table schema name specified in the replicat map statement has been mapped to the BigQuery dataset name. For more information, see Schema Mapping for BigQuery in Using Oracle GoldenGate for Big Data.

The template mapper functionality has been enhanced with a new keyword.

The template mapper functionality has been enhanced with a new keyword to resolve token values - ${token[]}. For more information, see Using Templates to Resolve the Stream Name and Partition Name in Using Oracle GoldenGate for Big Data.

The Kafka Connect Handler has been updated to include an ability to control the namespace on generated schemas.

Added the configuration property gg.handler.name.schemaNamespace allowing the user better control of generated schema naming. For more information, see Kafka Connect Handler Configuration (Table Kafka Connect Handler Configuration Properties) in Using Oracle GoldenGate for Big Data.

2.3 19.1.0.0.6 Release — September 2020

The S3 Event Handler has implemented the ability to change AWS roles when STS is enabled.

The gg.eventhandler.name.STSAssumeRole and gg.eventhandler.name.STSAssumeRoleSessionName parameters have been added to the S3 Event Handler. For more information, see S3 Handler Configuration in Using Oracle GoldenGate for Big Data.

2.4 19.1.0.0.5 Release — August 2020

Oracle GoldenGate for Big Data now supports Autonomous Datawarehouse (ADW) Handler

Support has been added for compressed updates in the trail.
XMLTYPE support added to Autonomous Data Warehouse (ADW) Event Handler
An XML cast function has been introduced in the merge SQL to convert the CLOB value in the staging table to XMLTYPE.
ADW: Support LOB updates
If the GoldenGate trail is generated by Oracle Integrated capture, then for the UPDATE operations on the source LOB column, only the changed portion of the LOB is written to the trail file.

For more information, see Using the Autonomous Data Warehouse Event Handler in the Using Oracle GoldenGate for Big Data.

Enhancement to HDFS Event Logger

If the log level is set to DEBUG, then the HDFS configuration properties will be logged.

Support has been added for Elasticsearch High Level REST client

For more information, see Elasticsearch High Level REST Client Dependancies in the Using Oracle GoldenGate for Big Data.

For more information, see Using the Autonomous Data Warehouse Event Handler in Using Oracle GoldenGate for Big Data.

Kafka and Kafka Connect support for headers have been added.

For more information, see Using the Kafka Handler and Using the Kafka Connect Handler in Using Oracle GoldenGate for Big Data.

Enhancement to Metacolumns functionality

The following two metacolumns have been added to the pluggable formatters: ${primarykeycolumns} and ${currenttimestampiso8601}. For more information, see Using the Pluggable Formatters in Using Oracle GoldenGate for Big Data.

Oracle GoldenGate for Big Data Certification

For more information, see Oracle Fusion Middleware Supported System Configurations.

2.5 19.1.0.0.4 Release — May 2020

Addition of Missing Parameters

The following new parameters were added in Oracle GoldenGate BigData: TRIMSPACES, TRIMVARSPACES, SPACESTONULL.

Support for capturing the single record message containing binary data.

Support was added to enable capturing of single record messages containing binary data.

2.6 19.1.0.0.3 Release — March 2020

Addition of a New Configuration Property on the Parquet Event Handler

A new property gg.eventhandler.name.writerVersion has been added on the Parquet Event Handler to support the explicit selection of the Parquet writer version. For more information, see Parquet Handler Configuration.

OCI Java SDK Upgraded to Support Newer Regions

The version of the OCI Java SDK has been moved up in order to support newer regions. If the OCI Event Handler is used, then you must use version 1.5.4 or higher of the OCI Java SDK.

2.7 19.1.0.0.1 Release — October 2019

The following new features were introduced in this release:

Redshift Event Handler is Introduced.

Support was added for the Redshift Event Handler.

For more information about using up the Redshift Event Handler, see Using the RedShift Event Handler in Using the Oracle GoldenGate for Big Data.

Addition of a New S3 Event Handler Configuration: A new S3 Event Handler configuration was added to allow users to disable S3 bucket administration, for example, create bucket. Bucket administration requires S3 administrative privileges that some customers may be unwilling to grant to the Oracle GoldenGate for Big Data replicat process. This feature allows users to turn off the bucket administration, thereby the only privilege required is for data file uploading to S3. For more information, see gg.eventhandler.name.enableBucketAdmin in S3 Handler Configuration in Using the Oracle GoldenGate for Big Data..

JMS Capture to Support Parsing Multiple Precisions of Timestamp Data: Support is provided to parse multiple precisions of timestamp data in the JMS capture.

Kafka Connect Handler to Support Avro Logical Types: The Kafka Interceptor support was added to the Kafka Connect Handler. For more information, see Kafka Interceptor for Kafka Connect Handler.

Support added to Debug Logging in Kafka Handler: Support is added to the Kafka Handler and the Kafka Connect handler to log the Kafka topic, partition, and offset of successfully published Kafka messages when the DEBUG logging is enabled.

2.8 19.1.0.0.0 Release — August 2019

The following new features were introduced in this release:

HBase Handler now supports HBase 2.x: Support was added for HBase 2.x. For more information about enabling the HBase 2.x connectivity, see Using the HBase Handler in Using the Oracle GoldenGate for Big Data.
Elasticsearch Handler now supports Elasticsearch 7.x: Support was added for Elasticsearch 7.x using the Elasticsearch Transport Client. For more information about enabling the Elasticsearch Handler connectivity, see Using the Elasticsearch Handler in Using the Oracle GoldenGate for Big Data.

Command Event Handler is introduced

The Java File Writer Handler writes data files locally and then uses Event Handlers to perform post processing on staged files. The Command Event Handler is introduced to allow users to execute external scripts to perform actions on staged files.

For more information about setting up the Command Event Handler, see Using the Command Event Handler in Using the Oracle GoldenGate for Big Data.

Delimited Text Formatter added functionality to optionally write both before and after image data.: The Delimited Text Formatter added functionality to optionally write both before and after image data. For more information about enabling the Delimited Text Formatter, see Delimited Text Formatter in Using the Oracle GoldenGate for Big Data .

MongoDB Handler optionally supports transactions: Support was added in the MongoDB Handler for transactions. MongoDB added transactional support in MongoDB 4.0. For more information about enabling these transactions, see Using the MongoDB Handler in Using the Oracle GoldenGate for Big Data.

: Support for Microsoft Azure Data Lake Gen 2
Support was added for Microsoft Azure Data Lake Gen 2 Handler transactions. For more information, see Connecting to Microsoft Azure Data Lake 2 in Using the Oracle GoldenGate for Big Data.

Replicat support for handling the mapping of GG_HEARTBEAT records: Replicat was changed to handle the mapping of heartbeat tables by automatically creating the target table definition. For more information, see Automatic Heartbeat Overview in Administering Oracle GoldenGate for Big Data.

2.9 Deprecated Items

This following features were deprecated in the 19.1.0.0 release:

Flume support has been removed: The Flume Handler has been removed from Oracle GoldenGate for Big Data.
HBase 0.98.x and earlier support has been removed: The HBase Handler has removed support for HBase 0.98.x and earlier HBase versions. The HBase Handler now only supports HBase 1.x and HBase 2.x.