Workflow Manager 2019
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 SQL Server or Oracle database.
You enter the connection information for a data source connection on the Add/Edit External Data Source page, which is opened by clicking Add on the External Data Sources Administration page.
On the Add/Edit External Data Source page, you can also view and update the details of an existing external data source connection and can remove an existing connection which is no longer required.
Note • To populate a single-selection list with data from an external data source, first you have to define an external data source connection, as described in Creating a New Data Source Connection, and then you have to 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. For more information, see About External Data Sources.
The following options are available on the Add/Edit External Data Source page:
|
Option |
Description |
|
Database type |
Select the type of database you are connecting to: SQL Server or Oracle. |
|
Datasource name |
Enter a user-friendly name to identify this data source within Workflow Manager. Note • This name will be listed in the External Data Source List on the Data Element Details view when defining DB Driven Type Data Element. |
|
Server |
For SQL Server, enter the name or IP address of the database server you want to connect to. For Oracle, enter the local Net Service name. |
|
Username |
Enter the account name that will be used to connect to your database. |
|
Password |
Enter the password associated with the account name you want to use to connect to the database. |
|
Database name |
(SQL Server only) Enter the name of the database on the database server that you want to connect to. |
See Also
Managing External Data Sources
Creating a New Data Source Connection
Workflow Manager 2019 Help LibraryAugust 2019 |
Copyright Information | Flexera |