Oracle® Fusion Middleware

Release Notes for Oracle GoldenGate for Big Data

12c (12.3.1.1)

E89327-01

August 2017

Oracle GoldenGate for Big Data 12c streams transactional data into big data systems in real time, raising the quality and timeliness of business insights. This document contains the release notes for the 12c (12.3.1.1) release of Oracle GoldenGate for Big Data.

Topics:

1.1 New and Changed Features

This section outlines the new features that are being introduced in the release, features that have been enhanced, and changes to existing features.

1.1.1 12.3.1.1.0 Release — August 2017

  • The Elasticsearch, Kafka Connect, and Amazon Kinesis Handlers are introduced for the corresponding targets.

  • The HBase byte fields support was changed so that binary source data is moved into HBase as binary data. It is no longer converted to Base64.

  • The Kafka Connect and Kinesis Handler were changed to use templates to resolve the Kafka topic and the message key. New configuration properties are introduced and some previous properties were removed.

  • The HDFS Handler was changed to use templates to generate HDFS file names. New configuration properties are introduced and some previous properties were removed.

  • The Cloudera CDH moved to HBase 1.0.0 in CDH version 5.4.0 to keep reverse compatibility with HBase 0.98.x and earlier. The HBase client in the CDH severed binary compatibility with Apache HBase 1.0.0. This change allows you to use the HBase Handler to connect to Cloudera HBase for versions 5.4.x, which the HBase Handler is configured to use the HBase 1.0 interface to dynamically use Java Reflection.

Note:

Review Understanding What is Supported for more information about support for these new features as well as existing features.

1.2 New or Changed Properties

This section lists the properties that have been added, changed, or documented for the first time for the release.

1.2.1 Initial Release 12.3.1.1.0— August 2017

  • The HBase Handler is changed to locate the method that severed the binary compatibility by dynamically using Java Reflection.

  • The JSON Formatter property, gg.handler.name.format.omitNullValues, was added to optionally omit null fields from the output.

  • The Kafka Handler properties changed to support the use of templates and the following properties are added:

    gg.handler.name.topicMappingTemplate
    gg.handler.name.keyMappingTemplate
    
    
  • The gg.handler.name.fileNameMappingTemplate was added to the HDFS Handler.

1.3 Upgrade

There are two upgrade paths that you can choose from to upgrade to Oracle GoldenGate for Big Data 12c (12.3.1.1) and both are described in Installing and Upgrading Oracle GoldenGate for Big Data.

1.4 Deprecated Items

This section lists all items that were deprecated in each release.

1.4.1 Release 12.3.1.1.0— August 2017

  • The following Kafka Handler configuration properties have been deprecated:

    gg.handler.name.TopicName
    gg.handler.name.ProducerRecordClass
    gg.handler.name.topicPartitioning
    
  • The HDFS Handler gg.handler.name.fileSuffix property is deprecated.

1.5 Corrected Problems

This section describes the problems corrected in each release. The Bug number is the number of the BugDB ticket. For questions on specific tickets or issues, consult Oracle Support.

1.5.1 Initial Release 12.3.1.1.0 — August 2017

Bug 25735642 - Replicat abends when using gg.handler.name.format.metacols

Added a framework to allow users add meta columns into the output structure. For this release, the implementation is only for JSON output.

Bug 25064117 - HBase Tables are Out of Sync 

It is possible that the data in the source database and the data in HBase may get out of sync. You can now set the timestamp for row operations in the HBase Handler using the new gg.handler.name.setHbaseOperationTimestamp property.

Bug 22161028 - Java Adapter validation and replacement of invalid character values

When dealing with malformed input characters in the trail record that do not comply with the character set, you can now use the REPLACEBADCHAR option with Replicat so that you can control the corrective action.

1.6 Known Issues

This section describes the known issues, with any available workarounds, identified in each release . The Bug number is the number of the BugDB ticket. For questions on specific tickets or issues, consult Oracle Support.

1.6.1 Initial Release 12.3.1.1.0 — August 2017

There are no known issues.

1.7 Getting Help with My Oracle Support

Use My Oracle Support to find knowledge solutions, workarounds, and other information that is reported by customers, partners, and Oracle employees. My Oracle Support also enables you to open a Service Request. If a patch is required to resolve a service request, you will receive instructions on how to download it from My Oracle Support.

Note:

If you purchased Oracle GoldenGate and support through a distributor, contact your distributor instead of attempting to create a service request through My Oracle Support.

1.7.1 Viewing the Oracle GoldenGate Knowledge Base

To view the Oracle GoldenGate Knowledge Base, follow these steps:

  1. Browse to the My Oracle Support web site at http://support.oracle.com.
  2. Select your language and then log in with your email and Oracle password.
  3. Click the Knowledge tab.
  4. In the Select a product or product line field, enter GoldenGate, and then select an Oracle GoldenGate product from the context-sensitive list to narrow your results. (You may have to wait a few seconds for this list to appear).
  5. In the Enter search terms field, enter a search keyword or multiple keywords to focus the query.

Additional information about how to use this tab is obtained by clicking Help.

1.7.2 Creating an Oracle GoldenGate Support Request Ticket

If you cannot find an answer to your question or problem in the Knowledge Base, you can open a support request ticket with Oracle Support by following these steps:

  1. Browse to the My Oracle Support web site at http://support.oracle.com.
  2. Select your language, and then sign in with your credentials. If you have not done so, you will have to register to use this web site.
  3. Click the Service Requests tab.
  4. Click Create SR.
  5. Use the Create Service Request wizard to complete and submit your SR. Additional information about how to use this tab is obtained by clicking Help.

Oracle® Fusion Middleware Release Notes for Oracle GoldenGate for Big Data, 12c (12.3.1.1)

E89327-01

Copyright © 2015, 2017, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Oracle GoldenGate for Big Data 12c streams transactional data into big data systems in real time, raising the quality and timeliness of business insights. This document contains the release notes for the 12c (12.3.1.1) release of Oracle GoldenGate for Big Data.

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.

Accessible Access to Oracle Support

Oracle customers who 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.

The following text conventions are used in this document:

Convention Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, such as "From the File menu, select Save." Boldface also is used for terms defined in text or in the glossary.

italic

italic

Italic type indicates placeholder variables for which you supply particular values, such as in the parameter statement: TABLE table_name. Italic type also is used for book titles and emphasis.

monospace

MONOSPACE

Monospace type indicates code components such as user exits and scripts; the names of files and database objects; URL paths; and input and output text that appears on the screen. Uppercase monospace type is generally used to represent the names of Oracle GoldenGate parameters, commands, and user-configurable functions, as well as SQL commands and keywords.

UPPERCASE

Uppercase in the regular text font indicates the name of a utility unless the name is intended to be a specific case.

{ }

Braces within syntax enclose a set of options that are separated by pipe symbols, one of which must be selected, for example: {option1 | option2 | option3}.

[ ]

Brackets within syntax indicate an optional element. For example in this syntax, the SAVE clause is optional: CLEANUP REPLICAT group_name [, SAVE count]. Multiple options within an optional element are separated by a pipe symbol, for example: [option1 | option2].