GIMDeployBCGGReplicationOverview
About Oracle GoldenGate
Oracle GoldenGate is recommended to achieve database replication for Genesys Info Mart. Oracle GoldenGate was selected as the replication tool because it is able to replicate a subset of database tables, thus saving the bandwidth that is required for data replication.
Note: Genesys has verified the Info Mart replication with Oracle GoldenGate version 11.2.1.0.1.
Tables Excluded from Replication
The Info Mart database in a large environment grows over time to a significant size. A large portion of the Info Mart tables contain raw data that Genesys Info Mart uses for internal processing and that is not suitable for end-user reports. For this reason, Genesys recommends that you limit the set of tables that are replicated to the standby site, replicating only the dimensional model and aggregate tables and excluding from replication all Temporary tables, as well as certain GIDB, Merge, Staging, and Control tables.
Genesys recommends that you exclude the following tables from Oracle GoldenGate database replication, for performance reasons.
Temporary tables
Exclude all Temporary tables (that is, all tables that have names that start with TMP_*).
GIDB tables
Exclude the majority of GIDB tables.
Aggregate tables
In deployments with RAA/GI2, exclude certain aggregate tables.
Merge tables
Exclude the majority of Merge tables.
Staging tables
Exclude several Staging tables.
Control tables
Exclude certain Control tables.