Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Connecting to mysql database

Hi guys.

I want to start with Qlik sense desktop to test its features. My data source is mysql running on centos 7 linux server. In order to connect to this database, I selected MySql Enterprice Edition in the first step pf the "Add data" process. I filled out the form with correct info (I checked host, username and password) to connect to database. But it gives error message with description: general error! How can I gain more info about the error to see the connection problem? How can I resolve the problem? Any help will be appreciated.

2 Replies
petter
Not applicable

Re: Connecting to mysql database

Have you tested the connection from the ODBC Manager in Windows and succesfully connected there?

jaimeaguilar
Not applicable

Re: Connecting to mysql database

Hi,

You can install the MySQL odbc connector and then  you can create a system (or user) DSN connection in windows ODBC manager. Just make sure to configure correctly either 32 o 64 bit depending on your needs,

regards