How to connect mysql workbench using connect activity

Help
,
1

i wanted to connect the database that is mysql workbench please help me with the configuration

2

Buddy
@manoj2500

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

Cheers
Kindly try this and let know buddy

1 Like
3

Hi @manoj2500,

In packages you can download the uipath.database.activities & install.
Then database activities will be appeared use connect activity for connecting sql database

4

Were you able to connect buddy… @manoj2500

5

what should i need to select from menu options for mysql workbench

Untitled
Untitled1600Ă—900 115 KB

6

Buddy @manoj2500

  1. select MIcrosoft SQL Server
    image
    image813Ă—403 18.1 KB
  2. 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
    image
    image795Ă—555 21.5 KB
  3. then you can enter the query as string here buddy within double quotes
    image

Thats all buddy you are done
Cheers @manoj2500

7

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

1 Like
8

No worries
Buddy were you able to connect to db and did you get the connection done first…
@manoj2500

9

Hi @Palaniyappan,
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

10

can i have a view on your sql window if possible
Cheers @Ejaz44

11

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

12

@Palaniyappan, Do I need to connect the database in mysql workbench and search for the server name in uipath connect activity

13

You need to use ODBC 32bit to connect mysql work bench as uipath is compatible with 32bit ODBC

14

Does this work the same for Google Bigquery?

15

Not sure need to try may I know the error that you are getting

16

Team,

If you are still not able to connect to mysql workbench you can follow this screenshot as i am able to connect to DB by these settings,

11
111907Ă—583 40.6 KB

If still not able to connect can reach out to me.

Regards,
DGKUMAR