What's new in Oracle Cloud Infrastructure GoldenGate

Learn about new features and enhancements recently added to improve your OCI GoldenGate experience.

When new and updated features are available for OCI GoldenGate, instances are upgraded in the data centers where Oracle Cloud services are hosted. Changes to the Oracle Cloud Console take affect automatically, but OCI GoldenGate deployments must be manually upgraded to stay within the support window.

To understand the full scope of each release, ensure that you also review the following resources:

2024 Releases

March 2024

Feature or Change	Description
Data Transforms	OCI GoldenGate Data Transforms is now available in all commercial regions. Learn more about Data Transforms and how to get started.
REST APIs	The GoldenGate Service REST API reference was refreshed to reflect the recent feature releases and updates.
New GoldenGate versions available	New GoldenGate versions for Oracle, MySQL, PostgreSQL, and Big Data are now available. Ensure that you upgrade your deployments as soon as you can. See OCI GoldenGate versions.

February 2024

Feature or Change	Description
Stream Analytics	OCI GoldenGate Stream Analytics is now available in all commercial regions. Analyze streaming data in real time without having to allocate or manage any compute environments. Learn more about Stream Analytics and how to get started.
REST APIs	The GoldenGate Service REST API reference was refreshed to reflect the recent feature releases and updates.
New GoldenGate versions available	New GoldenGate versions for Oracle, MySQL, PostgreSQL, and Big Data are now available. Ensure that you upgrade your deployments as soon as you can. See OCI GoldenGate versions.

2023 Releases

December 2023

Feature or Change	Description
Networking updates	Updates were made to the following areas: OCI GoldenGate creates a load balancer in your subnet when you create a deployment. This is a resource that you can manage, however, you must refrain from deleting the load balancer while the deployment is in use. When you create a connection, you must select a routing method. You can choose from: Shared endpoint Dedicated endpoint See OCI GoldenGate connectivity to learn more.
Contextual notifications	You can now set up contextual notifications on the deployment details page. Contextual notifications let stay informed of specific events that occur with your deployment. Learn more.
Truststore certificates	You can now manage Truststore certificates for other GoldenGate deployments to which your deployment communicates. See Manage Truststore certificates to learn more.
REST APIs	The GoldenGate Service REST API reference was refreshed to reflect the recent feature releases and updates.
New GoldenGate versions available	New GoldenGate versions for Oracle, MySQL, PostgreSQL, and Big Data are now available. Ensure that you upgrade your deployments as soon as you can. See OCI GoldenGate versions.

October 2023

Feature or Change	Description
New connections added	Support for the following connection types is now available in deployment version _841 and above, except for regions where Stream Analytics is in Limited Availability: Google BigQuery Google Cloud Storage Redis Amazon Redshift Amazon Kinesis Elasticsearch Google Cloud SQL for SQL Server SingleStoreDB SingleStoreDB Cloud For more information see, What's supported.
IAM with Identity Domains	GoldenGate now supports Identity Access Management (IAM) with Identity Domains. This feature is available in deployment versions _822 and above. To use IAM with Identity Domains, you must add the necessary policies. For more information, see OCI GoldenGate Policies. Learn more: Create a deployment Manage deployment users
Documentation updates	New articles added: Quickstarts: Replicate Data from MySQL Heatwave to Google Cloud Storage Replicate data from MySQL Heatwave to Amazon Kinesis Replicate data from PostgreSQL to Google BigQuery Send data from MySQL Heatwave to Azure Event Hubs Connections: Connect to Google BigQuery Connect to Google Cloud Storage Connect to Redis Connect to Amazon Redshift Connect to Amazon Kinesis Connect to Elasticsearch Connect to Google Cloud SQL for SQL Server Connect to SingleStoreDB Connect to SingleStoreDB Cloud Replicats: Add a Replicat for Google BigQuery Add a Replicat for Google Cloud Storage Add a Replicat for Amazon Kinesis Add a Replicat for Redis Add a Replicat for Azure Event Hubs
REST APIs	The GoldenGate Service REST API reference was refreshed to reflect the recent feature releases and updates.
New GoldenGate versions available	New GoldenGate versions for Oracle, MySQL, PostgreSQL, and Big Data are now available. Ensure that you upgrade your deployments as soon as you can. See OCI GoldenGate versions.

