Overview

Database Connections provide all database server information required for Universal Controller to execute an SQL task or a Stored Procedure Task.

Database Connections can receive Email Notifications when:

An Agent or OMS Server goes down or comes back up.
A Cluster Node goes Offline or becomes Active.

Creating a Database Connection

Step 1	From the Agents & Connections navigation pane, select System > Database Connections. The Database Connections list displays. Below the list, Database Connection Details for a new Database Connection displays.
Step 2	Enter / select Details for a new Database Connection, using the field descriptions below as a guide. To display more of the Details fields on the screen, you can either: Use the scroll bar. Temporarily hide the list above the Details. Click the New button above the list to display a pop-up version of the Details.
Step 3	Click a Save button. The Database Connection is added to the database, and all buttons and tabs in the Database Connection Details are enabled.

Note

To open an existing record on the list, either:

Click a record in the list to display its record Details below the list. (To clear record Details below the list, click the New button that displays above and below the Details.)
Clicking the Details icon next to a record name in the list, or right-click a record in the list and then click Open in the Action menu that displays, to display a pop-up version of the record Details.
Right-click a record in the a list, or open a record and right-click in the record Details, and then click Open In Tab in the Action menu that displays, to display the record Details under a new tab on the record list page (see Record Details as Tabs).

Database Connection Details

The following Database Connection Details is for an existing Database Connection. See the field descriptions, below, for a description of all fields that display in the Database Connection Details.

For information on how to access additional details - such as Metadata and complete database Details - for Database Connections (or any type of record), see Records.

Database Connection Details Field Descriptions

The following table describes the fields, buttons, and tabs that display in the Database Connection Details.

Field Name	Description
Details	This section contains detailed information about the Database Connection.
Name	Unable to render {include} The included page could not be found.
Version	System-supplied; version number of the current record, which is incremented by the Controller every time a user updates a record. Click the Database Connections#Versions tab to view previous versions. For details, see Record Versioning.
Description	Unable to render {include} The included page could not be found.
Member of Business Services	Unable to render {include} The included page could not be found.
Database Type	Unable to render {include} The included page could not be found.
Credentials	Credentials for this Database Connection. Click the Details icon to create a new Credentials record, or select an existing Credentials record from the drop-down list.
Connection URL	Unable to render {include} The included page could not be found.
Driver	Unable to render {include} The included page could not be found.
Maximum Rows	If necessary, specifies a limit to the number of rows you want returned by the SQL statement.
Metadata	This section contains Metadata information about this record.
UUID	Universally Unique Identifier of this record.
Updated By	Name of the user that last updated this record.
Updated	Date and time that this record was last updated.
Created By	Name of the user that created this record.
Created	Date and time that this record was created.
Buttons	This section identifies the buttons displayed above and below the Database Connection Details that let you perform various actions.
Save	Saves a new Database Connection record in the Controller database.
Save & New	Saves a new record in the Controller database and redisplays empty Details so that you can create another new record.
Save & View	Saves a new record in the Controller database and continues to display that record.
New	Displays empty (except for default values) Details for creating a new record.
Update	Unable to render {include} The included page could not be found.
Test Connection	Unable to render {include} The included page could not be found.
Copy	Creates a copy of this Database Connection, which you are prompted to rename.
Delete	Unable to render {include} The included page could not be found.
Refresh	Refreshes any dynamic data displayed in the Details.
Close	For pop-up view only; closes the pop-up view of this Database Connection.
Tabs	This section identifies the tabs across the top of the Database Connection Details that provide access to additional information about the Database Connection.
SQL Tasks	Lists all SQL tasks that are using this Database Connection.
Stored Procedure Tasks	Lists all Stored Procedure tasks that are using this Database Connection.
Versions	Unable to render {include} The included page could not be found.