SQL Connections

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.

Parameters

 

User defined SQL Connections

Shows a list of user defined SQL connections. The list contains three columns:

 

Name

Specifies the name of the SQL connection. This is how the SQL connection is referred to in AutoMate tasks and scripts.

 

Value

Specifies the SQL connection string.  

 

Comment

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.

 

 

Available Buttons

There are three available buttons to select from which allows the following actions to be performed:

 

Add

Click this button to add a new user defined SQL connection.

 

Modify

Click this button to modify an existing SQL connection.

 

Remove

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.

 

Enable

Allows the option to enable or disable the current SQL connection string (enabled by default).

 

See Also

Setting SQL Connections