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 ODBC 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 ODBC endpoint. This can be any name that will help to identify the endpoint being used.
3. In the Description field, type a description that helps to identify the ODBC endpoint. This is optional.
4. Select Target as the endpoint role.
5. Select ODBC as the endpoint Type.
6. Select one of the following:

   • DSN: Select this to connect to an ODBC-supported endpoint using a DSN. When you select DSN you must select the DSN you are using from the list.

     Information note

     When connecting to SQL/MP, you must use a connection string, which should include the name of the Replicate ARC Unicode ODBC driver. See Connection String for an example.

     If the DSN you want to use is not included in the list, make sure that the endpoint client is installed on the computer with Qlik Replicate and that the DSN is defined. Note that the ODBC provider client must be 64-bit. For more information, see Prerequisites .

     Information note

     If you are using an ARC CDC Agent as the source in a Replicate task, you cannot select the DSN for the Qlik ODBC driver as the target. In this case, to use Qlik ODBC as a target, you must enter the connection string manually by selecting Connection String and following the directions for that option in this procedure.

   • Connection String: Select this to connect to an ODBC-supported endpoint using a connection string then type a valid connection string in the field below. For information on how to create a connection string, see the documentation for the ODBC endpoint provider you are using.

     Example of an SQL/MP Connection String:

     Driver={Qlik Replicate ARC ODBC Driver 3.5 (Unicode)};BindUrl=attconnect://ais_server_ip:ais_server_port/ais_workspace;DefTdpName=ais_target_datasource_name;OneTdpMode=1;qptdpname=BINDURL1;queryProcessor/noThreads=true;}}

     Note that if you specify a password in your connection string, it will be revealed as plain text in the task log files. It is therefore recommended to specify the password in the GUI Password field.

     Information note

     • You can use the Advanced tab to add specific properties and create a custom connect string. In this case, you do not need to enter information in this tab. For more information on using the Advanced tab, see Setting advanced connection properties.

     • To determine if you are connected to the endpoint you want to use or if the connection information you entered is correct, click Test Connection.

       If the connection is successful a message in green is displayed. If the connection fails, an error message is displayed at the bottom of the dialog box.

       To view the log entry if the connection fails, click View Log. The server log is displayed with the information for the connection failure. Note that this button is not available unless the test connection fails.

7. Type the authentication information (User Name, Password) for the authorized user for the ODBC endpoint being used. For example, the IBM DB2 system administrator if you are using a IBM DB2 provider. If you do not know this information, see your ODBC Endpoint System Administrator.

   Information note

   • When you select Connection String be sure to include User name/password information in the connection string that you type in the box.

     If you are using the Advanced tab to create a custom string, make sure to include the User Name and Password properties. For more information, see Setting advanced connection properties.

   • This information is case sensitive.
   • You can set custom properties in the Advanced tab. For more information, see Setting advanced connection properties.
   Information note

   Make sure that the ODBC endpoint user has the correct access privileges for the ODBC provider being used.