Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

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

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

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.

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

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

Master III
Master III

Hi Peter,

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

QV ODBC x MySql.png

Regards,

Antonio

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

Master III
Master III

I'm using MySQL Community Server.

You need MySQL Enterprise or Commercial version.