Data coming blank when extracting from Oracle Database

babitaku — Tue, 23 May 2023 14:07:12 GMT

Zero records fetched when extracting from Oracle database, whereas when connecting from ODBC we could see the data.

Any help would be appreciated.

Re: Data coming blank when extracting from Oracle Database

Jay_Brown — Thu, 25 May 2023 13:57:51 GMT

@babitaku , please check the logs on the Oracle side to see what the account is coming in as. On successful attempts it may be coming through as the user configured via the ODBC Administrator console, whereas the user may be different coming from the built-in connector.

You can try to isolate this further by adding the service account to Oracle permissions as well as testing outside of Qlik: https://community.qlik.com/t5/Official-Support-Articles/How-to-fetch-data-via-ODBC-DSN-without-using-Qlik-Products/ta-p/1713218

You can also test by going directly to the connector package located here:
C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage

Once here, launch the QvOdbcConnectorPackage.exe and use Driver: Oracle.

Hope that helps!

topic Re: Data coming blank when extracting from Oracle Database in Connectivity & Data Prep

Data coming blank when extracting from Oracle Database

Re: Data coming blank when extracting from Oracle Database