Setting general connection properties

This section describes how to configure general connection properties. For an explanation of how to configure advanced connection properties, see Setting advanced connection properties.

To add an Vertica target endpoint to Qlik Replicate:

1. In Tasks view, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box. Then click the New Endpoint Connection button.
2. In the Name field, type a name for your database. This can be any name that will help to identify the database being used.
3. In the Description field, type a description that helps to identify the Vertica database. This is optional.

4. Select Target as the database role.

5. Select Vertica as the database Type.
6. In the Server field, enter the name of the Vertica server.
7. Optionally, change the default Port (5433).

8. Type the Vertica authentication information (User Name, Password) for the authorized user for this Vertica database. If you do not know this information, see your Vertica database Administrator (DBA).

   Information note

   • This information is required. If you are using the Advanced tab to create a custom string, make sure to include the User Name and Password properties. See Setting advanced connection properties for more information.

   • This information is case sensitive.
   • If you want to set custom properties for this database, see Setting advanced connection properties.
   Information note

   Make sure that the Vertica user entered in the Vertica Authentication section has the correct access privileges. For information on how to provide the required privileges, see Security requirements.]

9. In the Database name field, enter the name of the Vertica database.