Previous Topic: SQL Query Schemes

Next Topic: Add SQL Query Schemes to ODBC User Directory Connections

Configure a SQL Query Scheme

You can configure a SQL Query Scheme that finds user data in the relational database that you are using as a user store.

Note: The following procedure assumes you are creating a new object. You can also copy the properties of an existing object to create an object. More information exists in Duplicate Policy Server Objects.

To configure a SQL Query Scheme

  1. Click Infrastructure, Directory.
  2. Click SQL Query Scheme, Create SQL Query Scheme.

    The Create SQL Query Scheme pane opens.

  3. Verify that Create a new object is selected, and click OK.

    The SQL Query Scheme: Name pane opens.

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

  4. Type a name and description in the fields on the General group box.
  5. Update the contents of the query fields to correspond to your database schema.

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

    You must configure each of the queries to work with your relational database. You must replace the following database table and column names with the table and column names from your relational database:

  6. Select a query type, and click Submit.

    The query is saved. You can associate query scheme with a user directory connection

  7. Restart the Policy Server using the Policy Server Management Console.

More information:

Configure ODBC Directory Connections


Copyright © 2010 CA. All rights reserved. Email CA about this topic