topic Qlik Saas MySql connection limitation in Connectivity & Data Prep

Qlik Saas MySql connection limitation

achampire — Fri, 30 Jul 2021 14:51:05 GMT

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 ?

Re: Qlik Saas MySql connection limitation

Ranganath_DR — Sun, 01 Aug 2021 14:31:44 GMT

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/MySQL-connector.htm

Re: Qlik Saas MySql connection limitation

achampire — Mon, 02 Aug 2021 07:14:18 GMT

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 ?