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 Google Cloud SQL for SQL Server target endpoint to Qlik Replicate:

1. In the Qlik Replicate Console, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box and then click New Endpoint Connection. 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 Microsoft SQL Server database. This is optional.

4. Select Target as the database role.

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

6. In the Server name field, specify the host name or IP address of the computer with the Microsoft SQL Server instance containing the target database.

   Information note

   To override the default port, add the port to the server name, separated by a comma. For example, if the server name is myserver.company.local and the port is 3333, then the server name should be written like this:

   myserver.company.local,3333

7. In the User name field, enter the user name of an authorized database user.
8. In the Password field, enter the password of the specified user.
9. Type the Database name or click Browse and select one from the list of available databases. This is the name of the database to where you are replicating the data.