topic how to connect to postgre sql in QlikView

how to connect to postgre sql

Sun, 06 Mar 2011 05:14:18 GMT

hi,

i need to connect to a postgre sql in linux, is there anyone who already done this? i dont know how to configure/create connection from windows through qlikview.

Thank you

how to connect to postgre sql

Miguel_Angel_Baeyens — Sun, 06 Mar 2011 19:37:20 GMT

Hello,

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.

how to connect to postgre sql

Tue, 08 Mar 2011 15:34:17 GMT

hi,

thank you for your responses.

Actually i already done those step and when i test the connection (through DSN ODBC config) i always get a following error : FATAL: no pg_hba.conf entry for host "192.168.0.208", user "abcd", database"trial_db"

where is the location of pg_hba.conf file that i need to configure? is it on the linux server (Fedora 4) that i trying to connect to the database? If yes, how to do this? I'm not very experience on linux.

Thank you

how to connect to postgre sql

Miguel_Angel_Baeyens — Tue, 08 Mar 2011 15:54:08 GMT

Hi,

Yes, the file pg_hba.conf is part of the postgres server configuration and it is on the postgres (linux) server. I'm afraid I cannot be of further help, since the configuration of the database may vary widely depending on your server. Do you have any system or database administrator that can do that job for you?

If not, then we should go to Google or something.

Regards.

Re: how to connect to postgre sql

Steveo250k — Thu, 20 Dec 2018 14:21:40 GMT

I'm trying to find the location too. Shouldn't it be the default location for the installation of Qlik? I don't know where that is.