topic How do i load MySQL Database in Qlikview in QlikView

How do i load MySQL Database in Qlikview

Tue, 06 Sep 2011 06:28:26 GMT

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?

Re: How do i load MySQL Database in Qlikview

pho3nix90 — Tue, 06 Sep 2011 07:08:04 GMT

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

How do i load MySQL Database in Qlikview

Tue, 06 Sep 2011 07:35:44 GMT

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'

How do i load MySQL Database in Qlikview

pho3nix90 — Tue, 06 Sep 2011 07:42:50 GMT

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

How do i load MySQL Database in Qlikview

Tue, 06 Sep 2011 07:53:07 GMT

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

How do i load MySQL Database in Qlikview

pho3nix90 — Tue, 06 Sep 2011 07:55:16 GMT

Glad to help

Re: How do i load MySQL Database in Qlikview

Wed, 28 Nov 2012 19:41:49 GMT

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

Re: How do i load MySQL Database in Qlikview

Fri, 22 Mar 2013 18:07:24 GMT

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.

Re: How do i load MySQL Database in Qlikview

Fri, 22 Mar 2013 18:08:51 GMT

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

Re: How do i load MySQL Database in Qlikview

Thu, 18 Sep 2014 10:04:14 GMT

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

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

thanks

Re: How do i load MySQL Database in Qlikview

pho3nix90 — Thu, 02 Oct 2014 10:08:02 GMT

Is the credentials you are using allowed to connect remotely to the database?

Re: How do i load MySQL Database in Qlikview

ThornOfCrowns — Thu, 02 Oct 2014 10:22:51 GMT

You do realise that you're answering a question asked over a year ago and the original post is four years old...?

Re: How do i load MySQL Database in Qlikview

pho3nix90 — Thu, 02 Oct 2014 10:26:10 GMT

I am well aware. But it's still relevant to someone that is searching for an answer.

Re: How do i load MySQL Database in Qlikview

Thu, 29 Jan 2015 07:41:31 GMT

Hey!

I'm also new at qlikview and I have a similar question. How to access/conect the DBISAM data base (files with extensions .dat .idx .blb) to qlikview ?

I don't know much about database management. Could you or anyone PLEASE HELP me how to do it??? Much appreciated, PLEASE!!