The SQL Connections tab allows you to create user defined SQL connection strings which can be called upon in AutoMate actions that require a SQL connection.
User defined SQL Connections
Shows a list of user defined SQL connections. The list contains three columns:
Specifies the name of the SQL connection. This is how the SQL connection is referred to in AutoMate tasks and scripts.
Specifies the SQL connection string.
A description for the SQL connection. This is used only in the User Defined SQL Connections view as reference and has no bearing on the SQL connection itself.
There are three available buttons to select from which allows the following actions to be performed:
Click this button to add a new user defined SQL connection.
Click this button to modify an existing SQL connection.
Click this button to remove an existing SQL connection.
When the Add or Modify button is selected, the dialog box shown below appears with the following parameters:
SQL connection name:
Allows entery of a specific name of the SQL connection. The name entered for the SQL connection can then be referred to in AutoMate tasks and scripts.
SQL connection value:
Allows entery of a specific SQL connection string.
SQL connection comment (optional):
Allows entry of a description for the SQL connection. This is used only in the User Defined SQL Connections view as reference and has no bearing on the SQL connection itself.
Allows the option to enable or disable the current SQL connection string (enabled by default).
Setting SQL Connections