Before You Configure an ODBC Directory Configuration File

Before you configure an ODBC directory configuration file, ensure that the database meets the following requirements:

The database must be accessible through an Open Database Connectivity (ODBC) driver. The driver should support outer joins. If more than two tables are used to represent a user object, the driver should also support nested outer joins.
Note: If the ODBC driver does not support outer joins, the Administrative UI uses inner joins when querying the database. This may cause unexpected query results.
You must be able to uniquely identify each user object. For example, the unique identifier for users may be a login ID.
Note: The unique identifier must be stored in a single column.