topic Connecting QlikSense Desktop to Postgresql on AWS EC2 in Connectivity & Data Prep

Connecting QlikSense Desktop to Postgresql on AWS EC2

fusionet — Thu, 06 Jun 2019 09:52:46 GMT

Hi All,

Looking for some advice on connecting QlikSense Desktop (which is a server) to a Postgresql in Linux on an AWS EC2 instance.

I read the documentation and have everything down, from the hostname, post, dbname and so on registered on the postgresql connector found on Qlik Sense Desktop. On the AWS EC2 Security Group, i have enabled an inbound connection of type TCP (Postgresql - 5432) to the server's IP address.

However when I try to create the connection, it keep saying that "connection timed out" and is the aws ec2 accepting TCP/IP connections.

Is there anything else I should consider? Would love any feedback

Re: Connecting QlikSense Desktop to Postgresql on AWS EC2

Vu_Nguyen — Thu, 13 Jun 2019 08:36:29 GMT

Can yo connect to your database with a PostgreSQL client like pgAdmin? It is important in this test that pgAdmin should be installed on the same computer with Qlik Sense Desktop, and connect with the same database account.

Re: Connecting QlikSense Desktop to Postgresql on AWS EC2

fusionet — Tue, 18 Jun 2019 05:04:54 GMT

Thanks for the direction! After tons of reading, finally got it solved!

Re: Connecting QlikSense Desktop to Postgresql on AWS EC2

Nibswoo81 — Fri, 30 Apr 2021 08:43:08 GMT

Hi @fusionet ,

How did you solve the issue in the end?

Re: Connecting QlikSense Desktop to Postgresql on AWS EC2

jmugyenyi — Tue, 08 Jun 2021 21:29:13 GMT

How did you solve this problem?