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.
You can also use MySQL files as a source. For more information, see Using the Qlik Replicate file channel.
To add a MySQL source endpoint to Qlik Replicate:
- 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.
- In the Name field, type a name for your endpoint. This can be any name that will help to identify the database being used.
- In the Description field, type a description that helps to identify the MySQL database. This is optional.
-
Select Source as the endpoint role.
-
From the Type drop-down list, select MySQL.
Information noteWhen this endpoint is used as a duplicated source in a Log Stream Staging setup, select the Read changes from log stream staging folder check box and then select the relevant Log Stream Staging task from the drop-down list.
For information on setting up and managing Log Stream Staging tasks, see Using the Log Stream.
- In the Server Name field, enter the host name or IP address of the computer on which the MySQL database is installed.
- Optionally, change the default port (3306).
-
Type the MySQL authentication information (User Name, Password) for the authorized user for this MySQL database. If you do not know this information, see your MySQL database Administrator (DBA).
Information noteConsider the following:
-
This information is required. If you are using the Advanced tab to create a custom string, make sure to include the User Name and Password properties. 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.
Information noteMake sure that the MySQL user entered in the MySQL Authentication section has the correct access privileges. For information on how to provide the required privileges, see Required permissions.
-
SSL authentication options
In the Security section, you can configure Replicate to connect to the MySQL database using SSL.
- SSL Mode:
Select one of the following:
- Preferred - Establishes an encrypted connection if the server supports encrypted connections, falling back to an unencrypted connection if an encrypted connection cannot be established.
- None - Connect with a surname and password only.
- Required - Establishes an encrypted connection if the server supports encrypted connections. The connection attempt fails if an encrypted connection cannot be established.
- Verify CA - Similar to Required, but also verifies the server Certificate Authority (CA) certificate against the configured CA certificates. The connection attempt fails if no valid matching CA certificates are found.
- Verify Full - Similar to Verify CA, but also performs host name identity verification by checking the host name the client (i.e. Replicate) uses for connecting to the server against the identity in the certificate that the server sends to the client. The client checks whether the host name that it uses for connecting matches the Common Name value in the server certificate. The connection fails if there is a mismatch.
- CA path - The path to the Certificate Authority (CA) that issued the client certificate file in PEM format.
- Secret key path - The path to the client private key file in PEM format.
- Client certificate path - The path to the client certificate requested by the server.