Policy Server Guides › Policy Design Guide › User Directories › Configure User Directory Connections › Configure ODBC Directory Connections

Configure ODBC Directory Connections

You can use the User Directory Dialog to configure a connection to your ODBC user directory.

Note: When you create or modify a Policy Server object in the Policy Server User Interface, use ASCII characters. Object creation or modification with non-ASCII characters is not supported.

Note: If you are using a SQL database for audit logs and caching is turned on (see the Policy Server Management Console chapter in the SiteMinder Policy Server Management Guide), under heavy load, SiteMinder performance may suffer as the Policy Server queues messages to be logged. To alleviate this situation, turn on asynchronous auditing for the realms associated with the resources being accessed by a high volume of users.

To configure an ODBC user directory connection

1. Open the User Directory Dialog.
2. In the Directory Setup tab, select ODBC from the Namespace drop-down list.
3. In the Directory Setup tab, enter connection information for your ODBC database directory.

   One of the required fields in the Directory Setup tab, is the SQL Query Scheme field.

4. To configure the directory connection to include multiple servers for failover, click the Configure button in the Directory Setup group box.
5. Optionally, in the Credentials and Connection tab, specify administrator credentials that the Policy Server will use to connect to the ODBC database.

   The name you enter in the Username field must be the name of the user who owns the tables containing user directory data. For example, if you are using the SmSampleUsers schema, this user must be the owner of the SmUser, SmUserGroup and SmGroup tables.

   Note: This administrator account must have read or read/write privileges for the user directory based on the features of SiteMinder included in your implementation.

6. Optionally, in the User Attributes tab, specify directory attributes that will be reserved for use by SiteMinder features.

More information:

Configure a Realm

Grouping Resources in Realms

Navigate to the User Directory Dialog

User Directory Dialog—ODBC Namespace—Directory Setup Tab

Configure SQL Query Schemes

Load Balancing/Failover Configuration for LDAP Directory Connections

User Directory Dialog—ODBC Namespace—Credentials and Connection Tab

Specify Directory Attributes