Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

valentin_lhomme
New Contributor II

Load data from MySQL with MySQL Connector

Hello,

After loading data from a table, all string data are visible as System.Byte[], only date and int type are visible.

Does anybody know how to solve that issue ?

Capture d’écran 2018-07-20 à 15.18.00.png

Valentin

1 Solution

Accepted Solutions
valentin_lhomme
New Contributor II

Re: Load data from MySQL with MySQL Connector

I resolved the issue doing the solution given here Qliksense connector for Mysql Community Edition?

Be careful with native Qlik connector, I installed Qlik-ODBC-connector before and then uninstalled it to retreive default Qlik Sense connector, but they disappeared during the operation.

2 Replies
valentin_lhomme
New Contributor II

Re: Load data from MySQL with MySQL Connector

It appears to be because of data interclassement format which is utf8mb4_bin that I am unfortunately authorised to modify.

valentin_lhomme
New Contributor II

Re: Load data from MySQL with MySQL Connector

I resolved the issue doing the solution given here Qliksense connector for Mysql Community Edition?

Be careful with native Qlik connector, I installed Qlik-ODBC-connector before and then uninstalled it to retreive default Qlik Sense connector, but they disappeared during the operation.

Community Browser