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. |
---|---|
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:
|
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 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. |