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 a Teradata Database Target 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. For more information on adding an endpoint to Qlik Replicate, see Defining and managing endpoints.
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 Teradata Database. This is optional.

4. Select Target as the database role.

5. Select Teradata Database as the database Type.
6. Type the Server name. This is the name of the computer with the Teradata Database instance you want to work with.

7. Type the Teradata Database authentication information (Username, Password) for the authorized user for this Teradata Database. If you do not know this information, see your Teradata Database system manager.

   Information note

   Consider the following:

   • If you are using the Advanced tab to create a custom string, make sure to include the USERNAME property. A Password can also be included but is not required. 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.

   • To determine if you are connected to the database 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.

   Information note

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

8. Type the Default database name or select one from the list of available endpoints. This is the name of the Teradata Database where you are replicating the data to.

   For more information, see Teradata Database target load options.