August 2023

Feature or Change	Description
Stream Analytics	You can now create event stream processing pipelines using OCI GoldenGate Stream Analytics. Pipelines can process input from GoldenGate Extracts, Kafka, or other sources, and join, transform, aggregate, or filter events using patterns and machine learning models. You can then output results to event streams, data stores, or operational dashboards. Note: Stream Analytics is currently in Limited Availability and only available in specific regions. To learn more and gain access, contact your Oracle representative or Oracle Support. This feature is available in deployment versions _802 and above. Learn more.
Maintenance	Expanded maintenance features are now available in deployment versions _766 and above. Additions include: More detailed maintenance schedule options when creating and editing deployments Reschedule upgrades Cancel upgrades
REST APIs	The GoldenGate Service REST API reference was refreshed to reflect the recent feature releases and updates.
New GoldenGate versions available	New GoldenGate versions for Oracle, MySQL, PostgreSQL, and Big Data are now available. Ensure that you upgrade your deployments as soon as you can. See OCI GoldenGate versions.

July 2023

Feature or Change	Description
Copy deployment backups	You can now copy automatic backups to your Oracle Object Storage bucket. Learn more.
Test connections	You can now test the connectivity to source and target connections assigned to a deployment in the Oracle Cloud console, from either the deployment or connection details page. Learn more.
OCI Logging integration	OCI GoldenGate now supports OCI Logging to produce process and error logs. Learn more.
REST APIs	The GoldenGate Service REST API reference was refreshed to reflect the recent feature releases and updates.
New GoldenGate versions available	New GoldenGate versions for Oracle, MySQL, PostgreSQL, and Big Data are now available. Ensure that you upgrade your deployments as soon as you can. See OCI GoldenGate versions.

June 2023

Feature or Change	Description
New GoldenGate versions available	New GoldenGate versions for Oracle, MySQL, PostgreSQL, and Big Data are now available. Ensure that you upgrade your deployments as soon as you can. See OCI GoldenGate versions.

March 2023

Feature or Change	Description
New deployment type	Support for Microsoft SQL Server is now available. You can select Microsoft SQL Server as a deployment type, and create the following types of connections: Azure SQL Database Azure SQL Managed Instance Microsoft SQL Server Amazon RDS for SQL Server To learn more, see: Create a deployment Supported technologies
New Big Data connections	Support for the following Big Data connection types is now available: Oracle NoSQL (target only) Oracle Oracle Weblogic JMS Amazon S3 (target only) Hadoop Distributed File System Oracle Autonomous JSON Database (target only) Azure Cosmos DB for MongoDB MongoDB Snowflake (target only) See all supported technologies.
New Quickstarts added	Check out the latest quickstarts for step-by-step instructions on how to get started with our new connection types: Replicate data from Azure SQL Managed Instance to Autonomous Transaction Processing Replicate data from PostgreSQL to Snowflake Replicate data from Autonomous Transaction Processing to Amazon S3 Replicate data from MongoDB to Autonomous JSON Database Explore quickstarts.
New maintenance features	You can now schedule upgrades, subscribe to upgrade notifications, snooze upgrade notifications, and rollback upgrades. Learn more. You can also review the different builds available to learn what's included in each release. See OCI GoldenGate versions. You must upgrade to version _703 or above to use the maintenance features.
GoldenGate API updates	To support the features released, additions were made to the GoldenGate API.
New GoldenGate version available	New GoldenGate versions for Oracle, MySQL, PostgreSQL, and Big Data are now available. Ensure that you upgrade your deployments as soon as you can. See OCI GoldenGate versions.

February 2023

