How to connect a MySQL database to a Qlikview document?

[gg225]

I'm curious if there is a set way or something easy i'm missing. I've connected Qlikview documents to MSSQL databases, using the built in functions / data load editor pretty easily. However I was storing data in MySQL for a separate project and when I went to connect my database, I realized it wasn't an option  under ODBC / OLE DB in the database tab.

Does Qlik not have built in support for MySQL the way it does for MSSQL (i.e. point and click)? Do I need to download some other app / connect to bridge qlik and mysql? Or is there a script I could use to connect my database?

Thanks for the help all!

[rubenmarin · Accepted solution]

Hi, you need to install the drivers first, search for mysql ODBC or OLEDb drivers, download and install to make them available.

[gg225]

Thanks for the response! Worked like a charm. 

For anyone who comes here asking the same question as me:

1. Download here: https://dev.mysql.com/downloads/connector/odbc/

2. go to your data source administrator and set up your desired connection. Then go to Qlik, and under the 'ODBC' database option on the script editor page, check 'show user DNS'. Your connection should be there!