Uipath connection to MySQL

Question

Has anyone ever connected to a MySQL remote server using uipath? Is this possible? I've tried using the standard activities but am unable. I understand that I may need to install the odbc driver, then create a connection. Is it possible to then send SQL from uipath to the linked server?

Answer 1

Following the steps mentioned below should solve your issue:

• install MySQL
• Install Mysql odbc driver
• create USER DSN
• While creating connection use the ODBC DATA SOURCE option
• In the next window select the DSN created in the third step under system or user Data source name