How to connect to a database from UiPath and read data from it

0 votes
How to connect to a database from UiPath and read data from it?
Oct 16, 2019 in RPA by Pratibha
• 3,690 points
9,593 views

1 answer to this question.

0 votes

Hi Pratibha, to connect to a database in UiPath Studio follow these steps:

  1. You first need to have Database activities package installed. You can install this package using Package Manager. 

  2. Now,  you can use “Connect” activity to set up a connection between UiPath studio and Database.

  3. Next, click "Configure Connection" button to configure the connection.

  4. Select required connection settings and do Test Connection. On successful test connection, click OK.

  5. Once the connection is established, use "Execute Query" activity to write your required sql query to read data.

answered Oct 17, 2019 by Abha
• 28,140 points

Related Questions In RPA

+3 votes
1 answer

How to extract data from a website and save it to excel using UiPath?

Hi Piyush, if you want to extract ...READ MORE

answered Mar 8, 2019 in RPA by Anvi
• 14,150 points
22,522 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Robot Manager in UiPath

the robot.exe file is located in: C:\Users\USER_ACCOUNT\AppData\Local\UiPath\app-17.1.6523\Ui-Robot.exe Hope it ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
1,900 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
1,618 views
0 votes
1 answer

UiPath vs Workfusion

in WorkFusion, you can create a script ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
2,759 views
0 votes
3 answers

Any open source tools for RPA ?

Yes, here is the Free RPA tool ...READ MORE

answered Oct 24, 2018 in RPA by Karthiksiddhu
• 240 points
1,890 views
0 votes
1 answer

How to read data from a excel, based on that data, check in the corresponding checkbox in browser appln? Uipath

Hi, to achieve this, you can perform ...READ MORE

answered Oct 10, 2019 in RPA by Abha
• 28,140 points
2,906 views
+2 votes
1 answer

How to extract data from website and save it to excel using Blue Prism?

Hey, you can use following steps to ...READ MORE

answered Aug 19, 2019 in RPA by Abha
• 28,140 points
6,873 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP