Workflow Manager 2014
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 opening the Administration group in the navigation bar and clicking External Data Sources in the Environment Settings subgroup.
On the External Data Sources Administration page, you can:
| • | Update or delete a database connection—Drill through to a page showing the details of a single database connection, where you may either update or delete that connection. See Viewing or Changing an Existing Data Source Connection and Deleting a Data Source Connection. |
| • | Create a new database connection—Create a new connection to a database. See Creating a New 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 DB-Driven 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 Properties view when defining DB Driven Type Data Element. |
|
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
Managing External Data Sources
Deleting a Data Source Connection
Workflow Manager 2014 Help LibrarySeptember 23, 2014 |
Copyright Information | Contact Us |