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. |
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 |
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 |