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 INFO MANAGER command.

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 veridata.cfg file of the Veridata server. More

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