Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kalyandg
Contributor II

Is it possible to extract data from PostgreSQL DB running on Linux?

Hi All,

We can extract data from PostgreSQL database in both Qlikview and Qlik Sense if the database lies on Windows OS.

But is it possible to extract data from PostgreSQL db running on Linux in Qlik Sense?

Please help.

Thanks in Advance,

Kalyan

Tags (1)
1 Solution

Accepted Solutions

Re: Is it possible to extract data from PostgreSQL DB running on Linux?

Sure, no problem. You just need to configure your ODBC connection on the Qlikview / Qlik Sense client side to connect to the postgresql database on the remote linux host with the right user credentials. The OS of the machine where the postgresql software runs is irrelevant.


talk is cheap, supply exceeds demand
6 Replies

Re: Is it possible to extract data from PostgreSQL DB running on Linux?

Sure, no problem. You just need to configure your ODBC connection on the Qlikview / Qlik Sense client side to connect to the postgresql database on the remote linux host with the right user credentials. The OS of the machine where the postgresql software runs is irrelevant.


talk is cheap, supply exceeds demand
kalyandg
Contributor II

Re: Is it possible to extract data from PostgreSQL DB running on Linux?

hi Gysbert Wassenaar,

Current Qlik Sense has inbuilt connector for PostGreSQL.

till do we need to configure odbc connection in remote Linux (client side)?

Re: Is it possible to extract data from PostgreSQL DB running on Linux?

do we need to configure odbc connection in remote Linux (client side)?

I don't understand the question. You said Linux is the OS of the machine that hosts the Postgresql database server.That would make it the server side, not the client side. So the linux host does not need a client side odbc driver and connection. Your linux host does need to allow your Qlik machines to connect with the Postgresql server.

Anyway, this has little to do with Qlikview/Qlik Sense. If you have linux machines with postgresql server then you should have a linux system administrator and a postgresql dba that can help you establish a working connection between your Qlik machines and the postgresql server. If your organisation lacks those resources then you can find a lot of information on the internet. Start with postgresql.org


talk is cheap, supply exceeds demand
kalyandg
Contributor II

Re: Is it possible to extract data from PostgreSQL DB running on Linux?

ok thanks a lot for your help

schlettig
Contributor

Re: Is it possible to extract data from PostgreSQL DB running on Linux?

Hi Kalyana,

the tricky part is to configure postgres server to accept connections from your Sense/Qlikview Server.

It's a little bit like in MySQL. You need to configure a user pass _and_ IP Adress or Range inside the user table to allow access.

See for instance http://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/ .

Best,

Christian

Daniel_Charless
New Contributor

Re: Is it possible to extract data from PostgreSQL DB running on Linux?

Hi is it possible to access two different postgres database from a same server in Qlik Sense ?

Community Browser