To create a Connection:

1. Click Connections in the navigation pane.

   On the Connections page that opens, enter the following parameters:

2. Enter a Name and Description for the new connection and click Next.
3. Enter the following parameters on the Agent Connection page:
   • Host Name: The DNS (Domain Name Server) host name or IP address of the host on which the Oracle GoldenGate Veridata Agent is installed.
   • 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.
   • Database: This is an optional field. You can click on Verify without selecting the datasource type. The correct datasource is identified and displayed after the verification is done :
     • Oracle
     • NSK
     • SQL Server
     • Sybase
     • DB2
     • Hive
     • Teradata
     • MySQL
     • PostgreSQL

   • Use SSL for communication: Select the Use SSL for communication checkbox for secure communication between the Veridata agent and the server.

     This option is is enabled only of you have set the server.useSsl parameter as true, while configuring SSL communication. See Parameters for Configuring SSL Communication.

   • A user name and password for connecting to the datasource (if required by the database).
   • (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.
4. Click Test Connection to confirm that the connection is. If you have selected the Use SSL for communication checkbox in the previous screen, then SSL will be used for verifying the datasource connection.