The CData Excel Add-In for ADP models ADP objects as relational tables and views. An ADP object has relationships to other objects; in the tables, these relationships are expressed through foreign keys. The following sections show the available API objects and provide more information on executing SQL to ADP APIs.

Schemas for most database objects are defined in simple, text-based configuration files.

Tables

The add-in models the data exposed by the ADP APIs as relational Tables.

Views

Views describes the available read-only views.

Stored Procedures

Stored Procedures are function-like interfaces to ADP.