Add/Edit External Data Source Page
Workflow Manager 2020
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. To connect the Oracle database, it is required to install Oracle client on Workflow Manager server. For example: WFM = (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = wfm) ) ) |
|
Authentication |
Select the type of Authentication: SQL Server Authentication or Windows Authentication. Note:If you select Windows Authentication, the Datasource connection will be established without explicitly providing the Username and Password for the Database. While connecting External data source with Windows Authentication. Make sure that the Web server App pool is running under the account which has access to the target database.
|
|
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. Note:This field will appear only when you select the SQL Server Authentication. |
|
Password |
Enter the password associated with the account name you want to use to connect to the database. Note:This field will appear only when you select SQL Server Authentication. |
|
Database name |
Enter the name of the database on the database server that you want to connect to. |
See Also