Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To connect MySql DataBase to Qlikview

Hi all,

I'm just trying to connect a Mysql Database to Qlikview but I have not been able to make it,

I have read some threads about it but no luck:(

I must say that this database is currently connected to my excel without any problem. I downloaded the corresponding ODBC connectors

About Qlikview, I went into script editor:

I select 'ODBC DataBase' and then to 'Connect',

This window appear to me, with some data sources, among them 'josue' , that is a connection that I created when trying to connect to Excel,

But when trying to connect, I got the following message error:

Can anybody help me?

Thanks a lot, people!!

2 Replies
Gysbert_Wassenaar

You will first have to install an ODBC driver for the MySQL database. Then you need to use the ODBC admin tool to create an odbc datasource for the MySQL database you want to connect to. Perhaps this article helps: Step-by-step guide on how to set up DSN in ODBC Data Source Administrator on Windows.

Or this one if you're using a 64-bit system: Install and Create MySQL ODBC Connector on Windows 7 64 bit | Plain Tutorials


talk is cheap, supply exceeds demand
alexandros17

1 Create your odbc connection from your control panel in Windows (the name is for example MyODBC)

2 use in the script: CONNECT TO MyODBC;

let me know