My webMethods Server 10.1 | My webMethods Server Webhelp | Document Conventions | 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. Fill in the appropriate form fields for the database directory service. You should be prepared to provide the following information:
Section
Property
Description
General
Name
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
The name of the query field containing the user ID value.
User DN
The name of the query field containing the distinguished name value for the user.
User First Name
The name of the query field containing the user first name.
User Last Name
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
The name of the query field containing the group ID value.
Group DN
The name of the query field containing the distinguished name value for the user.
Group Name
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
The page that handles authentication for the database. By default, My webMethods Server provides a clear-text authentication handler.
Database
Datasource
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
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
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
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
The number of database queries you want to cache. The default is 1000.
Cache Timeout
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.