5.1.1 Creating a Connection

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:
      • Apache Hive
      • HPE NonStop
      • IBM Db2
      • MariaDB
      • Microsoft SQL Server
      • MySQL
      • Oracle Database
      • PostgreSQL
      • Snowflake
      • Sybase Adaptive Server Enterprise
      • Teradata Vantage

    • 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). Database users need certain DB priviliges. See Database Privileges for the Agent Component, for more information.
    • (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.

Parent topic: Connections