Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Valued Contributor II

QV connectivity to mySQL


How to make connection to mySql database, what are the pre-requisites to make connection .

I am having QV 11.2 64bit.

7 Replies

Re: QV connectivity to mySQL

You need to have a MySQL ODBC driver installed, and then you need to set up a DSN in the Windows ODBC Administrator.

Honored Contributor II

Re: QV connectivity to mySQL

try with the following steps,

1. first install mysql drivers on ur dev box

2. if u are able to see the oledb driver of mysql from ur qlikview edit screen--Data tab--provider--then u can create oledb connection,else follow 3rd steps and forget about 2nd step

3.create a dsn connection from control panel--administrative tools--data sources (odbc)

4. got o ur edit screen in qlikview--select odbc from data tab--click connect button---see the list --from here u have to choose ur dsn connection which u created earlier.

5.select sql script--load it.

Re: QV connectivity to mySQL

First install the MYSQL ODBC driver and then you need to add in DSN .

In the server you need to retain the same ODBC name , username and password

Re: QV connectivity to mySQL

Qlik recently launched the new ODBC and SFN connector. This new release lets you connect straight to a variety of database products (including MySQL) without defining a DSN or anything else. It even includes all required drivers.

(Being a partner, you can) Log in into the Downloads portal and select Connector->Qlik ODBC Connector. Check the release notes for more details.

Good luck,


Honored Contributor III

Re: QV connectivity to mySQL

Hi Peter,

I'm afraid that doesn't work with frre version.

QV ODBC x MySql.png



Re: QV connectivity to mySQL

Where did you read that he's using a free version? "free" doesn't sound very business-like.

Honored Contributor III

Re: QV connectivity to mySQL

I'm using MySQL Community Server.

You need MySQL Enterprise or Commercial version.

Community Browser