Qlik Community

Connectivity & Data Prep

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

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
achampire
Partner
Partner

Qlik Saas MySql connection limitation

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 ?

 

 

Labels (2)
2 Replies
Ranganath_DR
Support
Support

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
Partner
Partner
Author

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 ?