topic Re: Can't connect Amazon Redshift database to Qlik Sense Error in Visualization and Usability

Can't connect Amazon Redshift database to Qlik Sense Error

matthewp — Sat, 16 Nov 2024 19:57:37 GMT

I am trying to connect a Redshift DB to QlikSense but I am getting the following error:

ERROR[08S01][Qlik][Amazon Redshift](10) Error occured while trying to connect:[SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "XXXX" (XX.XXX.XXX.XXX) and accepting TCP/IP connections on port 5439?

All of the credentials are correct as I can connect via Aginity fine.

Re: Can't connect Amazon Redshift database to Qlik Sense Error

FMDF — Thu, 03 Dec 2020 15:28:21 GMT

I know this is an old post, but did you ever figure this out?

Re: Can't connect Amazon Redshift database to Qlik Sense Error

Gary20 — Thu, 30 Mar 2023 14:56:57 GMT

The environment I used was AWS Redshift serverless. The outbound and inbound rules were 'accept all'. It was also able to establish connections outside of AWS.

I had to open port 5439 on Redshift. Now if that still doesn't work. Add the qlik cloud ip addresses for your region to your Redshift security rules.

Link for the ip addresses: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-dns-ip.htm