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

Oracle GoldenGate 12.2 Release

Mack Bell
Senior Product Manager

In keeping with our foundation principles,
the focus for this release has been Usability, Manageability, Heterogeneity,
and Performance.  

What’s New in Oracle GoldenGate 12.2
(Replication Simplification)

GoldenGate Platform Features –for Oracle, SQL Server,
Sybase, Teradata, Informix, TimesTen, DB2 LUW, NonStop SQL/MX, PostgreSQL, and

Automatic Heartbeat Table
end-to-end replication lag and view details with a database view. Valid for heterogeneous configurations as

Metadata in Trails
No need
to generate a definitions file or use SOURCEDEFS/ASSUMETARGETDEFS.


parameter definitions from GGSCI with INFO PARAM, get the list of running
parameters for a process with SEND … GETPARAMINFO, and pre-validate parameter
files with the new checkprm utility.

One Billion Trail

file sequence length has increased to nine digits; a 1000x increase and
effectively one billion trail files.

For the Oracle Database

  • DL
    replication between more than 2 Oracle databases
  • Seamless
    DML and DDL replication between tables of differing structures
  • Replicat
    integration with the Oracle Data Pump
  • Filters
    past table data loaded to target tables from expdp/impdp: DBOPTIONS ENABLE_INSTANTIATION_FILTERING
  • Integrated
    Capture support for invisible columns
  • Offload
    fetching to Active Data Guard
  • Oracle
    Clusterware command and control integration

For SQL Server

  • Remote ALO mode Capture
  • SQL Server Standard
    Edition Capture and Delivery
  • SQL Server 2014 Compressed Log backups
  • Column level character sets

For Teradata

  • Replicat
    can process truncates
  • Column
    level character sets
  • Capture from Teradata is no longer
    supported from this version onward


  • Column level character sets
  • Temporal Tables

More information on
Oracle GoldenGate 12.2

Downloads: http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

Documentation: http://docs.oracle.com/goldengate/c1221/gg-winux/index.html

Certification Matrix: http://www.oracle.com/technetwork/middleware/data-integration/goldengate12-2-x-cert-matrix-2769360.xls

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.