O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Heterogeneous environments

Although not heavily discussed in this book, one of the main features of GoldenGate is its support for heterogeneous databases. GoldenGate's decoupled architecture, plus its trail file universal data format, enables heterogeneity. This is a main selling feature for Oracle, as GoldenGate does not require additional gateways or conversion software in order to extract and replicate data across environments.

DEFGEN is an essential step in the GoldenGate configuration of heterogeneous environments. It provides the source definitions for the Replicat process to lookup. Without these, GoldenGate cannot replicate data between non-identical tables.

Specific options

So what specific configuration options are available to non-Oracle ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required