Feature or Change	Description
Manage master encryption key wallets	You can now manage master encryption key wallets in OCI GoldenGate. You can use master encryption keys to encrypt trail files distributed to other GoldenGate deployments. Learn more. You must upgrade to version _687 or above to use the master encryption key wallet features.
GoldenGate API updates	To support the features released, additions were made to the GoldenGate API.
New quickstarts added	New quickstarts were added: Replicate data from Amazon RDS to OCI Object Storage Stage and merge data into Autonomous Data Warehouse using OCI GoldenGate
New GoldenGate version available	New GoldenGate versions for Oracle, MySQL, PostgreSQL, and Big Data are now available. Ensure that you upgrade your deployments as soon as you can. See OCI GoldenGate versions.

2022 Releases

December 2022

Feature or Change	Description
New deployment type added	OCI GoldenGate now supports PostgreSQL as a deployment type. Learn more.
New connection types added	New connection types were added for PostgreSQL and Big Data. See what's supported.
New quickstarts added	New quickstarts were added to showcase the new connection types: Replicate data from PostgreSQL to Autonomous Transaction Processing Replicate Data from Autonomous Transaction Processing to Confluent Kafka Replicate data from Autonomous Transaction Processing to Azure Data Lake Storage Replicate Data from Autonomous Transaction Processing to Azure Synapse
Collect diagnostics	You can now collect diagnostics to analyze or share information about your OCI GoldenGate deployment. The information collected can be shared with My Oracle Support, should you encounter any issues. Learn more.
GoldenGate API	To support the features released, additions were made to the Deployments API.
Admin Client	You can now launch the Admin Client directly from the Deployment details page. Learn more about Admin Client.
New GoldenGate version available	A new GoldenGate version for Big Data is now available. Ensure that you upgrade your deployments as soon as you can.

November 2022

Feature or Change	Description
Connections and deployment types	You can use connections and deployment types all regions where GoldenGate is available. Learn more about deployment types and supported connections.
New GoldenGate version	A new GoldenGate version for Oracle is now available. Ensure that you upgrade your deployments as soon as you can.

October 2022

Feature or Change	Description
Connections and deployment types	You can use connections and deployment types all regions where GoldenGate is available except: US West (Phoenix) US East (Ashburn) Australia East (Sydney) Germany Central (Frankfurt) Learn more about deployment types and supported connections.

Feature or Change

Description

Connections and deployment types

You can use connections and deployment types all regions where GoldenGate is available except:

US West (Phoenix)
US East (Ashburn)
Australia East (Sydney)
Germany Central (Frankfurt)

Learn more about deployment types and supported connections.

September 2022

Feature or Change	Description
Connections and deployment types	The following deployment types are now available in the US West (San Jose) and France Central (Paris) regions: Oracle Database Big Data MySQL Learn more about these deployment types and support connections.
View Trail files	You can now view Trail files for deployments upgraded to GoldenGate version 21.6 or higher on the Deployment details page, under Resources. Trail files build up over time, which directly impacts the Storage utilization calculation you see under Deployment information. Use this information to manage trail files.

Feature or Change

Description

Connections and deployment types

The following deployment types are now available in the US West (San Jose) and France Central (Paris) regions:

Oracle Database
Big Data
MySQL

Learn more about these deployment types and support connections.

View Trail files

You can now view Trail files for deployments upgraded to GoldenGate version 21.6 or higher on the Deployment details page, under Resources. Trail files build up over time, which directly impacts the Storage utilization calculation you see under Deployment information. Use this information to manage trail files.

August 2022

Feature or Change	Description
New metrics added	Several new metrics were added to the deployment details page so that you can observe the health of GoldenGate processes within the Oracle Cloud console. Learn more: Metrics Troubleshoot using the Oracle Cloud console Monitor performance
Admin client support in Cloud Shell	Cloud Shell now supports GoldenGate Admin client. Admin client enables you to create and manage OCI GoldenGate resources from the command line utility. Learn more.
New GoldenGate version available	A new GoldenGate version is now available. Upgrade your OCI GoldenGate as soon as possible to stay within the current support window. To upgrade, click the Upgrade link on your deployment details page. Learn more.

