Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkulkarni
Partner - Specialist II
Partner - Specialist 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
Ralf-Narfeldt
Employee
Employee

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

buzzy996
Master II
Master II

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.

avinashelite

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Master III
Master III

Hi Peter,

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

QV ODBC x MySql.png

Regards,

Antonio

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

antoniotiman
Master III
Master III

I'm using MySQL Community Server.

You need MySQL Enterprise or Commercial version.