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

Help
15

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

11 Likes