Policy Server Guides › Policy Server Configuration Guide › Administrative User Interface Management › SiteMinder Administrators › How to Configure an External Administrator Store › Configure an RDB Administrator Store Connection

Configure an RDB Administrator Store Connection

Configure the connection to change the source of administrator identities from the policy store to the external store.

To configure the external store connection

1. Click Administration, Admin UI, Configure Administrative Authentication.
   • If you are configuring an external administrator store for the first–time, the Configure Administrative Authentication wizard appears.
   • If the Administrative UI is configured with an external administrator store, the connection details appear. Click OK to start the Configure Administrative Authentication wizard.

   Note: Click Help for descriptions of settings and controls, including their respective requirements and limits.

2. Select one of the following from the Directory type list:
   • If your user schema includes a column that identifies the full–name of users, select the following template:

     Relational Database (with full name column)

   • If the full–name of users must be calculated, select the following template:

     Relational Database (without full name column)

3. Click Next.

   The wizard prompts you to select a data source.

   Note: If data sources do not appear, click Cancel and deploy a JDBC data source to the application server. You cannot create the connection without a deployed data source.

4. Select the data source and click Next.

   The wizard prompts you to select the user table that contains the SiteMinder administrators.

5. Select the user table and click Next.

   The wizard prompts you to specify the individual attributes required to map to your administrative users. The lists populate with the column names in the database that are likely to identify each attribute.

6. Do one of the following:
   • If you selected the Relational Database template, select the column name that maps to each of the required user attributes and click Next.

     The wizard prompts you to search for a user.

   • If you selected the Relation Database (no full name) template:
     1. Select the column name that maps to each of the required user attributes.
     2. Build the Get Full Name Query by replacing ##FIRST_NAME, ##LAST_NAME, and ##PRIMARY_KEY with the column name that maps to the respective user attribute.

        Note: Leave the question mark (?) at the end of the query.

        Example: select SmUser.FirstName + ' ' + SmUser.LastName from SmUser where SmUser.UserID = ?

     3. Click Next

     The wizard prompts you to search for a user.

7. Enter all or part of the user name in the User Keywords field.

   Users matching the search criteria appear in the Search Results group box.

8. Select a user and click Next.

   Note: The user you select becomes the super user when the connection is configured.

   A summary screen appears.

9. Confirm the connection details and click Finish.

   The connection to the external store is configured.