| Panel | |
|---|---|
|
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.
| Anchor | ||||
|---|---|---|---|---|
|
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 |
| Note | ||
|---|---|---|
| ||
To open an existing record on the list, either:
|
| Anchor | ||||
|---|---|---|---|---|
|
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.
| Anchor | ||||
|---|---|---|---|---|
|
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 |
| ||||||||||||
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 |
| ||||||||||||
Member of Business Services |
| ||||||||||||
Database Type |
| ||||||||||||
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 |
| ||||||||||||
Driver |
| ||||||||||||
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 |
| ||||||||||||
|
| ||||||||||||
Copy | Creates a copy of this Database Connection, which you are prompted to rename. | ||||||||||||
Delete |
| ||||||||||||
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. | ||||||||||||
|
|