Application is taking longer to reload using Qlik ODBC connector package

Sonja_Bauernfeind — Mon, 13 Dec 2021 08:46:17 GMT

Applications are taking significantly longer to reload using the Qlik ODBC connector package connectors, for example when connecting to an Oracle Database.

Environment:

5.2 and 5.12.0

The issue is related to the configuration setting for the Qlik ODBC driver reading strategy.

There is a known issue with reload times taking a significantly longer time when using the Qlik ODBC driver.

Workarounds:

Use an ODBC System DSN or OLE DB connection, for example instead of the Qlik Oracle connector the original Oracle ODBC driver
Revert back to the previous working Qlik ODBC connector package
Change the reading strategy within the current connector (in this case using the example Oracle connection):
- Set "oracle-reading-strategy value=engine" in C:\ProgramFiles\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\QvODBCConnector.exe.config
- "oracle-reading-strategy value=connector" should be removed.

Internal Reference ID (s):

QLIK-90980

article Application is taking longer to reload using Qlik ODBC connector package in Official Support Articles

Application is taking longer to reload using Qlik ODBC connector package

Environment:

Internal Reference ID (s):