Connect To Database
Last updated
Last updated
This action can be used to Connect to a database, either it being local or external
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: The name of the database which will be used to perform all the queries.
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;
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.
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.
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.
