Configuration Guide › Creating an Identity Manager Directory for a Relational Database › How to Describe a Database in a Directory Configuration File › Managed Object Descriptions › Database Tables › Table Elements

Table Elements

The parameters for a table element are as follows:

• name

  (Required)

  Specifies the name of the table that stores some or all of the attributes in a managed object's profile.

• primary

  Indicates whether the table is the primary table for the managed object. The primary table contains the unique identifier for the object, as follows:

  • True—The table is the primary table.
  • False—The table is a secondary table (default).

  If you do not specify the primary parameter, CA Identity Manager assumes that the table is a secondary table.

  Note: Only one table can be the primary table.

• filter

  Identifies a subset of the table entries that apply to the managed object if the table stores information for more than one object type.

  The filter parameter may resemble the following:

  filter="type='USER'"

  Note: The filter applies only to queries that CA Identity Manager generates. If you overwrite a generated query with a custom query, you must specify the filter in the custom query.

• fullouterjoin

  Indicates whether the outer join is a full outer join.

  • True— The outer join is a full outer join. In this case, the condition required to return a valid row must be found in both tables in the join for a row to be returned.
  • False—The outer join is a left outer join relative to the primary table. In this case, only the rows in one table in the query need to satisfy the condition (default).

Note: The parameters are optional unless otherwise specified.

The Table parameter can contain one or more Reference elements to link a primary table to secondary tables.