The CData BizTalk Adapter for Zendesk models entities in the Zendesk API as tables, views, and stored procedures. The Tickets schema dynamically reflects changes in custom fields. Other entities are defined in schema files, which are simple, text-based configuration files.
Using Collaborative Query Processing
The adapter offloads as much of the SELECT statement processing as possible to the Zendesk APIs and then processes the rest of the query within the adapter. The following sections document API limitations and requirements. See SupportEnhancedSQL for more information on how the adapter circumvents API limitations with in-memory client-side processing.
Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.