topic Re: QV connectivity to mySQL in QlikView

QV connectivity to mySQL

manojkulkarni — Fri, 17 Jul 2015 12:06:17 GMT

hi,

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

I am having QV 11.2 64bit.

Re: QV connectivity to mySQL

Ralf-Narfeldt — Fri, 17 Jul 2015 12:18:11 GMT

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

Re: QV connectivity to mySQL

buzzy996 — Fri, 17 Jul 2015 13:25:49 GMT

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

avinashelite — Fri, 17 Jul 2015 13:30:37 GMT

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

Peter_Cammaert — Fri, 17 Jul 2015 15:15:19 GMT

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

Re: QV connectivity to mySQL

antoniotiman — Fri, 17 Jul 2015 15:23:50 GMT

Hi Peter,

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

Regards,

Antonio

Re: QV connectivity to mySQL

Peter_Cammaert — Fri, 17 Jul 2015 15:44:07 GMT

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

Re: QV connectivity to mySQL

antoniotiman — Fri, 17 Jul 2015 15:53:43 GMT

I'm using MySQL Community Server.

You need MySQL Enterprise or Commercial version.