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.

Note: The Connection String overrides all other settings in the Connection panel.

If you want to use the previous settings, the Connection String must be empty.

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

Note: This object must have the Variable Type set to DatabaseConnetion.

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.