Oracle GoldenGate will replicate in the staging server the records changed in the source. In order to perform this replication, the source table structures must be replicated in the staging server.
To replicate these source tables:
Create a new Data Model using the Oracle technology. This model must use the logical schema created when Defining the Topology. See “Using Oracle Data Integrator with Oracle” in the Oracle Data Integrator 10g Release 3 (10.1.3) User's Guide for more information on Oracle model creation. Note that you do not need to reverse-engineer this data model.
Create a new diagram for this model and add to this diagram the source tables that you want to replicate.
Generate the DDL Scripts and run these scripts for creating the tables in the staging data server.
An initial load of the source data can be made to replicate this data into the staging tables. You can perform this initial load with ODI using the Generate Interface IN feature of Common Format Designer. Alternately, you can use Oracle GoldenGate to perform this initial load, by setting the USE_OGG_FOR_INIT JKM option to Yes when Configuring CDC for the Replicated Tables.
Note: See “Common Format Designer” in the Oracle Data Integrator 10g Release 3 (10.1.3) User's Guide for more information on diagrams, generating DDL, and generating Interface IN features.
Setting up the Project
Import the JKM Oracle to Oracle Consistent (OGG) into your ODI project. For more information about importing a KM, see the Oracle Data Integrator 10g Release 3 (10.1.3) User’s Guide.
Configuring CDC for the Replicated Tables
Changed Data Capture must be configured for the replicated tables. This configuration is similar to setting up consistent set journalizing and is performed using the following steps.
Edit the data model. In the Journalizing tab of the data model, set the Journalizing Mode to Consistent Set and select for the Journalizing KM JKM Oracle to Oracle Consistent (OGG). Set or review the following KM options: LOCAL_TEMP_DIR: Full path to a temporary folder into which the Oracle GoldenGate configuration files will be generated. SRC_OGG_OBJECT_GROUP: Name of the Oracle GoldenGate source object group. SRC_LSCHEMA: Name of the logical schema of the source model. SRC_DB_USER: Source schema user name. SRC_DB_PASSWORD: Source schema user password. SRC_OGG_PATH: Oracle GoldenGate installation path on the source server. STG_OGG_OBJECT_GROUP: Name of the Oracle GoldenGate staging object group. STG_HOST_NAME: Name of the staging machine. STG_MANAGER_PORT: TCP port on which the Oracle GoldenGate Manager process is listening on the staging machine. STG_OGG_PATH: Oracle GoldenGate installation path on the staging server. USE_OGG_FOR_INIT: Generate the Oracle GoldenGate processes to perform the initial load of the replicated tables. If you have performed this initial load using Oracle Data Integrator while Creating the Replicated Tables, you can leave this option to NO.
Select those of the tables you want to replicate or the model if want to replicate all table, right-click then select Changed Data Capture > Add to CDC.
Knowledge Modules Reference Guide