Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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)