web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Powerautomate desktop ...

Power Automate

Answered

Powerautomate desktop mysql db connection

(0) Share

Report

Report

Posted on by sureshvignesh

38

Recently evaluating the power-automate desktop. I am trying to upload a excel data in MySQL db.

I am having the 'mysql-connector-odbc-8.0.21' connector (32 bit). When i checked the database actions , in the connection provider tab , there is no mysql provider available. Kindly advice how to make connection to mysql db to use the database actions.

Thanks for your help .

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hello @sureshvignesh

In my own experience, you can connect from PAD to MySQL data source with the steps below.

Install MySQL ODBC Driver (mysql-connector-odbc-8.0.25-winx64.msi).
Create "File DSN" using "ODBC Data Sources (64-bit)" app (odbcad32.exe).
Open PAD Flow Designer and set variable storing the connection strings.
Open SQL connection.
Execute SQL statement.
Close SQL connection.

Please refer screenshots below for more details.

#2 Create "File DSN" using "ODBC Data Sources (64-bit)" app (odbcad32.exe):

#3 Set variable storing the connection strings:

Provider=MSDASQL.1;Persist Security Info=True;Extended Properties="Driver=MySQL ODBC 8.0 Unicode Driver;SERVER=SERVER_NAME_OR_IP_ADDRESS;UID=USER_NAME;PWD=PASSWORD;DATABASE=DATABASE_NAME;PORT=3306"

#4 - 6 Entire flow image of Open SQL / Execute SQL / Close SQL:

Please try it.
Thank you.

Was this reply helpful? Yes No
yoko2020 495 on at

Like (0)

Report
Copy link

Link copied!
@sureshvignesh wrote:
Recently evaluating the power-automate desktop. I am trying to upload a excel data in MySQL db.
I am having the 'mysql-connector-odbc-8.0.21' connector (32 bit). When i checked the database actions , in the connection provider tab , there is no mysql provider available. Kindly advice how to make connection to mysql db to use the database actions.
Thanks for your help .

PAD is 64 bit, so you need to install 64 bit Mysql ODBC Driver.

Another sample of connection string that i use :
Driver={MySQL ODBC 8.0 UNICODE Driver};Server=%TestMySqlServer%;Database=%TestMySqlDatabaseName%;User=%TestMySqlUser%;Password=%TestMySqlPassword%;Connection Timeout=18000;Option=3;ENABLE_LOCAL_INFILE=1

Was this reply helpful? Yes No

Join the conversation