Connect To Database
This action can be used to Connect to a database, either it being local or external
Properties

Connection

SQL Driver: to which will be used to connect to the SQL Server;
SQL Server Address: The SQL Server host address, to which the connection will be made;
Port: The port of the SQL host (default port for Microsoft SQL Server 2019 is 1433);
SQL Server Name: The SQL Server name;
Connection String: The Connection String that will be used to connect to the SQL Server.
Database

Database: The name of the database which will be used to perform all the queries.
Authentification

Method: The authentification method which will be used to connect to the SQL Server (Server Authentification or Windows Authentification);
Username: The username which will be used to connect to the SQL Server;
Password: The password which will be used to connect to the SQL Server;
Output

Database Connection: The DatabaseConnection object which will be used to interract with the SQL Server
Misc

Display Name: action display name in your implementation project.
Wait Before: number milliseconds robot to wait before executing the action.
Wait After: number milliseconds robot to wait until moving to the next action.
Abort on Error: True/False.
Retry Times: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.
Use Case
Potential Use Cases
Connect to a database directly to bypass forms that cannot be automated through regular means.
Connect to a database for easier handling & retrieval of data.
Last updated
Was this helpful?