Tables
The provider models the data in Highrise as a list of tables in a relational database that can be queried using standard SQL statements.
CData ADO.NET Provider for Highrise Tables
| Name | Description |
| Cases | Create, update, delete, and query Cases that are visible to the authenticated user. |
| Comments | Create, update, delete, and query Comments associated with a Note or Email and visible to the authenticated user. |
| Companies | To Create, update, delete, and query from Companies table. |
| CustomFields | Return all custom fields used in the account. |
| DealCategories | Create, update, delete, and query Deal Categories. |
| Deals | To Create, update, delete, and query from Deals table. |
| Groups | Return a collection of groups. For a more readable representation of a group's users, specify the GroupId field when selecting from the Users table. To change group memberships, see the Memberships table. |
| Notes | Create, update, delete, and query Notes that are visible to the authenticated user and related to a specific Person, Company, Case, or Deal. |
| People | To Create, update, delete, and query from People table. |
| TaskCategories | Create, update, delete, and query Task Categories. |