Jump to: navigation, search

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 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—with regard to both the data (DML) and schema (DDL) changes—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.

[+] See tables

Aggregate tables

In deployments with RAA/GI2, exclude certain aggregate tables.

[+] See tables

Merge tables

Exclude the majority of Merge tables.

[+] See tables

Staging tables

Exclude several Staging tables.

[+] See tables

Control tables

Exclude certain Control tables.

[+] See tables

This page was last edited on October 5, 2018, at 15:59.

Feedback

Comment on this article:

blog comments powered by Disqus