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 SingleStore target endpoint to Qlik Replicate:

1. In the Qlik Replicate Console, click Manage Endpoint Connections to open the Manage EndpointsConnections 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 SingleStore database. This is optional.

4. Select TARGET as the database role.

5. From the Type drop-down list, select SingleStore.

6. In the Server field, enter the host name or IP address of the computer on which the SingleStore database is installed.

   Information note

   Notes 

   • This information is case sensitive.

   • 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.

7. Optionally, change the default port (3306).

8. Enter the Username and Password of a user authorized to access the SingleStore database specified below. If you do not know this information, see your SingleStore database Administrator (DBA).

9. In the Database field, specify the target SingleStore database.