topic Re: DATA GATEWAY DIRECT ACESS in Data Movement & Streaming

DATA GATEWAY DIRECT ACESS

ramonneto — Wed, 19 Mar 2025 21:48:59 GMT

Hi guys, I'm facing a new problem with Qlik Cloud. In an attempt to move our ETL process to Qlik Cloud, I'm using the MySQL connector for a specific query, which is identical to the data extraction done in Qlik Sense.

What happens is that in a query, in a specific field, Qlik Cloud returns "-1" in all rows, instead of the correct information:

I know the information is incorrect, because when I query the same query in Qlik Sense (or any data reading client) I see the data correctly. Could someone check?

Re: DATA GATEWAY DIRECT ACESS

marksouzacosta — Fri, 26 Jul 2024 18:38:16 GMT

Hi @ramonneto,

Interesting problem. That sounds like a case for Qlik Support.
Can you please answer a few questions?

What is the version of the Qlik Data Gateway installed?
Which Data Connection are you using?
What is the version of you MySQL Database and what is the Column Type?

Regards,

Mark Costa

Re: DATA GATEWAY DIRECT ACESS

ramonneto — Fri, 26 Jul 2024 18:53:30 GMT

HI @marksouzacosta
1. I tested with version 1.6.6 and also with the current version 1.6.7.
2. MySQL Enterprise Edition (via Direct Access gateway). I configured the Qlik native connection service.
3. In MySQL version 5.7 the field is type "int(9) unsigned"

An interesting point is that this situation does not occur in other tables in my database.