Bug 29709965: MySQL - Extract to skip XA transactions and log a Warning instead of Abend

Changed the functionality in Oracle GoldenGate Extract for MySQL to skip XA transactions with a warning, instead of abending.

Bug 37465578: MySQL - Change the default capture for Extract CDC to be remote capture

Changed the default capture of Oracle GoldenGate for MySQL from local to remote capture for Linux-x64 platform.

Bug 37581809: Oracle - Allow IR to run with nodbcheckpoint

All Replicats are required to create and maintain a database checkpoint table, which serves as a mechanism for ensuring data consistency and facilitating recovery processes. The only exception to this requirement is the integrated Replicat. However, it is strongly recommended that you create and maintain a checkpoint table for the integrated Replicat.

Bug 37643197: SQL Server - Upgrade odbcinst.ini contents to the absolute path and driver descriptions

When upgrading an Oracle GoldenGate deployment for SQL Server to Oracle GoldenGate 23ai (23.7) from previous versions of 23ai or the 21c release using OPATCH, you must reset the contents of the odbcinst.ini file. For details on performing this task, see Upgrading Oracle GoldenGate Microservices GUI.

Bug 37298528 - MySQL: Make TRANLOGOPTIONS TRACKSCHEMACHANGES enabled by default

Enhanced TRANLOGOPTIONS TRACKSCHEMACHANGES option to be enabled by default.

Bug 37539434: Oracle - All Replicats without checkpoints are desupported

The creation of integrated and classic Replicat without checkpoint tables is not supported in Oracle Database. Additionally, any Replicats that were created without the checkpoint tables, will not start successfully.

For existing Replicats to run successfully, you must alter the Replicat to add a checkpoint table or add the checkpoint table to GLOBALS and then restart the Replicat. See ADD REPLICAT CHECKPOINTTABLE in the Command Line Interface Reference for Oracle GoldenGate for details.

Bug 35569409: PostgreSQL - Use Microservices Architecture task scheduler to update the heartbeat tables instead of relying on cron job

Configured an Administration Service task to update the heartbeat table to avoid replying on the cron job to do it.

Oracle GoldenGate 23ai does not need the OGG_SERVICEMANAGER_ID environment variable to be set for using the command line utilities that access database credentials

In Oracle GoldenGate 23ai (23.5) release, there is no requirement to set up the OGG_SERVICEMANAGER_ID environment variable for using command line utilities that access database credentials. This is required in the Oracle GoldenGate 23ai (23.4) release.

MySQL - Removed the remote (RMTTRAIL) option from the WebUI

For MySQL, the Remote button that was used for adding an Extract, has been removed from the WebUI.

Behavior change in Oracle GoldenGate 23ai

Oracle GoldenGate 23ai introduces the following feature, which impacts the behavior of configuring and using Oracle GoldenGate:

Microsoft ODBC Driver 18 for SQL Server

Oracle GoldenGate 23ai for SQL Server now packages the Microsoft ODBC Driver 18 along with the Oracle GoldenGate for SQL Server installation, and database connections will use this driver by default.

Behavior change in Oracle GoldenGate 23ai

Oracle GoldenGate 23ai features for Oracle Database 23ai

User roles to grant role-based privileges for Oracle Database 23ai

Oracle GoldenGate 23ai for Oracle Database 23ai has introduced user roles to grant role-based privileges.

For details, see the Grant User Privileges topic in Oracle GoldenGate Microservices Documentation.