topic Re: Connect to Postgres database in QlikView

Connect to Postgres database

Tue, 15 Jul 2014 17:52:03 GMT

I am new to QlikView. Our data warehouse is all in Postgres hosted on

Amazon EC2. I'm having a hard time figuring out how to connect to my

Postgres database. Any help would be greatly appreciated.

Mike Malloy | Marketing | apigee <https://apigee.com/> | m:

+1.650.815.1769 | twitter @ <http://twitter.com/mmalloyapigee>mmalloyapigee

@apigee <https://twitter.com/apigee>

<https://pages.apigee.com/i-love-apis-2014.html?utm_source=sig&utm_medium=email>

Re: Connect to Postgres database

VishalWaghole — Thu, 17 Jul 2014 04:30:59 GMT

Hi Mike,

First, download the most recent version of the driver according to your computer's architecture (32bit or 64 bit).

Then go to Startup button, select Control Panel, Administrative Tools, ODBC Sources, and Add a new one (to create a System DSN you will need admin rights in your computer. You can create either a user DSN). Apart from that, you will need basically the server address, a username and password to read from the database.

Then in QlikView, go to the Script Editor, and in the lower part of the dialog select Database, ODBC. Select the one you've just created, test the connection (load a few records) and that's all.

Hope that helps.

-- Regards,

Vishal Waghole

Re: Connect to Postgres database

Wed, 23 Jul 2014 22:19:10 GMT

I couldn't use an ODBC connection because we use a lot of materialized views that don't show up in the list. I switched to OLE DB. I went through the steps to set it up and loaded it into Qlik. The tables themselves show up fine. I chose one and then clicked Reload and got an error that the table could not be found. This is confusing because I chose the table from the list in Qlik. So no tables or fields are loaded and I can't get any data in the system yet. Possibly a Qlik rep can help resolve this.