SQL Connections

Description

Allows a user to create/configure a SQL connection for use on any connected Agent. A SQL connection is a string that contains the information needed to access a database. Once configured, the pre-defined SQL connection can be called from any Open SQL Connection step of any task.

To access SQL Connections settings, from Server Management Console (SMC), select Options > Server Settings > SQL Connections.

Related Topics

Parameters

The following table displays available preferences as they appear in the SMC's SQL Connection settings.

Property Description
Name The user defined name of the SQL connection. This value corresponds to the Session Name parameter found in the properties of the Open SQL Connection action.
Value The connection string to set as the pre-defined SQL connection. Click the Build button to open the Data Link Properties dialog allowing you to build a proper connection.
Comment A user-defined comment describing the SQL connection. Entering a comment is optional.
Enabled Specifies whether the connection is enabled or disabled (all new connections are enabled by default).

To Create a Pre-defined SQL Connection

  1. Click the New button.

  2. In the Name parameter, enter the desired name for the SQL connection.

  3. In the Value field, click the Build button that appears. This opens a standard Data Link Properties dialog windows for configuring connection strings to data sources. For more details, see Data Link Properties.

  4. After building and testing the SQL connection, you can optionally enter a description for it in the Comments parameter. All changes are saved automatically.

To Remove an Existing SQL Connection

  1. Highlight the connection you wish to remove.

  2. Click the Remove button.

To Modify the Properties of an Existing Connection

  1. Highlight the connection you wish to modify.

  2. Click the Modify button and make the appropriate changes.