Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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