How to retrieve data from a database in UiPath.
By using DataBase activities,
How to retrieve data from a database in UiPath.
-Using the Execute Query activity to execute SELECT queries. After executing the query,
you can use activities like For Each Row to iterate over the result set and process each row of data retrieved from the database.
1 Like
First you have to install the UiPath.Database.activties in the manage packages to use the Database activities.
→ Use the connect to database activity to connect to the database first.
→ Then use the execute query activity to run the query in database to get the required data from it. The output is datatable.
→ Then use the disconnect to database activity to disconnect from database.
The execute query activity is used to retrieve the data from the database.
Hope it helps!!
Check the below video for your reference,
Hope it helps!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.