Tables
The driver models the data in SuiteCRM as a list of tables in a relational database that can be queried using standard SQL statements.
CData ODBC Driver for SuiteCRM Tables
| Name | Description |
| Accounts | Create, update, delete, and query accounts created in SuiteCRM |
| Calls | Create, update, delete, and query the SuiteCRM project's Calls |
| Campaigns | Create, update, delete, and query the SuiteCRM project's campaigns |
| Cases | Create, update, delete, and query the SuiteCRM cases |
| Contacts | Create, update, delete, and query the contacts in SuiteCRM |
| Contracts | Create, update, delete, and query contracts in SuiteCRM |
| Documents | Create, update, delete, and query Documents created in SuiteCRM |
| Emails | Create, update, delete, and query the SuiteCRM Emails |
| EmailTemplates | Create, update, delete, and query email templates to be used for emails |
| Events | Create, update, delete, and query events registered in the SuiteCRM project |
| Invoices | Create, update, delete, and query the invoices saved in the SuiteCRM |
| KBCategories | Create, update, delete, and query the KBCategories saved in the SuiteCRM |
| KnowledgeBase | Create, update, delete, and query the Knowledge Base saved in the SuiteCRM |
| Leads | Create, update, delete, and query the registered Leads |
| Locations | Create, update, delete, and query locations in SuiteCRM |
| Maps | Create, update, delete, and query the map information of SuiteCRM |
| MapsAddressCache | Create, update, delete, and query information on the Map Address saved in the server cache |
| MapsAreas | Create, update, delete, and query maps via Google Maps. |
| MapsMarkers | Create, update, delete, and query Google Maps Map Markers saved in SuiteCRM |
| Meetings | Create, update, delete, and query Meetings created in SuiteCRM |
| Notes | Create, update, delete, and query Notes created in SuiteCRM |
| Opportunities | Create, update, delete, and query opportunities saved in SuiteCRM |
| PDFTemplates | Create, update, delete, and query PDFTemplates table. |
| Products | Create, update, delete, and query the products registered for the SuiteCRM project |
| ProductsCategories | Create, update, delete, and query the product categories. |
| Projects | Create, update, delete, and query projects registered in SuiteCRM |
| ProjectsTemplates | Create, update, delete, and query any saved project template. |
| Quotes | Create, update, delete, and query quotes saved in SuiteCRM |
| Reports | Create, update, delete, and query information on reports made in SuiteCRM. |
| Spots | Create, update, delete, and query the saved spots. |
| Surveys | Create, update, delete, and query the surveys saved in the SuiteCRM |
| Tasks | Create, update, delete, and query Tasks created in SuiteCRM |
| WorkFlow | Create, update, delete, and query the wokflow actions in SuiteCRM |