The CData Tableau Connector for Active Directory models Active Directory entities in relational tables and stored procedures.

Tables

The included Tables cover many standard Active Directory object classes. You can easily extend the schemas to map more closely to your Active Directory classes. The schemas are defined in simple configuration files.

To use custom tables and schemas, set the Location property to the folder containing the schema files. The schemas shipped with the connector are located in the db subfolder of the installation directory.

See Working with Active Directory Tables for a guide to customizing table schemas.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to access Active Directory functionality not represented as SELECT, INSERT, UPDATE, or DELETE.

Collaborative Query Processing

API limitations and requirements are documented in this section. The connector offloads as much of the SELECT statement processing as possible to Active Directory and then processes the rest of the query in memory.

See SupportEnhancedSQL for more information on how the connector circumvents API limitations with in-memory client-side processing.