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.
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. |
| PDB Name |
Source PDB name. For non-container database, PDB Name is the same as CDB name. The default PDB name is orcl. |
| CDB Name |
Source CDB Name |
| 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 Microservices Details Installer Page
| Parameter | Description and Example Value |
|---|---|
| GoldenGate 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 |
| GoldenGate User |
Source Oracle GoldenGate Microservices Admin user. Example: <ggadmin> |
| GoldenGate Password |
Source Oracle GoldenGate Microservices Admin user password. Example: <ggadmin password> |
| Confirm GoldenGate Password |
Confirm Source Oracle GoldenGate Microservices Admin user password. Example: <ggadmin password> |
| GoldenGate Admin Service Port |
A dedicated port for communication between itself and other Oracle GoldenGate processes. Example: 9401 |
| GoldentGate Algorithm |
Oracle Utilities Analytics Warehouse uses AES128 algorithm to encrypt the database user password and the data in the extract trail files. AES128 |
| GoldenGate Encrypt Key |
The encryption key used to encrypt the GoldenGate owner password and capture trail files data. CCB1KEY |
| GoldenGate Distribution Service Port |
A dedicated port for communication between itself and other Oracle GoldenGate processes. Example: 9402 |
| GoldenGate Owner User |
GoldenGate owner username. 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 |
| Confirm GoldenGate Owner Password |
Confirm GoldenGate owner user password. myGGowner123 |