Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Peter_Cammaert

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)