i wanted to connect the database that is mysql workbench please help me with the configuration
You can use activities from uipath.database.activities…buddy that you can download from manage packages from design tab
Where you have an activity called execute query and insert query activity… And for that you will be in need of username, password and servername buddy @manoj2500
Kindly try this and let know buddy
In packages you can download the uipath.database.activities & install.
Then database activities will be appeared use connect activity for connecting sql database
Were you able to connect buddy… @manoj2500
- select MIcrosoft SQL Server
- Then enter your servername, username and password and select the database name buddy
and here you can check the connection as well whether it got connected or not by clicking TEST connection button
- then you can enter the query as string here buddy within double quotes
Thats all buddy you are done
while setting up the connection i am getting error again and again i using workbench and the database is already connected to it.
the errors that i am facing is login is failed , path is not supported what should i do i am not good in db
Buddy were you able to connect to db and did you get the connection done first…
I am not getting the server name in the drop down so what should I do, and how to find out the server name in mysql workbench. Can you please help
can i have a view on your sql window if possible
I can’t send you the screenshots as it is against the company’s policy. So can you figure out what the problem will be
@Palaniyappan, Do I need to connect the database in mysql workbench and search for the server name in uipath connect activity
You need to use ODBC 32bit to connect mysql work bench as uipath is compatible with 32bit ODBC
Does this work the same for Google Bigquery?
Not sure need to try may I know the error that you are getting