Oracle ODBC connection via gateway --> data discrepancies

[Timothee_Hamon]

Hello,

During our migration to Qlik Cloud, we are facing an issue with Oracle ODBC connection when we are comparing result between on premise and saas.

We used the last version of gateway, but number are consired as text in Qlik Cloud.

Can you help us?

Does anyone face the same issue?

Best regards,

Timothée H.

[NadiaB]

Hi @Timothee_Hamon 

By any chance could you share what is the field data_type on the Oracle DB? Is it a numeric data type or is it a string data type ?

Could you share the specific data type and length if applies ?

What is the max value (largest number) on that field. 

What is the version in Qlik Sense on prem (including any patch)?

Kind Regards. 

[Timothee_Hamon · Accepted solution]

Hello,

The discrepancies came from the type of the column in the source database.

Even if it has only number in it, it is defined as varchar() in the oracle database.

Since we cannot change the column type in the database, we choose to update our extracting script by using Num#() when needed (column only containing number but declared as varchar()).

Why is it different between on-premise and SaaS?
The answer is: we were not using the odbcconnector package from Qlik but the ODBC driver from microsoft server. And by using the driver, when extracting the data from the database, Qlik checked the type of data inside the column and no the type of the column.

With the gateway, and especially the bulk reader option, Qlik do not check the data line by line, but just extract the column using the defined type by the database.

Best regards,

Timothée HAMON

[Raju_6952]

Hi @Timothee_Hamon 

Are you able to fix this issue in saas?

We are also facing the same problem with the hana odbc connection setup through data gateway.

Please kindly let me know if anything needs to checked to fix this issue.

Thanks in advance.

Regards,

Raju

Ia there a way to fix this 

[Raju_6952]

Hi @NadiaB ,

Is there any Qlik Bug created for this reported issue?, As we are using the latest version of the data gateway service 1.7.0 which was released on Jan\14\2025 and still facing the above mentioned issues.

Regards,

Siva Prasad

[Timothee_Hamon]

Hello,

Sadly as formentionned, we had to use function like Num#() to enforce type when needed (and it was tedious).

Best regards,
Timothee H.