Configuration Guide › Relational Database Management › Connection to the User Directory › Description of a Database Connection › Provider Element

Provider Element

The Provider element includes the following subelements:

JDBC (required)

Identifies the JDBC data source to use when connecting to the user store. Specify the JNDI name that you have provided when creating the JDBC data source.

Credentials (required)

Supplies the username and password for accessing the database.

DSN

Identifies the ODBC data source to use when connecting to the user store.

Note: This subelement only applies when CA IdentityMinder integrates with SiteMinder. In CA IdentityMinder environments that do not include SiteMinder, this subelement is ignored.

SiteMinderQuery

Specifies custom query schemes for locating user information in a relational database.

Note: This subelement only applies when CA IdentityMinder integrates with SiteMinder. In CA IdentityMinder environments that do not include SiteMinder, this subelement is ignored.

A completed database connection resembles the following example:

<Provider type="RDB" userdirectory="@SMDirName">
	<JDBC datasource="@SMDirJDBCDataSource"/>
 	<Credentials user="@SMDirUser"
		cleartext="true">@SMDirPassword</Credentials>
	<DSN name="@SMDirDSN" />
	<SiteMinderQuery name="AuthenticateUser" query="SELECT TBLUSERS.LOGINID FROM 	TBLUSERS WHERE TBLUSERS.LOGINID='%s' AND TBLUSERS.PASSWORD='%s'" /> 
</provider>

The attributes for the Provider element are as follows:

type

Specifies the type of database. For Microsoft SQL Server and Oracle databases, specify RDB (default).

userdirectory

Specifies the name of the user directory connection. This parameter corresponds to the Connection Object name that you supply during directory creation.

If CA IdentityMinder integrates with SiteMinder for authentication, it creates a user directory connection in SiteMinder with the name you specify for the Connection Object during installation. If you want to connect to an existing SiteMinder user directory, enter the name of that user directory when prompted for the Connection Object. CA IdentityMinder populates the userdirectory parameter with the name you specify.

If CA IdentityMinder does not integrate with SiteMinder, the value of the userdirectory parameter is any name that you give the JDBC connection to the user store.

Note: Do not specify a name for the user directory connection in the directory.xml file. CA IdentityMinder prompts you to supply the name during directory creation.