X

Welcome to All Things Data Integration: Announcements, Insights, Best Practices, Tips & Tricks, and Trend Related...

  • May 15, 2019

Release Announcement for Oracle GoldenGate 19.1

Vika Mlonchina
Product Marketing Manager

This post was authored by Bobby Curtis, Director of Product Management, Oracle

What’s New in Oracle GoldenGate 19.1

To succeed in today’s competitive environment, you need real-time information. This requires a platform that can unite information from disparate systems across your enterprise without compromising availability and performance. Oracle GoldenGate 19c is a high-performance software application for real-time transactional change data capture, transformation, and delivery, offering bidirectional data replication. The application enables you to ensure that your critical systems are operational 24/7, and the associated data is distributed across the enterprise to optimize decision-making.

GoldenGate 19.1 Platform New Features

For the Oracle Database

➢ Oracle Database 19c Support

Capture and Delivery support for Oracle Database 19c, cloud and on-premises.

➢ Centralized Key Management Service

Use Oracle Key Vault to centralize and manage encryption keys for the replication environment.

➢ Target-Initiated Paths

Distribution paths enabled from the Receiver Service to pull trail files.

➢ New REST API Endpoints

Retrieve active transactions and current system change number (SCN) details using REST API endpoints.

➢ New Heartbeat Table Command

The UPGRADE HEARTBEATTABLE command upgrades the Heartbeat table from prior versions of Oracle GoldenGate to the 19.1 version.

➢ Cross-Endian Support for Remote Integrated Extract

Automatically enabled when the server where the Integrated Extract is running is different from the server where the Oracle Database is running.

For MySQL

➢ MySQL 8.0 Support for Capture and Delivery

Capture and Delivery support for MySQL 8.0 has been added.

➢ MySQL SSL Connection Support

Extract and Replicat can now connect to a MySQL database via SSL.

For DB2 for i

➢ Enhanced TIMESTAMP Support

Supports all valid TIMESTAMP precisions

➢ New Datatype Support

Support for DECFLOAT datatype.

➢ New DBOPTIONS USEDATABASEECODING Parameter

Allows Extract to store all text data in the trail file in native character encoding.

➢ Improved Extract Performance

Enhanced throughput while reducing overall processing.

➢ Security Improvements

Availability of AES Encryption. Credential Store, and Oracle Wallet.

➢ Long Running Transaction (LRT) Support

Support for LRT features showtrans, skiptrans, forcetrans.

For DB2 z/OS

➢ Enhanced TIMESTAMP Support

Supports all valid TIMESTAMP precisions

➢ Online Schema Change Support

Support for online TABLE CREATE, DROP and ADD, ALTER, DROP COLUMN commands.

➢ Long Running Transaction (LRT) Support

Support for LRT features showtrans, skiptrans, forcetrans.

For DB2 LUW

➢ Enhanced TIMESTAMP Support

Supports all valid TIMESTAMP precisions

➢ New Datatype Support

Support for DECFLOAT datatype.

➢ Long Running Transaction (LRT) Support

Support for LRT features showtrans, skiptrans, forcetrans.

Other Information

➢ In the initial release, OGG 19.1.0.0.0, Linux builds will be available for most Database/OS combinations that are supported, followed by tiered releases for other supported platforms.

➢ GoldenGate for SQL Server will be released for both Windows and Linux soon, in a 19.1.x release.

Docs, Downloads, and Certification:

• Documentation is available at: https://docs.oracle.com/en/middleware/goldengate/core/19.1/index.html

• Downloads are available through OTN at: https://www.oracle.com/middleware/technologies/goldengate.html

• Certification Matrix (19.1 Cert Matrix to be posted soon):
https://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Join us in upcoming events:

• Stay up to date by visiting our Data Integration Blog for up to date news and articles.

Save the Date! Oracle OpenWorld is September 16th through the 19th.
Don’t hesitate to contact us for any special topics that you might like to discuss. 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.