External Data Sources Administration Page
Workflow Manager 2020
The External Data Sources Administration page lists the connections defined in Workflow Manager to external Oracle or SQL Server databases. You can view this page by clicking External Data Sources in the Settings menu of the navigation bar.
External Data Sources Administration Page
On the External Data Sources Administration page, you can create a new database connection or update or delete an existing database connection.
| • | Creating a New Data Source Connection |
| • | Viewing or Changing an Existing Data Source Connection |
| • | Deleting a Data Source Connection |
If you define a connection to an external data source, you can choose to populate a single-selection list displayed on a request with real time data values obtained from an associated database. To populate a single-selection list with data from an external data source, you have to:
| • | Define an external data source, as explained in Creating a New Data Source Connection. |
| • | Create a data element with a data type of DBDriven Type, as explained in the DB Driven Type portion of the Defining Data Elements procedure. |
Note:For more information, see About External Data Sources.
The External Data Sources Administration page displays the following database connection details:
|
Option |
Description |
|
Name |
A short description of the database connection. Note:This name is listed in the External Data Source list on the Data Element Details view of the Data Groups tab when defining DBDriven Type data element on the Template Details page |
|
Server |
For SQL Server, the name or IP address of the server hosting the database. For Oracle, the local Net Service name. |
|
User name |
The account name that should be used to connect to the database. |
|
Database name |
The name of the database on the database server which you are connecting to. |
|
Database type |
The type of database, either SQL Server or Oracle. |
See Also