topic Re: Connect from MySql data in QlikView

Connect from MySql data

Mon, 30 Jun 2014 15:16:23 GMT

Hi Folks,

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

Thanks

Re: Connect from MySql data

jaimeaguilar — Mon, 30 Jun 2014 15:35:14 GMT

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

Re: Connect from MySql data

Mon, 30 Jun 2014 18:42:52 GMT

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

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

Thanks

Re: Connect from MySql data

Mon, 30 Jun 2014 20:29:33 GMT

Any one please help for this..

Re: Connect from MySql data

Mon, 30 Jun 2014 20:35:48 GMT

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

Re: Connect from MySql data

jaimeaguilar — Mon, 30 Jun 2014 21:10:00 GMT

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