The CData Excel Add-In for Highrise models the Highrise API as relational tables, views, and stored procedures. API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Tables

The CData Excel Add-In for Highrise models writable Highrise APIs as easy-to-access Tables. Most tables are defined in simple, text-based schema files. However, some tables, such as Companies, Deals, and People, are dynamic. When you connect, the add-in gets the metadata for dynamic tables by calling the appropriate Web services.

Views

Views are read-only tables. Typically, data that cannot be modified is represented in views.

Stored Procedures

The add-in also surfaces Stored Procedures, function-like interfaces to Highrise that surface additional capabilities of the API.