MySQL Enterprise Edition connection
To access your data stored on a
In Qlik Sense, you connect to a
In QlikView you connect to a
Setting up the database properties
| Database property | Description | Required |
|---|---|---|
| Host name | Host name to identify the location of the |
yes |
| Port | Server port for the |
yes |
| Database | The name of the |
yes |
Authenticating the driver
Qlik Sense: MySQL Enterprise Edition authentication properties
| Authentication property | Description |
|---|---|
| Username | User name for the |
| Password | Password for the |
| Name |
Name of the The default name will be used if you do not enter a name. |
QlikView: MySQL Enterprise Edition authentication properties
| Authentication property | Description |
|---|---|
| Username | User name for the |
| Password | Password for the |
Selecting SSL settings
| SSL Mode setting | Description |
|---|---|
| disabled | SSL is disabled and the connection is not encrypted. |
| preferred | SSL is used whenever the server supports it. |
| required | SSL is required. |
| verify_ca | SSL is required and the server certificate must be verified.
|
| verify_identity | SSL is required, the server certificate must be verified, and the host name must match the host-name attribute on the server certificate.
|
Specifying certificate location
| Certificate storage | Description |
|---|---|
| Use System Trust Store | Use the |
| Full path of Trusted Certificates | The full path to the |
Miscellaneous properties
| Property | Description |
|---|---|
| Query timeout | Amount of time before a data load query times out. Can be set from 30 seconds to 65535 seconds. Default = 30 seconds |
Using Advanced options
| Option | Description | Required |
|---|---|---|
|
Name |
Name of additional properties. You can add more than one additional properties. |
no |
| Value |
Value of additional properties. You can add more than one additional properties. |
no |
