GoldenGate 12c Certified with E-Business Suite 12.2

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: Unidirectional (Reporting Instance):  From the E-Business Suite to a reporting instance Broadcast (Data Distribution): From the E-Business Suite to multiple external databases Consolidation (Data Warehouse/Mart/Store): From multiple sources, including the E-Business Suite, into a single external database Procedures for replicating information from E-Business Suite 12.2 using GoldenGate to a secondary system are documented in: Using Oracle GoldenGate to Replicate Data from Oracle E-Business Suite 12.2 (Note 2004495.1) Certified Combinations EBS 12.2.5 and later 12.2.x releases Database 12.1.0.2 or 11.2.0.4 GoldenGate 12.1.2 and later 12.x releases 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. Only Unidirectional replication for EBS 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: Oracle E-Business Suite Electronic Technical Reference Manual (eTRM) Not Certified for EBS Migrations and Upgrades GoldenGate is not certified for: Upgrading E-Business Suite databases from one version to another Migrating E-Business Suite databases from one operating system platform to another 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 Comparing Oracle Data Guard vs. Active Data Guard for EBS Environments Offloading EBS 12.2 Reporting Using Active Data Guard 12.1.0.2

Ver artículo...