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