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. |