Connecting MySQL though UI Path Studio Web - Mac OS

Help Activities
, ,
1

I have installed MySQL 9.2 in my Mac laptop. Created an automation project in the UI Path Studio Web. But the connection itself fails with the following issue:
Error: System.Data.Odbc.OdbcException: ERROR [IM002] [unixODBC][Driver Manager]Data source name not found and no default driver specified

Is it possible to connect UI Path Studio Web automation project to the local MySQL database?

Please help.

2

@John_Britto

as per error there is no service provided for it to connect

did you install the required drivers and configured them?

these are supported

The note informs users about the available database connection strings for configuring automation using Serverless Automation Cloud robots, listing options for PostgreSQL, SQL Server, MySQL, and Oracle. (Captioned by AI)
The note informs users about the available database connection strings for configuring automation using Serverless Automation Cloud robots, listing options for PostgreSQL, SQL Server, MySQL, and Oracle. (Captioned by AI)1014×354 25.9 KB

cheers

3

Hi @John_Britto

Does the same happen regardless of whether you use the cloud serverless runtime (which comes with the pre-installed drivers) or your local machine runtime?

4

I installed My SQL 9.2.0 in my local. Also, I am able to connect to MySQL databases using using terminal.
Also, I installed MySQL ODBC Connector version 9.2.0 too in my local.
I tried creating a DSN for the local MySQL database in my local. I am getting the below issue when I use the connection string with DSN name:
Error: System.Data.Odbc.OdbcException: ERROR [01000] [unixODBC][Driver Manager]Can't open lib 'MySQL ODBC 9.2 ANSI Driver' : file not found

5

I am using cloud run time. But, I am trying to connect local MySQL database. Installed the MySQL ODBC driver in my local.

A sequence showing the manual triggering of a database activities demo with successful and failed steps, including an unsuccessful attempt to connect to the database using an ODBC connection string. (Captioned by AI)
A sequence showing the manual triggering of a database activities demo with successful and failed steps, including an unsuccessful attempt to connect to the database using an ODBC connection string. (Captioned by AI)1316×1256 80.1 KB

6

I do have to mention that the cloud runtime will not have access to your local database because it runs your automation on a UiPath Serverless runtime unit on our Cloud.

The way to test this from Studio Web would be by using the “On local machine” option:

image
image270×114 5.17 KB

The process would then be tested via UiPath Assistant on your local machine instead of Cloud.

7

Thank you so much. I will try using “On local machine option” and let you know the result. Thanks.

Any way to setup MySQL database as a service in the UI Path cloud environment? Can we connect from UI Path Web to a Relational Database Service such as Amazon RDS? Please clarify.

8

Hi @John_Britto,

We have recently learned about the difficulties in being able to properly install the MySQL ODBC driver on the macOS system.

As a workaround, I tested and our UiPath Serverless runtime could be a valid solution. It has the following drivers installed on the default image:

  • MySQL ODBC 8.3 ANSI Driver
  • MySQL ODBC 8.3 Unicode Driver

I was able to connect to my MySQL database with the following connection string:

Driver={MySQL ODBC 8.3 Unicode Driver};database=information_schema;db=information_schema;no_schema=1;pwd={mypassword};port=9999;password={myPassword};server={myServerUrl};uid=myUsername;user=myUsername;multi_host=1

We continue to investigate the exact steps to be taken to properly install the MySQL ODBC driver on macOS to allow the activity to work locally as well. We will update the documentation once the steps are clarified.