Create a MySQL Enterprise Edition connection

To access your data stored on a MySQL Enterprise Edition database, you will need to know the server and database name that you want to connect to, and you must have access credentials. Once you have created a connection to a MySQL Enterprise Edition database, you can select data from the available tables and then load that data into your app or document.

In Qlik Sense, you connect to a MySQL database through the Add data dialog or the Data load editor.

In QlikView you connect to a MySQL database through the Edit Script dialog.

Setting up the database properties

Database property Description Required
Host name Host name to identify the location of the MySQL Enterprise Edition database. yes
Port Server port for the MySQL Enterprise Edition database. yes
Database The name of the MySQL Enterprise Edition database. yes

Authenticating the driver

Qlik Sense: MySQL Enterprise Edition authentication properties

Authentication property Description
Username User name for the MySQL Enterprise Edition connection.
Password Password for the MySQL Enterprise Edition connection.
Name

Name of the MySQL Enterprise Edition connection.

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 MySQL Enterprise Edition connection.
Password Password for the MySQL Enterprise Edition connection.

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. (Not available in Qlik Sense Cloud.)
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. (Not available in Qlik Sense Cloud.)

Specifying certificate location

Certificate storage Description
Use System Trust Store Use the SSL certificate located in the standard system location used for storing trusted certificates. This property can be selected only when SSL is enabled.
Full path of Trusted Certificates The full path to the SSL certificate if it is not stored in the standard system location. This property can be selected only when SSL is enabled.

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
Note: When you connect to a MySQL Enterprise Edition database with the Data load editor or the Edit Script dialog, Test Connection enables you to test the connection before you attempt to create it.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?