Info Mart Database Replication
About Oracle GoldenGate
Genesys recommends that you use Oracle GoldenGate to achieve database replication for Genesys Info Mart in the active-standby architecture. 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 184.108.40.206.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—with regard to both the data (DML) and schema (DDL) changes—for performance reasons.
Exclude all Temporary tables (that is, all tables that have names that start with TMP_*).
Exclude the majority of GIDB tables.
In deployments with RAA/GI2, exclude certain aggregate tables.
Exclude the majority of Merge tables.
Exclude several Staging tables.
Exclude certain Control tables.