At the time of writing, a new version of Oracle GoldenGate was released; version 11.1.1. This is being marketed by Oracle as 11g to bring the product in line with their 11g product suite. The new version is mentioned in Chapter 9, Performance Tuning due to its performance enhancing new features. However, another mention allows other benefits to be realized.
Oracle GoldenGate 11g now falls into the Oracle Data Integration product line along with Oracle Data Integrator (ODI), Oracle Veridata, and Oracle Management Pack for GoldenGate. When coupled with GoldenGate 11g, ODI provides fast, efficient, loading, and transformation of data into a data warehouse through its Extract Load and Transform (ELT) technology.
In addition, Oracle GoldenGate 11g includes the following enhancements:
Certified for operational reporting solutions on Oracle Applications such as Oracle E-Business Suite, Oracle PeopleSoft, and Oracle JD Edwards
Certified with the Oracle Exadata 2 Database Machine
Note
The Oracle GoldenGate certification matrix can be found on the Oracle website at the following address:
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html.
When coupled with ODI, it provides integration with Oracle JDeveloper and Oracle Enterprise Manager
Support for Oracle TimesTen in-memory databases
Although not a new product, Veridata is a new member of the Oracle Data Integration product suite. It is a high-speed data comparison solution that identifies and reports on data discrepancies between heterogeneous databases. The product’s operation is transparent to the live business processes, allowing comparisons to be run during peak times whilst incurring minimal overhead.
Oracle Management Pack for GoldenGate is another product under the Oracle Data Integration umbrella. Already mentioned in Chapter 8, Managing Oracle GoldenGate, it is essentially GoldenGate Director, a web-based client application for centrally managing GoldenGate instances. It provides real-time monitoring including automatic alert notifications, as well as managing deployments in GoldenGate environments. Like Oracle Veridata, Oracle Management Pack for GoldenGate runs transparently, with little to no impact to live systems.
Oracle GoldenGate documentation and the Data Replication forum can be found on the Oracle Website at the following respective addresses:
As the need to store and report on data increases, the demand for data integration and replication tools will continue to increase. Oracle’s continued development of GoldenGate will prove very interesting over the next few years, as they strive to maintain high performance against high data volumes and transaction rates.