Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
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.
manojkulkarni
Valued Contributor II

QV connectivity to mySQL

hi,

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

I am having QV 11.2 64bit.

7 Replies
Employee
Employee

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.

buzzy996
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,

Peter

antoniotiman
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

Regards,

Antonio

Re: QV connectivity to mySQL

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

antoniotiman
Honored Contributor III

Re: QV connectivity to mySQL

I'm using MySQL Community Server.

You need MySQL Enterprise or Commercial version.

Community Browser