The CData MCP Server for LDAP models LDAP data as an easy-to-use SQL database. It also includes Stored Procedures that extend the functionality of the server.

Tables

The included Tables cover many standard object classes, which define the structure and rules for LDAP directory entries. You can easily extend the table schemas to map more closely to your LDAP classes by modifying simple configuration files. See Working with LDAP Tables for a guide to customizing table schemas.

Note: To use custom tables and schemas, set the Location property to the folder containing the schema files.

The following tables are shipped with the server.

Table	Description
Group	Stores a list of user Distinguished Names (DNs) for managing access and security roles on organizational resources.
OrganizationalPerson	Contains organizational details about a user, such as employee number, department, manager, job title, office address, and more. This class is commonly used for directory information systems.
Person	Stores personal information about a user, including general details such as name and contact information.
Top	The root class from which all other LDAP classes are derived. It provides foundational attributes for other directory classes.
User	Stores information about employees, contractors, or long-term visitors in an organization. Includes attributes such as name, contact details, and job-related information.

Stored Procedures

Stored Procedures are scripts that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including exposing LDAP reports as tables, and creating attachments.