Setting general connection properties

This section describes how to configure connection properties.

To do this:

1. In the Qlik Replicate Console, 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, specify a name for your endpoint. This can be any name that will help to identify the endpoint being used.
3. In the Description field, optionally enter a description that helps to identify the endpoint.

4. Select Source as the endpoint role.

5. Select Google Cloud SQL for SQL Server as the endpoint Type.

6. In the Server field, specify the IP address of the computer with your SQL Server database.

   Information note

   To override the default port, add the port to the IP address, separated by a comma. For example, if the IP address is 34.123.11.180 and the port is 3333, then the server name should be entered like this:

   34.123.11.180,3333

7. Specify a Username and Password for connecting to SQL Server. The user should be created using Google Cloud Console.

   Information note

   To ensure that the password provided to Replicate is never used by any other principal, Replicate can be configured to automatically replace the user-entered password with a strong random password. For more information, see Configuring Replicate to Automatically Replace the User-Entered Password.

   Information note

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

   Information note

   Make sure that the SQL Server user has the correct access privileges. For information on how to provide the required privileges, see Required permissions.

8. Type the Database name or click Browse and select one from the list of available databases. This is the name of the Microsoft Azure SQL Managed Instance database from where you are replicating the data.