The CData ADO.NET Provider for Zendesk models entities in the Zendesk API as tables, views, and stored procedures.

The Tickets table dynamically includes custom fields from your Zendesk account. Other entities are defined in schema files, which are simple, easy-to-read text files that define the structure and organization of data.

Using Query Processing

The provider offloads as much of the SELECT statement processing as possible to the Zendesk APIs and then processes the rest of the query within the provider.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.