To connect the database to UiPath, follow the instructions below.
You must first install the Database activities package. The Package Manager can be used to install this package.
You may now utilize the "Connect" activity to establish a link between UiPath studio and the database.
Then, to configure the connection, click the “Configure Connection” button.
Select the necessary connection settings and perform a connection test. When the test connection is successful, click OK.
Use the "Execute Query" activity to write your required SQL query to read data once the connection has been created.