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.