Discussion board where members can get started with QlikView.
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?
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
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'
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
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.