Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
vuan
Partner - Contributor II
Partner - Contributor II

Qlik Cloud ODBC Data Type: Date

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

vuan_0-1756802979696.png

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.

 

 

Labels (3)
1 Reply
-SW-
Partner - Creator II
Partner - Creator II

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