cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sureshvignesh
Frequent Visitor

Powerautomate desktop mysql db connection

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 .

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Hello @sureshvignesh 

 

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

 

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

 

Please refer screenshots below for more details.

 

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

 

shindomo_0-1634031745943.png

 

shindomo_1-1634031809542.png

 

#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"

 

shindomo_3-1634032287089.png

 

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

 

shindomo_4-1634032605921.png

 

Please try it.

Thank you.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hello @sureshvignesh 

 

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

 

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

 

Please refer screenshots below for more details.

 

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

 

shindomo_0-1634031745943.png

 

shindomo_1-1634031809542.png

 

#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"

 

shindomo_3-1634032287089.png

 

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

 

shindomo_4-1634032605921.png

 

Please try it.

Thank you.

yoko2020
Responsive Resident
Responsive Resident


@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

 

 

 

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Top Kudoed Authors
Users online (1,764)