Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How do i load MySQL Database in 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?

13 Replies
pho3nix90
Not applicable

Re: How do i load MySQL Database in Qlikview

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

Not applicable

How do i load MySQL Database in Qlikview

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
Not applicable

How do i load MySQL Database in Qlikview

  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?
Not applicable

How do i load MySQL Database in Qlikview

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
Not applicable

How do i load MySQL Database in Qlikview

Glad to help

Not applicable

Re: How do i load MySQL Database in Qlikview

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

Not applicable

Re: How do i load MySQL Database in Qlikview

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.

Not applicable

Re: How do i load MySQL Database in Qlikview

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

Not applicable

Re: How do i load MySQL Database in Qlikview

hi

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

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

thanks