Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Zero records fetched when extracting from Oracle database, whereas when connecting from ODBC we could see the data.
Any help would be appreciated.
@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...
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!