Creating a Connection
Enter the following details in the New Connection Assistant wizard to create a new connection:
Element | Description |
---|---|
Task1: Connection Name |
Specify a name for the new connection. |
Name |
A name for the connection. |
Description |
(Optional) Specify a description for the new connection. |
Task2: GoldenGate Connection |
Enter the GoldenGate connection details. |
Host Name or IP Address |
The DNS (Domain Name Server) host name or IP address of the host where the Oracle GoldenGate Veridata Agent is installed. See the Oracle GoldenGate Veridata Administrator Guide for installation instructions, if needed. |
Port |
The port number that is assigned to the agent (or the Manager process, if a C-agent). To find out the port number of a Java agent, view the server.port parameter in the agent.properties file within the agent's installation directory. To find out the port number for a C-agent Manager, run the GGSCI program from the agent's installation directory, and then use the |
Datasource Type |
The type of data source (for example Oracle or Teradata). |
Use SSL for Communication |
Select this check box for secure communication between the Veridata agent and the server. If this check box is not selected, then plain socket communication is used between the Veridata agent and the server. This check box is disabled by default. You can enable SSL communication for all connections by changing the SSL setting in the |
Task3: Datasource Connection |
Enter more details for this connection. |
User |
Specify a user name for connection to the data source during a comparison. This user should have the required permission to query all of the tables to be compared. More Note: When no "Repair User" is configured, this user will also be used as the repair user. |
Password |
A password for connecting to the data source (if required by the database). |
Datasource Connection for Repair (Optional) |
A separate user can be configured for executing repair operations at the target database. This user needs permission to update as well as to query the tables. More |
Repair User |
Specify a user name for connecting to the data source. |
Repair Password |
Specify the password for the above user name. |
Click the Test Connection button to confirm that the specified information is correct. If you have selected the Use SSL for communication check box in the previous screen, SSL will be used for communication between the Veridata Agent and the Server.
Related Topics
"Configuring Workflow Objects" in Oracle GoldenGate Veridata User's Guide