CA Identity Manager Configuration Guide › Relational Database Management › Connection to the User Directory › SQL Query Schemes › How to Define Custom Query Schemes

How to Define Custom Query Schemes

Query schemes are defined in CA SiteMinder®Query elements in the directory configuration file. A CA SiteMinder®Query element resembles the following:

<SiteMinderQuery name="SetUserProperty" query="update tblUsers set %s = &apos;%s&apos; where loginid = &apos;%s&apos;" />

Note: In the sample query, ' is the XML syntax for the single quote (’).

The CA SiteMinder®Query element only applies when CA Identity Manager integrates with CA SiteMinder®.

The query scheme parameters are as follows:

name

Specifies the redefined name of a CA SiteMinder® query scheme.

Do not modify this value.

query

Specifies the SQL statement or stored procedure to execute. The valid values are as follows:

• INSERT
• SELECT
• UPDATE
• DELETE
• CALL (for stored procedures)

Note: These parameters are required for the CA SiteMinder®Query element.

Before you customize query schemes, do the following points:

• Become familiar with the default query schemes.

  Note: For more information on SQL query schemes see the CA CA SiteMinder® Web Access Manager Policy Server Configuration Guide.

• Acquire extensive experience developing SQL queries.