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.

Last updated