Question

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

Answer 1

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.