Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Why Qsense cannot load data from a Mysql table

I am a new user.

I have settled the ODBC connection from Qsense and Mysql database.

And the connection is OK.

But after connection , I select a talbe,

The page is blank, It seems Qsense cannot load the data.

I tried many tables , it is the same.

The screenshot is as follow

341.png

I dont know why.

anyone can solve this problem??

1 Solution

Accepted Solutions
damienperrin
New Contributor

Re: Why Qsense cannot load data from a Mysql table

Hi,

It seems to be a bug.

I found a workaround. After you have declared your ODBC connection "mysqlodbcsource", assuming that you know the MySQL data model, write directly your loading script :

LIB CONNECT TO 'mysqlodbcsource';

select mycolumns from mysqltables ;

It sucks, but it works. (Qlik Sense 3, either ODBC 32 or 64).

Please let me know if it works for you.

Regards

Damien

10 Replies
Not applicable

Re: Why Qsense cannot load data from a Mysql table

BTW, I cannot click the "Prepare data" button or "Load data to complete" button, they are grey.

the screenshot 341.png

Employee
Employee

Re: Why Qsense cannot load data from a Mysql table

Hi Michael,

Have you made any progress on this? This may be the ODBC driver conflicting. There are two approaches and a possible issue. I recall an issue with existing ODBC drivers installed. Is this 3.0?

  • Qlik Sense 3.0?
  • Desktop / Enterprise?
  • Are you using MySql Enterprise or Community?

There are a couple of things to look at here.

1 fix would be to use the ODBC Drivers that come with Qlik Sense if you have MySQL Enterprise.

These are self contained and DO NOT Require a separate DSN configuration.

You would use the MySQL connector in the list instead of the ODBC option.

If that is what you were using, do you have the older ODBC Connector pack installed from a previous Qlik Sense release? If so you can remove that using Add / Remove Programs. If not don't worry about it.

If you are using MySQL Community then you would need to use the Generic ODBC option and configure the proper DSN and have the proper x-bit driver installed.

I will try on my local instance and let you know how I make out.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Highlighted
Employee
Employee

Re: Why Qsense cannot load data from a Mysql table

Hello Michael - I just reproduced this with MySQL Community and the ANSI ODBC driver and using the ODBC option in Qlik Sense. Let me check with support.

Mike T

Qlik

Regards,
Mike Tarallo
Qlik
Employee
Employee

Re: Why Qsense cannot load data from a Mysql table

I tried both the 32-bit and the 64-bit ODBC drivers - same results.

Regards,
Mike Tarallo
Qlik
Employee
Employee

Re: Why Qsense cannot load data from a Mysql table

Hello Michael - this is a known issue and scheduled to fix in the next patch release, 3.01 - I apologize for the inconvenience this may have caused.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
damienperrin
New Contributor

Re: Why Qsense cannot load data from a Mysql table

Hi,

It seems to be a bug.

I found a workaround. After you have declared your ODBC connection "mysqlodbcsource", assuming that you know the MySQL data model, write directly your loading script :

LIB CONNECT TO 'mysqlodbcsource';

select mycolumns from mysqltables ;

It sucks, but it works. (Qlik Sense 3, either ODBC 32 or 64).

Please let me know if it works for you.

Regards

Damien

Employee
Employee

Re: Why Qsense cannot load data from a Mysql table

Damien - thanks - yes that works - here are the screens:

Used MySQL Workbench to grab SQL syntax just to be sure

Loaded Data

Used Columns

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Not applicable

Re: Why Qsense cannot load data from a Mysql table

Wow...

Really Brilliant...

It really makes sense.

Although I am not so familiar with how to show data in my way

Anyway, Thanks a lot.

Not applicable

Re: Why Qsense cannot load data from a Mysql table

But guys,

I found another problem for loading data..

This way seems only make sense with only one app in Qsense.

Pls see the screenshot

1, in this App, I can connect and load data.

链接成功.jpg

But in this way, I can only load one table ,how to load two tables?

2,Cannot load data from the same database and table in a new app, with the same code.

连接失败1.jpg

3, I set a new ODBC as the data source, but still not.

ODBC设置.jpg

连接失败2.jpg

So, this code seems only can be used in one App with very strict condition.

Can you please figure this out??

Many thanks.

Community Browser