Add Source Database to Analytics Warehouse
Source configuration performs the following functions:
- Set up the data pipeline between the source and target.
- Create the required tables in the target replication layer to store replicated data.
- Configure star schemas specific to the source.
- Setup the incremental Oracle Golden Gate data sync process.
The Oracle Universal Installer must be used to configure a source. Follow the instructions provided in the Oracle Utilities Analytics Administration Guide to configure a source. The following image illustrates the high-level activities performed by the installer at the time of source configuration and all components that require validation. High-level tasks shown in gray will be performed by the installer at the time of source configuration.
On this page:
About Input Parameters for Source Configuration
Oracle Universal Installer for Oracle Utilities Analytics will be used to perform source configuration. The following input parameters will be provided to the installer at the time of source configuration. Have the values for these parameters readily available before running the config.sh.
Parameters on the Source Details Installer Page
| Parameter | Description and Example Value |
|---|---|
|
DB Host |
Name and domain of the host where the source database is running. examplehost2.exampledomain |
|
DB Port |
Port number that the source database listens on. The default Oracle database listen port is 1521. |
|
DB Service Name |
Oracle databases require a unique service name. The default service name is orcl. orcl.exampledomain |
|
DB Home Path |
Source application database installed location. /u01/app/oracle/product/19.0.0/dbhome_1 or /u01/app/oracle/product/19.0.0/client_1 |
|
Drill Back URL |
Source application URL. This will be used to drill back from the analytics to their respective source application to see the detail data. |
|
DB Schema Name |
Source application database schema name. CISADM |
|
Extract Start Date |
This will be used to slice historical source data equally in the replication schema at the time of initial replication synchronization from Extract Start Date till the system date. Please note this date will not be used for filtering purpose. Oracle Utilities Analytics Warehouse extracts all data for configured tables from the source database. 01-Jan-2000 |
|
Socks Proxy |
Socks is an Internet protocol that exchanges network packets between a client and server through a proxy server. If a socks proxy has been setup, then provide the proxy server host name and port number separated by a colon (:) else keep this parameter as blank. |
Parameters on the GoldenGate Details Installer Page
| Parameter | Description and Example Value |
|---|---|
|
Host |
Oracle Utilities Analytics Warehouse replicates change data using Oracle GoldenGate. It is not mandatory that GoldenGate has to be installed in the application database host, but we recommend this for better performance. This parameter is for the host name where GoldenGate is installed to capture change data from the source database. examplehost2.exampledomain |
|
Home Path |
Oracle GoldenGate installation location. /user_home/Oracle/OGG_HOME |
|
Source Database Home |
Source application database installation location. /u01/app/oracle/product/19.0.0/dbhome_1 |
|
Manager Port |
A dedicated port for communication between itself and other Oracle GoldenGate processes. 7809 |
|
Encryption Algorithm |
Oracle Utilities Analytics Warehouse uses AES128 algorithm to encrypt the database user password and the data in the extract trail files. AES128 |
|
Encrypt Key |
The encryption key used to encrypt the GoldenGate owner password and capture trail files data. CCB1KEY |
|
Shared Secret |
Encrypted password of source GoldenGate owner user using above encryption algorithm and encryptkey. AADAAAAAAAAAAAIAKPYCXEJIUIHH CGTHLBVCEAGEYEGCVNMKBUBFAFCH FOEQGHARCZFOBPDZCNJYB |
|
GoldenGate Owner User |
GoldenGate owner user name. This user will be used to read change data from the redo/archive logs and capture into extract trail files. CCB01SRC |
|
GoldenGate Owner Password |
GoldenGate owner user password. myGGowner123 |
Parameters on SourceJAgent Details Installer Page
| Parameter | Description and Example Value |
|---|---|
|
JAgent Host |
Name and domain of the host where Oracle GoldenGate monitoring agent is installed. examplehost2.exampledomain |
|
JAgent GoldenGate |
Oracle GoldenGate monitoring agent instance location. /app/oracle/config/Agents/OGGMonitorInstance |
|
JAgent Port |
Port (RMI port) number on which Oracle GoldenGate JAgent is running on the source GoldenGate host. 5557 |
|
JAgent User |
GoldenGate Monitoring Agent (JAgent) user name. oracle |
|
JAgent Wallet Password |
GoldenGate Monitoring Agent (JAgent) password. myJagentpw312 |