topic Re: How to connect QlikView Personal Edition to postgres sql in QlikView

How to connect QlikView Personal Edition to postgres sql

Wed, 25 Nov 2020 16:16:04 GMT

I just installed QlikView Personal Edition and trying to connect to Postgres SQL, but not able to find the right place to connect. Went through few threads here and installed psqlodbc_09_06_0310-x64 driver still I am not able to see connection for postgres in the connect ODBC window.

Please help.

Re: How to connect QlikView Personal Edition to postgres sql

Siva_Sankar — Fri, 02 Jun 2017 01:59:30 GMT

Ashutosh Singh,

You need to install the Postgres ODBC driver, then set up a System DSN in your ODBC connections. You should then be able to connect to your new ODBC connection in Qlikview.

To administer Postgres, there's a utility called PGAdmin, which is quite similar to SQL Server Management Studio.

When you create DSN, you will see two entries,

1. ANSI(x64)

2. Unicode(x64)

you need to select Unicode(x64).

-Siva

Re: How to connect QlikView Personal Edition to postgres sql

Anil_Babu_Samineni — Fri, 02 Jun 2017 04:54:37 GMT

Check here How to connect PostgreSQL Data thru ODBC via QLIK

Re: How to connect QlikView Personal Edition to postgres sql

Peter_Cammaert — Fri, 02 Jun 2017 06:35:45 GMT

Attn: you'll need "Qlik India" Group Membership to visit this link.

Re: How to connect QlikView Personal Edition to postgres sql

Anil_Babu_Samineni — Fri, 02 Jun 2017 07:22:27 GMT

Is it? Then how we move this Document as "New to Qlikview".

PS - I've search on the input but there is no keyword for that