Unanswered

Unable to connect To AWS Redshift with Power Automate

(4) Share

Report

Posted on by Community Power Pla...

Using Power Automate I want to connect with Amazon Redshift but can't establish connection.

I am getting below error.

ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "prd-planit-dw-05-redshift-cluster.cukzxuiolrur.eu-west-1.redshift.amazonaws.com" (10.209.22.253) and accepting TCP/IP connections on port 5439? inner exception: ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "prd-planit-dw-05-redshift-cluster.cukzxuiolrur.eu-west-1.redshift.amazonaws.com" (10.209.22.253) and accepting TCP/IP connections on port 5439? clientRequestId: 55e3d9ca-1fc0-45f4-8106-971ed19cd682

Could you please help me to resolve this.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

rajwm 6 on at

Like (2)

Report

Hi, I'm getting the same error. Trying to connect to redshift serverless. Did you find a way past this?

Was this reply helpful? Yes No
Hairy_Drumroll 251 on at

Like (0)

Report

With the ip address being a 10.* address, it looks like you need to make sure you're using an On-Premises Gateway. My problem is that the screen to add the connection doesn't allow me to select a gateway!

Edit: If I create a new Dataflow, I can select Redshift as the data source, then in the next config screen I can select a gateway. I don't need to save the dataflow, the connection is created regardless.

Was this reply helpful? Yes No
franciscooa 78 on at

Like (0)

Report

Hello!

I have the same issue as you mentioned @Anonymous. Any update?

Regards

Was this reply helpful? Yes No