Database connection

Help
,
1

Hi everyone,

Can somebody help me in connecting my sql database to uipath. i hvae gone through the forum buit i am not able to understand how it can be connected.
Only information which i gathered from internet for mysql is the connection string
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
i dont know what is myserver address and how can i find it.
Can somebody help me please.

2

you can connect sql with two ways

  1. Using windows authentication in this case you should know sql server name and name of Database (from which you are trying pull data)
  2. Using SQL authentication where you need sql server username and password, sql server name.

my preference is using windows authentication …! :slight_smile:

1 Like
3

Thank you so much.
Now i am able to connect with database just wanna ask you one small thing when i am quering and extracting data from mysql database its fetching around 1200 data and my system is getting hanged for some time any specific reason or anything i can do to stop this.

4

You must disconnect the database once your task done with db…I hope you are following same.

5

Hi RJ_Kadari,

I am not able to find some useful link to about how to connect “Using windows authentication in this case you should know sql server name and name of Database” .

Can you please help me how to connect to MySql using Windows authentication…

Thanks
Shantanu.

6

please refer this Connect to data base

7

Thanks
I tried using the solution but still i am getting same error

“Data Source=localhost;Initial Catalog=db;User ID=root;Password=root”

error
error1366Ă—768 75 KB

8

it is asking to import newtnsoft json, could you please try to import in from studio ?

9

how to close the connection ? or is it closed automatically??

10

@feda_safeen disconnect activity in database

11

Do we need to have SQL db interface to be installed in our machine for executing this activity?

12

Hi,
I am not getting the server name in the dropdown so what should I do, and how to find the server name in mysql workbench. Any help would be appreciated.

13

@Ejaz44

You will only be able to see a server/list of servers in drop-down to the one’s which you would be having access to, if not you will not be able to see the server names in drop-down

Thanks
Aman

14

Can u elaborate the techniques to see server name in drop down

15

hi,can you please help me, why we need sql database in uipath, if any chance use another database instead of sql database

16

we dont have dependent softwares to be installed, uipath will take care