My webMethods Server 10.7 | My webMethods Server Webhelp | Administering My webMethods Server | My webMethods Administrator Functions | Managing My webMethods Configuration | Managing External Directory Services | Configuring an External Database Directory Service
 
Configuring an External Database Directory Service
Use the following procedure to configure My webMethods Server to use an external database directory service.
Note:
To use a database directory service, you must first connect to the database as an external data source. For more information, see Managing External Data Sources.
*To configure an external database directory service
1. To navigate to the correct page, do one of the following:
*In My webMethods: Navigate > Applications > Administration > My webMethods > Directory Services > Create New Directory Service.
*As system administrator: Administration > User Management > Directory Services Administration > Create New Directory Service.
2. In Directory Type field, click Database:
3. Click Next.
4. On the Create Database Directory Service page, specify:
The following table lists the properties, required to configure an external database directory service:
Section
Property
Description
General
Name
Required. A name to identify the external database directory service. My webMethods Server uses this name when it needs to identify the external database directory service in the user interface
Description
Optional. A descriptive comment about the external database directory service.
Attributes
User ID
Required. The name of the query field containing the user ID value.
User DN
Required. The name of the query field containing the distinguished name value for the user.
User First Name
Required. The name of the query field containing the user first name.
User Last Name
Required. The name of the query field containing the user last name.
User Full Name
Optional. The name of the query field containing the user full name. If you do not supply an attribute, the full name is derived from the User First Name and User Last Name attributes.
User E-mail
Optional. The name of the query field containing the user email address.
User Disabled
Optional. The name of an attribute in the external directory service that identifies a user as being disabled.
User Disabled Value Regex
Optional. A regular expression used to evaluate the User Disabled attribute for the external directory service.
Group ID
Required. The name of the query field containing the group ID value.
Group DN
Required. The name of the query field containing the distinguished name value for the user.
Group Name
Required. The name of the query field containing the group name.
Group E-mail
Optional. The name of the query field containing the group email address.
Configuration
Authentication Handler
Required. The page that handles authentication for the database. By default, My webMethods Server provides a clear-text authentication handler.
Database
Datasource
Required. The database to be used as a data store. For a database to appear in the list, you must first use the DataSource Administration page to connect to the external database.
Query Lookup User by ID
Required. A SQL query that returns a user record based on the user ID.
This query must return all user attributes, as described under Attributes in this table.
Query Authenticate
Required. A SQL query that returns persisted user credentials for authentication.
Various queries
Optional. You can define several additional SQL queries, as needed. Sample language is provided for each type of query.
Cache
Cache Enabled
Required. Determines whether My webMethods Server will attempt to save the load on the database by using cached data whenever possible. Select:
*Yes to enable caching
*No to disable caching
Cache Capacity
Required. The number of database queries you want to cache. The default is 1000.
Cache Timeout
Required. The length of time that queries should remain in the cache unless the cache capacity is exceeded. The default is 1 day.
5. At the bottom of the page, click Finish.
Tip:
To test your configuration to ensure you have correctly configured the external directory service, perform a query to search for users or groups that are defined in the external directory service. For instructions on how to perform a query, see Searching for Existing Users, Groups, or Roles.