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.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:
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.
Create the connection using the correct driver (pick the one relevant to your character set):
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.
One Reply to “Connecting to MySQL Community Edition with Qlik Sense (System DSN with MySQL ODBC driver)”
Comments are closed.