June 2022

Feature or Change	Description
Connections	A new OCI GoldenGate resource type was introduced and replaces Database Registrations for users in the San Jose region only. Explore connections.
Connections API	A catalog of REST APIs was introduced to support new Connections resource type for users in the San Jose region only.
Supported technologies	You can now use MySQL databases and Big Data technologies with OCI GoldenGate for users in the San Jose region only. Learn what's supported.
New quickstarts	For users in the San Jose region, get started with newly supported databases and technologies with the following quickstarts: Replicate data from MySQL to Autonomous Data Warehouse Replicate data from Autonomous Transaction Processing to Oracle Object Storage Replicate data from Autonomous Transaction Processing to OCI Streaming Replicate data from Autonomous Transaction Processing to Apache Kafka
New troubleshooting topic added	Learn to troubleshoot memory consumption issues and configure CacheMgr.

March 2022

Feature or Change	Description
Storage utilization	Each deployment has a soft limit of 250 GB storage per OCPU. You can see how much storage space your deployment uses on the deployment details page. When the storage limit is reached, a message displays on the deployment details page advising you to take action to free up space. Learn to purge unused trail files.
GoldenGate API	To support the features released, additions were made to the Deployments API.
GoldenGate Events	A new Deployment event type was added for Storage Utillization. Learn more.
New quickstart	Learn to configure bidirectional replication.

2021 Releases

December 2021

Feature or Change	Description
Support for RAC databases	Database Registrations now support RAC databases.
GoldenGate API	To support the features released, additions were made to the DatabaseRegistration APIs APIs.

November 2021

Feature or Change	Description
New details for Deployment Backups	Deployment backup size and start and end times were added to the Deployment Backup Details page. See Viewing Backup Details.
GoldenGate API	To support the features released, additions were made to the DeploymentBackup APIs.
Policy examples updated	With the recent release of Oracle Cloud Infrastructure IAM and the introduction of identity domains, updates were made to OCI GoldenGate Policy examples. See Minimum recommended policies.
Quickstarts updated	Send data from Oracle GoldenGate to OCI GoldenGate and Send data from OCI GoldenGate to Oracle GoldenGate quickstarts were updated to reflect changes to the root certificate.
Managing Deployment Backups	Reasons that a backup process fails were added to Manage deployment backups.

October 2021

Feature or Change	Description
Upgrade History	You can now view a list of past upgrades on the Deployment Details page. The Upgrade History displays the Oracle GoldenGate version applied, the date and time the upgrade started and finished, and the completion status. See Maintain OCI GoldenGate deployments.
DeploymentUpgrade API	A set of API operations was added to support the Upgrade History feature. See DeploymentUpgrade Reference.
Root certificate change	For OCI GoldenGate users who send data between OCI GoldenGate and on-premises Oracle GoldenGate instances or other non-OCI GoldenGate deployments, OCI GoldenGate's root certificate was recently updated and directly impacts any distribution and receiver paths between these source and targets. After upgrading your deployment, complete the following steps to successfully restart any distribution and receiver paths between OCI GoldenGate and on-premises Oracle GoldenGate instances or other non-OCI GoldenGate deployments: For Oracle GoldenGate 19c users, add the new certificate to the Distribution or Receiver server's client wallet. For more information, see Creating a Distribution Server User Certificate. For Oracle GoldenGate 21c users, use the Service Manager's Certificate Management feature. For information, see Create a Trusted Connection Between Oracle GoldenGate and OCI GoldenGate.
Managing Trail Files	Learn about Trail file management in Manage Trail files.
New quickstarts	The following quickstarts were added: Connect to OCI GoldenGate using a public IP Replicate data between cloud databases in different region with VCN peering
Quickstart updated	Replicate data between cloud databases in the same region now includes steps to instantiate a target database using Oracle Data Pump.
New Policy examples	Policy examples for securing network resources were added. See Policy Examples for Securing Network Resources.

Title and Copyright Information

What's new in Oracle Cloud Infrastructure GoldenGate

Oracle and/or its affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.