Real-Time Data Integration: Oracle GoldenGate 11g Release 2 Now Available

Oracle GoldenGate 11g Release 2 (R2), the latest version of Oracle’s real-time data integration solution, is now available, featuring greater support for high-volume systems, global implementations and heterogeneous platforms, while enhancing data capture and security. In addition, increased integration with existing Oracle Applications and technologies, including Oracle Database 11g, Oracle Exadata and Oracle Enterprise Manager, enable customers to have faster and more reliable access to information across the enterprise.

“For existing customers, we are continuing to push the envelope on performance, on manageability, and ease of configuration and, with the introduction of some new platforms - Postgres for delivery and IBM DB2 on iSeries for capture - we have made the product available to a segment of the market that it wasn’t before,” Brad Adelberg, vice president of development, Oracle, tells 5 Minute Briefing.

With this release, Oracle continues to focus on improving support for high-volume systems, on global implementations and heterogeneous platforms, and on enhancing data capture and security, notes Adelberg.

Two major features in the area of global deployment are the ability to now do character set conversion in situations where the source and the target data systems have different character sets; the ability to handle non-ASCII in the schema elements – column names, tables names. Those two features should make this product much more easily used outside of North America, Adelberg says.

In addition, he says, as with every release, Oracle GoldenGate continues to enhance all of the platforms it is supporting. “With each one of those platforms, we have added specific features to keep up with those database systems.” GoldenGate now provides support for capture from, in addition to delivery to, IBM DB2 on iSeries; and new support for delivery to Postgres, says Adelberg. There is also enhanced support for MySQL, Microsoft SQL Server, Sybase, Teradata, and IBM DB2 z/OS.

In terms of performance enhancements, integrated capture enables customers to efficiently capture changed data in high-volume and high-throughput implementations by tightly integrating Oracle GoldenGate 11g R2 capture capabilities with the Oracle Database 11g engine, and Oracle Advanced Compression support allows the capture and delivery of compressed objects within Oracle Database 11g and Oracle Exadata environments.

This release also features integration with Oracle Enterprise Manager enabling Oracle customers to monitor GoldenGate instances within the same tool that they are using to monitor their Oracle components, and allows them to drill down if they see an issue, explains Adelberg.  “For a major Oracle customer, that is going to be huge improvement in this product,” he says. In addition, more powerful conflict detection and resolution enables customers to reduce the time required to detect and resolve data conflicts by automating the process across multiple deployments. When customers are running in active-active scenarios where they are making changes to two different database systems that are using bi-directional replication, there is the possibility that there can be a conflict or a change made to the same record on both sides or other types of conflicts, says Adelberg. While the product has always provided ways of resolving these conflicts, with this release, Oracle has taken the coding and SQL development out of the process so that customers can express whatever the application logic is for conflict detection and resolution easily in their GoldenGate configuration.

And, finally in this release, support for the FIPS and Blowfish encryption algorithms enables secure data movement across systems and regions.

For more information about Oracle GoldenGate 11g R2, visit