Help Centre › Building Processes
This article describes the RPA Database functionality to close a database connection.
For a full list of available functions, please read DATABASE functions.
Description
The Disconnect from database function closes a named database connection. If no name is provided, all open connections are closed. Always disconnect when database operations are complete to free server resources.
Setting it up
To use the Disconnect from database function, follow these instructions:
{{popups:rpas/add:action=db-disconnect}}
Once on a process map:
- Navigate to the process where you would like to add the Disconnect from database function
- Click on the green button's drop-down (right side of the green button labelled "Process")
- On the menu that appears, click on the "+ Activity" item
- From here you can select the Disconnect from database option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Name | No | Text | - | The alias of the connection to close. If omitted, all open connections are closed |
Output variables
This action does not produce output variables.
Errors
| Error | Description |
|---|---|
| Connection not found | No open connection exists with the specified name |
Tips
- Always disconnect from the database when your operations are complete to free server resources
- Omit the name parameter to close all open connections at once, which is useful at the end of a process