Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kalyandg
Partner - Creator III
Partner - Creator III

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

View solution in original post

6 Replies
Gysbert_Wassenaar

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
Partner - Creator III
Partner - Creator III
Author

hi Gysbert Wassenaar,

Current Qlik Sense has inbuilt connector for PostGreSQL.

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

Gysbert_Wassenaar

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
Partner - Creator III
Partner - Creator III
Author

ok thanks a lot for your help

schlettig
Partner - Creator
Partner - Creator

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

Anonymous
Not applicable

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