Qlik Saas MySql connection limitation

[achampire]

Hello everyone,

On Qlik Saas, I made an application with an MySQL Enterprise Edition connection.
I configured it with host, port, database and credentials. I let other field by default.

While using this data connection, I am facing a limitation issues.

I query one table with 21 fields on it, but my last fields on the extraction are Null().

They are not Null() when I use a SQL request tool like SQLyog.

Is there any configuration that I can change in order to don't have this limitation and retreive correctly my data ?

[Ranganath_DR]

Hi @achampire 

See if you are using supported versions and other configurations in below link

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/MySQL/...

[achampire]

Hi @Ranganath_DR ,

I am using Qlik Sense Enterprise Saas.

MySQL version is 5.7.

Data type are correct.

I tested the MySQL Enterprise  Edition data connection on a Qlik Sense desktop.

I requested the exact same table with 21 fields.

On Qlik Sense desktop, I don't have any problem of Null() data so I assume there is a gap on the MySQL Enterprise Edition connection between Qlik Sense Enterprise Saas and Qlik Sense Desktop.

Is it something intented by Qlik or can I fix it ?