How do i load MySQL Database in Qlikview

[#1]

I am new to qlikview. I need to know how to load MySQL database in Qlikview. How to create ODBC connection for this purpose. Any links or stuff on the web where i can know this?

[pho3nix90]

Hi Chetan4720,

you will need to install a connector, i have attached the install files for windows, one is for 64bit, and the other one is for 32bit

[#3]

thanks...i installed the connector. i created a user DSN and connected to 'northwind' database in MySQL. also the connection test succeeded. in Qlikview i went to 'Edit Script' and tried to use ODBC connection. The connection is successful (as it says) in Qlikview. But i am not able to see my tables from MySQL DB in Qlikview nor any columns.

Can u please help? Also i have used username and password as 'chetan' and 'chetan123'

[pho3nix90]

1. Did you select the connector when you setup the connection in ODBC, called "MySQL ODBC 5.1 Driver" ?
2. Did you enter the correct database name? could be the reason why you are not seeing anything?
3. Where you able to select a database when the connection was sucessfull, from the drop down?

[#5]

sorry i tried and i figured it out how to find the tables...actually everything was fine...i just was not finding in right place..the ccolumns from different tables are now visible when i click 'Select' button..thank u very much

[pho3nix90]

Glad to help

[#7]

remember to mark some answer as the correct, for the discussion not being open forever

[#8]

Will this work when connecting to an online dreamhost server?  Will I have to change the port from 3306?  For the TCP/IP server I'm using the one on dreamhost which is mysql.sitename.com.

[#9]

When I test the connection it say Connction Failed...  Can't connect to mysql server on 'mysql.sitename.com' (10060)

[#10]

hi

you can check your server port open or no, please check in here

http://www.yougetsignal.com/tools/open-ports/

thanks