Is it possible to connect to mysql database using uipath? If yes? How to connect to MySQL Database?

I have my existing database in created in mysql. I searched for various solutions for my problem, but it seems like there is no option to connect to mysql. All the solutions what I got were to connect to microsoft sql server or oracle.
Please provide a detail solution about it. If possible .xaml file will be helpful. Also, if need to install any other third party application, please provide link for that too.
Thanks in advance

yes, we can connect with oracle database after installing Oracle client version 8.0.17 and above

while connecting define TNS settings in connecting string and provider name is oracle client

I install Oracle Client and database connection got successfull from ODBC. But I’m unable to connect through UiPath yet.

Also, Here Oracle MySql Option is not displaying.

Check if this site help. I will try and will post it later.

https://www.connectionstrings.com/mysql/

Already tried this solution, same error… Waiting for more detailed answer.

No need to select connection wizard there, choose option from lat dropdown

make sure TNS settings should be saved in the oracle folder

This thread will help you.

https://forum.uipath.com/t/how-to-connect-my-flowchart-to-mysql-database/6110/9

First install the MySQL-ODBC connector from here

Make sure you download the 32 bit version as it seems UiPath is compatible with 32bit driver version. After that follow the thread.

3 Likes

I’m having problem connecting. Can anyone post any link where I can get the steps of how to do it?

Hello,

fr MySql connection,
inside Connect node you can simply pass the connection string is enough. It will automatically gets updated

“server=‘10.100.X.XX’; UID=‘UiPath’; PASSWORD=’******’; DATABASE=‘UiPath’; PORT=‘3306’;”

for example i have attached a smple flow, edit it accordingly to your db server.MySQL_Test.xaml (5.6 KB)

Thanks,
Meg

1 Like

yes u can connect my sql with uipath but connection method is bit different first you have to install mysql connector into your system from which your willing to connect your database,
then you have to create the odbc connection from control pannel > administrative tools > odbc connection.

3 Likes

Hey ,
You need to connect the database with UiPath using Mysql Odbc Connector.
Then you can connect UiPath with MySQL.

Regard’s,
Suruchi

Use connect activity. Under properties Use provider name as MySql.Data.MySqlClient. Set your connection string “Server=127.0.0.1;Database=xxx;Uid=xxxx;Pwd=xxx”. Thats it
cheers

Can you tell me in more detail about setting up the odbc connection

Thank you

1 Like

1 - very first you have to check version of MySQL server.
2- You have to download and install the mysql connector according to the version and how many bit (32bit/64bit) set of my sql u have install.
3- then you have to create odbc connection string into your system. for that follow below step

  • Open control panel then go to Administrative Tools then select ODBC data source Administrator according to setup u have install it is better if you install 32 bit.

  • In ODBC data source Administrator Tools Go to System DNS

    Capture

  • under Syetem DNS Tab Click on Add Button. once you click on add you will get he below screen.

Capture

  • if you have install the MySQL connector then it will appear in the list. now click on MSSQL ODBC 8.0 ANSI Driver (Version may change)

  • once you click on MSSQL ODBC 8.0 ANSI Driver below screen will appear.

Capture

  • In above screen Enter Data Source Name as per Your conviniace; Then enter IP Address/ MYSQL Pipe name which you have created while installing MySQL server

  • type userName and password which you are using to login into mysql and select the database schema which you want to use in your process.

  • once create the connection it will appear under system DNS and ready to use in uipath.

Capture

  • open your uipath studio drag connection activity.

  • Click On Configure Connection

Capture

  • Click On Connection Wizard

Capture

  • After Clicking of connection Wizard new window will appear with title having choose data Source in that window select Microsoft ODBC data Source click on Ok Button.

Capture

  • Now in connection property window under use user or system data source name select connection that we have created and click on ok.

Capture

5 Likes

for me RPA in datasoure is not showing, i haave done the same wy what u did

sir am already download what is the server name should i give