topic Re: Oracle ODBC connection via gateway --> data discrepancies in Connectivity & Data Prep

Oracle ODBC connection via gateway --> data discrepancies

Timothee_Hamon — Tue, 30 May 2023 07:39:23 GMT

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.

Re: Oracle ODBC connection via gateway --> data discrepancies

NadiaB — Fri, 23 Jun 2023 16:51:03 GMT

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.

Re: Oracle ODBC connection via gateway --> data discrepancies

Timothee_Hamon — Mon, 26 Jun 2023 07:50:40 GMT

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

Re: Oracle ODBC connection via gateway --> data discrepancies

Raju_6952 — Wed, 22 Jan 2025 20:02:54 GMT

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

Re: Oracle ODBC connection via gateway --> data discrepancies

Raju_6952 — Thu, 23 Jan 2025 05:29:19 GMT

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

Re: Oracle ODBC connection via gateway --> data discrepancies

Timothee_Hamon — Thu, 23 Jan 2025 08:37:08 GMT

Hello,

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

Best regards,
Timothee H.