Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to connect QlikView Personal Edition to postgres sql

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.

4 Replies
Siva_Sankar
Master II
Master II

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

Anil_Babu_Samineni

Check here How to connect PostgreSQL Data thru ODBC via QLIK

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful