Connect from MySql data

[#1]

Hi Folks,

How to connect with MySql data and load into qlikview and make qvd, I am newbiew help please.

Thanks

[jaimeaguilar]

Hi,

You can connect either by ODBC or using OLEDB. It is easier to configure through OLEDB because you only need to type user, password and the location of DB to get access to the database.

All you need to do is going to script window (ctrl + e) then follow these instructions:

1) in the bottom of the window in data tab, select OLEDB > check or uncheck force 32 bits depending on the architecture of your DB, then connect

2) Select OLEDB provider for sql server

3) Enter the data that is requested, and finally press test connection. Then you'll be able to see your tables and extract data by pressing "Select" in the main script window

regards

[#3]

I want to connect to Mysql how to do that please help!!

Any one please help me for this.. its bit urgent....

Thanks

[#4]

Any one please help for this..

[#5]

Do you already have an ODBC connection on your computer for the MySQL database? If not, you will need to create one (and download the MySQL driver if it is not already installed on your computer) at the MySQL website, go to Downloads and search for ODBC MySQL Connectors.

Once you have an ODBC connection configured, in QlikView on the Script Editor, under the Data tab:

- select ODBC in the database section

- press the Connect button

- select the MySQL ODBC connection you created

[jaimeaguilar]

Sorry I read Sql Server instead of MySql. You can connect through ODBC, Here you can download the driver:

http://dev.mysql.com/downloads/connector/odbc/

Then just install the odbc connector and configure the Dsn in windows, depending on your db architecture (32 or 64 bits):

As a tip configure your odbc connector as a "System DSN", so it can be accesed by any use