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 IBM Netezza 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 IBM Netezza database. This is optional.

4. Select Target as the database role.

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

8. Type the IBM Netezza authentication information (User Name, Password) for the authorized user for this IBM Netezza database. If you do not know this information, see your IBM Netezza 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 IBM Netezza user entered in the IBM Netezza 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 IBM Netezza database.