Product Documentation

User DSN

Mar 27, 2018

Controls the creation of user DSNs.  

User DSN list

A list of your existing user DSNs. You can use Find to filter the list by name or ID against a text string.

To add a user DSN:

  1. Use the context menu Add command.
  2. Enter details in the New User DSN dialog tabs, then click OK.

Tab

Controls

General

Name. The display name of the user DSN, as it appears in the user DSN list.

Description. This field is only shown in the edition/creation wizard and allows you to specify additional information about the resource.

User DSN State. Toggles whether the user DSN is enabled or disabled. When disabled, it will not be processed by the agent even if assigned to a user.

DSN Name. The functional name of the user DSN.

Driver. The DSN driver. At present, only SQL server DSNs are supported.

Server Name. The name of the SQL server to which the user DSN is connecting.

Database Name. The name of the SQL database to which the user DSN is connecting.

Options

Connect Using Specific Credentials. Allows you to specify credentials with which to connect to the server/database.

Run Once. By default, Workspace Environment Management will create a user DSN every time the agent refreshes. Tick this box to make Workspace Environment Management only create the user DSN once, rather than at every refresh. This speeds up the agent refresh process, especially if you have many DSNs assigned to your users.

Action Type. Describes what type of action this resource is.