Connecting to MySQL Community Edition with Qlik Sense (System DSN with MySQL ODBC driver)

April 23, 2017

As of Qlik Sense 3.2.2, the Qlik ODBC Connector package does not connect to MySQL Community Edition servers.

A large number of Linux web servers run on the community edition, so it's handy to be able to connect and extract information from this data source as well.

b 00 not community

Error message: ERROR [HY000] [Qlik][ODBC MySQL Wire Protocol driver]Connections to MySQL Community Servers are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial version.

As we can't use the connector package, we must instead load the MySQL driver and use a Windows DSN.

1. Install the relevant ODBC connector driver

Download and install the MySQL ODBC Connector Driver (from the MySQL website) on the machine running the Qlik Sense engine.

2. Set up the ODBC connection in Windows

We need to set up the ODBC connection in Windows (as you would for any other regular ODBC driver).

Open the ODBC Data Sources console:

b 01 ODBC 64

Open ODBC Data Sources (64-bit)

Navigate to System DSN and create a new data source. If you're using the same user for Qlik Sense then you can use a User DSN, but on this server, Qlik Sense runs under a different user (a service account) to normal users.

b 03 system dsn

Create a new Data Source under System DSN

Create the connection using the correct driver (pick the one relevant to your character set):

b 04 new dsn

Newly created ODBC connection in Windows

3. Create the connection in Qlik Sense

Once the connection is created in Windows, it is immediately available to Sense. Use the standard ODBC connector to access it, and load data as usual.

b 05 qlik app

Create the connection in Qlik Sense using the ODBC System DSN

Profile picture

From Dave, who writes to learn things. Thoughts and views are his own.

© 2024, withdave.