Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
matthewp
Creator III
Creator III

Can't connect Amazon Redshift database to Qlik Sense Error

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.

1 Solution

Accepted Solutions
Gary20
Partner - Contributor II
Partner - Contributor II

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-...

View solution in original post

2 Replies
FMDF
Contributor III
Contributor III

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

Gary20
Partner - Contributor II
Partner - Contributor II

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-...