The CData SSIS Components 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 SSIS Components 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 component 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 component also surfaces Stored Procedures, function-like interfaces to Highrise that surface additional capabilities of the API.