Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ODBC data for MySQL connects and retrieves tables, but displays no data.

Hi.

I'm trying to load data from a remote MySQL Community Edition database, but I'm experiencing problems. It connects correctly, allowing to select the database and displaying all tables, but no data is displayed. What could be wrong? I'm attaching a screenshot of what happens.

Regards,

Fábio

screenshot_qliksense.png

4 Replies
Not applicable
Author

Same things to me.

MySql ODBC connector works fine, when I tested connection to DB.Скриншот 2016-07-28 11.14.18.png

Not applicable
Author

I have exactly the same problem, is there someone with a solution?

Thanks

Regards

Michael_Tarallo
Employee
Employee

Hello Guys -

This is a known issue and should be fixed in the next service release. In the mean time you can use script to get the data, See solutions outlined here: Re: Why Qsense cannot load data from a Mysql table

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
denisyanov
Contributor
Contributor

Try to use new version of MySQL ODBC driver. We tested it with our MySQL database and it worked fine.