Configuration Guide › Creating an Identity Manager Directory for a Relational Database › 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 you 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 Identity Manager integrates with SiteMinder. In Identity Manager 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 Identity Manager integrates with SiteMinder. In Identity Manager environments that do not include SiteMinder, this subelement is ignored.

A completed database connection resembles the following:

<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 Identity Manager 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 Identity Manager will populate the userdirectory parameter with the name you specify.

  If CA Identity Manager 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 Identity Manager prompts you to supply the name during directory creation.