how to connect to postgre sql

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

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.

[#3]

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

[Miguel_Angel_Baeyens]

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.

[Steveo250k]

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.