Unanswered

Connecting to MySQL hosted in AWS - Power Automate Flow

(0) Share

Report

Posted on by AnonymousTHGR

Hi all,

Trying to build a Power Automate flow that will connect to a MySQL database hosted in AWS. Currently using an M365 service account on the flow that has the power automate premium license, and therefore the premium MySQL connector.

Main aim is to export the MySQL database as a CSV and upload it to SharePoint online to be viewed in a read-only state. However, having issues connecting to the MySQL database. Any suggestions? Getting the below error:

Categories:

Using connectors

I have the same question (0)

All responses (8)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Did you set up a gateway in AWS as well?

Was this reply helpful? Yes No
AnonymousTHGR 8 on at

Like (0)

Report

Hi there,
We were given the details for what appears to be the URL for the sql database, as well as a port number. So would this gateway have to be setup by someone in AWS? How would this then be connected to in Power automate?

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

You set the gateway up and make the flow developers connection creators in the gateway. Then they can create the required connection in the flow action.

Was this reply helpful? Yes No
AnonymousTHGR 8 on at

Like (0)

Report

Thankyou, although what do you mean by 'make the flow developers connection creators in the gateway'?

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

As the gateway administrator you add them to the gateway as connection creators.

Was this reply helpful? Yes No
AnonymousTHGR 8 on at

Like (0)

Report

Perfect okay thankyou, I will talk to the client about setting this up and it should hopefully work

Was this reply helpful? Yes No
AnonymousTHGR 8 on at

Like (0)

Report

Just to confirm is this the type of gateway you're referring to? Just looking at how to set one up Creating a gateway - AWS Storage Gateway (amazon.com)

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

No, you are looking for a Microsoft Enterprise Gateway.

Was this reply helpful? Yes No