Creating Replicated Tables
With the configuration changes complete, the next step is to replicate the table by creating it in the replication schema.
To create a replica table in the replication schema:
1. On the Configuration Type page, select Upgrade Source and click Next.
The Source Product page shows all the registered source contexts.
2. Select the required source product from the Source Product list and click Next.
The Source Details page shows the previously configured values for the selected source.
3. Modify the values s required and click Next.
The table below provides a brief description of the fields on this page:
Field Name
Description
Value
DB Host
Source database host name
 
DB Port
Source database port
Default port is 1521
DB Service Name
Source database service name
 
DB Home Path
Source database home installed location.

If Oracle GoldenGate for source is not installed on the source database server, provide the Oracle client home location on the server on which Oracle GoldenGate is installed.
 
Drill Back URL
Drill back URL for the source database
 
DB Schema Name
Source schema name
 
Extract Start Date
(YYYYMMDD)
Date from which data should be extracted from the source
 
Socks Proxy
Socks proxy host and port separated by a ‘:’
Provide the value only if a socks proxy has been setup. Else, leave the field blank.
Important! While upgrading a source registered using Oracle Utilities Analytics versions prior to 2.7.0, values for the database schema name and drillback URL do not appear by default. These parameters must be entered to proceed with the upgrade of the source.
The GoldenGate Details page shows values for the selected source that were configured previously.
4. Modify the values where required and click Next.
The table below provides a brief description of the fields on this page.
Field Name
Description
Value
Host
Source GoldenGate server host
 
Home Path
Oracle GoldenGate installed location on the source database server
Example:
opt/local/ggs_home
Source Database Home
Source database home installed location
 
Manager Port
Port number on which Oracle GoldenGate Manager is running on the Oracle GoldenGate host.
Default dynamic min port is 7830.

Default dynamic max port is 7880.
Encryption Algorithm
Algorithm configured in Oracle GoldenGate on the source server
AES128
Encrypt Key
Encrypt Key configured in Oracle GoldenGate on the source server
Provide encryptkey created while setting up GoldenGate on source database server.

For details, refer to the Setting up Oracle GoldenGate on the Source Database Server section in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
Shared Secret
Shared secret key configured in Oracle GoldenGate on the source server
For instructions to get this value, refer to the Generating the Shared Secret Password section in the Oracle Utilities Analytics Warehouse Installation and Configuration Guide.
GoldenGate Owner User
User name of GoldenGate Owner user
 
GoldenGate Owner Password
Password of GoldenGate Owner user
 
Important: While upgrading a source registered using Oracle Utilities Analytics versions prior to 2.7.0, parameter values for Oracle GoldenGate Owner User and Oracle GoldenGate Owner Password are not populated by default. These parameters must be re-entered to proceed with upgrade of the source.
5. On the Source JAgent Details page, enter the following details in the respective fields. Click Next.
Field Name
Description
Value
JAgent Host
Host of Oracle GoldenGate JAgent
 
JAgent GoldenGate
Oracle GoldenGate installed location where GoldenGate JAgent is running
Example:
/opt/local/ggs_12.1.2.1.0
JAgent Port
Port number on which Oracle GoldenGate JAgent is running on the GoldenGate host
 
JAgent User
JAgent user name
 
JAgent Wallet Password
JAgent Wallet password
 
Confirm JAgent Wallet Password
Re-enter JAgent Wallet password to confirm
 
6. On the Configuration Summary page, the log file location details are displayed. Click Configure.
The Configuration Progress page shows the status of the configuration.
7. Click Next.
The Completion Summary page shows the log file location details.
8. Click Finish.
Upon completion, the status of source registration is shown in a prompt. The detailed logs of the operation are available in the logs/system/deployodi.log file on the Oracle Utilities Analytics Home page.
9. Login to SQL Developer and run the following query to verify that the table has been replicated, but there is no data in the table.
select *
from ccb1rep.ci_acct_char;