Oracle GoldenGate provides real-time capture, transformation, routing, and delivery of database transactions across heterogeneous systems. The GoldenGate Administrator's Guide shows six supported topologies for generic databases. Oracle GoldenGate 12c is now certified for a subset of three of those methods in Oracle E-Business Suite Release 12.2 environments:
Procedures for replicating information from E-Business Suite 12.2 using GoldenGate to a secondary system are documented in:
Replication to a Non-Editioned Target Database
EBS 12.2's Online Patching architecture has significant implications for data replication solutions implemented using Oracle GoldenGate. The Note above describes how to set up a unidirectional configuration of Oracle GoldenGate replication from an Oracle E-Business Suite Release 12.2 source database to a non-editioned target database.
Using GoldenGate with EBS 12.2 environments is significantly different from previous EBS releases. If you are upgrading your GoldenGate + EBS 12.1 environment to EBS 12.2, and you must plan carefully for the new integration steps detailed in the documentation above.
GoldenGate is an extremely powerful solution, and one of its most-interesting features is the ability to provide data replication in both directions. In some generic scenarios, you can choose to make alterations to replicated data on the external instance and have those changes updated back in the source database.
Bidirectional replication is not permitted for E-Business Suite environments. You can use GoldenGate to replicate EBS data to an external database, but you cannot move that altered data back into the EBS database. GoldenGate's ability to read data in EBS databases is certified, but it must not be used to write to EBS databases.
"How" But Not "What"
GoldenGate is akin to a scalpel. You're free to use it, but you must learn how to perform open heart surgery yourself.
The document above describes how to use GoldenGate to replicate data from the E-Business Suite to another system. It doesn't provide any guidance about which database objects to replicate.
The E-Business Suite data model is vast, as you'd expect of something that has supports the integrated functioning of over 200 functional product modules. GoldenGate is a development tool, and like all development tools, requires an expert-level understanding of the E-Business Suite data model for successful use. Here's a good EBS data model resource:
Not Certified for EBS Migrations and Upgrades
GoldenGate is not certified for:
Why not? Oracle GoldenGate does not currently support the replication of all of the datatypes that are used by the E-Business Suite. In addition, GoldenGate relies upon tables with primary keys for replication. EBS has over 10,000 tables without primary keys. That means that attempting to use GoldenGate to migrate or upgrade an entire E-Business Suite database requires a combination of GoldenGate and
other manual steps to preserve referential integrity.
Oracle does not currently have any plans to produce a certified or automated method of using GoldenGate for E-Business Suite upgrades or platform migrations.
EBS 12.2 customers should use our documented procedures for upgrades and migrations.Related Articles