topic QlikView desktop unresponsive while fetching even 1 row in QlikView

QlikView desktop unresponsive while fetching even 1 row

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am connecting Postgres 9.1.22 using 64 bit ODBC driver. In PostgresSQL we have huge table which has 80 GB size and 100 million rows. If I tried to fetch even 1 rows using QlikView my desktop application hangs forever. We tried it for 2 hours then killed task.

Any idea if there are issues with QlikView ODBC driver? Please suggest if any better driver can help in resolving this issue. OLEDB / JDBC preferred opensource driver.

Re: QlikView desktop unresponsive while fetching even 1 row

Anil_Babu_Samineni — Mon, 12 Feb 2018 16:54:00 GMT

Can you look Direct Discovery ‒ QlikView

Re: QlikView desktop unresponsive while fetching even 1 row

Peter_Cammaert — Mon, 12 Feb 2018 17:19:46 GMT

"Any idea if there are issues with QlikView ODBC driver?"

Which version of the Qlik ODBC Connector package are you using? The current package doesn't seem to support PostgreSQL 9.1, only versions 8.4, 9.2 and 9.4.

See PostgreSQL ‒ Qlik Connectors

Re: QlikView desktop unresponsive while fetching even 1 row

ramasaisaksoft — Tue, 13 Feb 2018 07:06:00 GMT

Hi Paresh,

Connecting qlikview to PostgreSQL with ODBC connector

How to make connection with PostgreSQL database in Qlikvew?

May be the above links will help to you.

Re: QlikView desktop unresponsive while fetching even 1 row

Anonymous — Tue, 13 Feb 2018 07:37:57 GMT

Hi Paresh, if all else fails you could try introducing an export process into your ETL layer, maybe a CSV chopped into sensible sizes. Does your data change or is most of it static?