Qlik Cloud ODBC Data Type: Date

vuan — Tue, 02 Sep 2025 09:00:02 GMT

Hi Community,
I have an issue while loading data from IBM DB2 via ODBC(via Direct Access gateway). We are moving from Qlik Data Transfer to loading data direct on our QlikCloud. But there is a problem with the result.

Date fields are not dates when loading it directly.

Left: direct loading in QlikCloud and right old qvf-file uploading over Qlik Data transfer

We use the same script, ODBC System DNS with the same driver installed on our server.
The only difference is the Qlik Connection.

Editing script is NOT option, becuase we use a generic script which is loading data based on a configuration file and stores into QVD.

Do you have any Ideas?
Thank you in advance and kind regards.

Re: Qlik Cloud ODBC Data Type: Date

-SW- — Mon, 08 Sep 2025 22:42:28 GMT

Hi Vuan,

I faced the same thing when moving connection from Qlikview On prem, transferred by qdt to a direct odbc connector.

Due to the different versions of connectors it required a slight script change for the date fields and I wasn't able to find anyways around it bar creating a new gen script which was used for all data which we moved away from QDT

topic Re: Qlik Cloud ODBC Data Type: Date in App Development

Qlik Cloud ODBC Data Type: Date

Re: Qlik Cloud ODBC Data Type: Date