The CData JDBC Driver 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 driver 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.

The driver offloads as much of the SELECT statement processing as possible to the ADP APIs and then processes the rest of the query in memory. See SupportEnhancedSQL for more information on how the driver circumvents API limitations with in-memory client-side processing.