Tables
The driver models the data in SuiteCRM into a list of tables that can be queried using standard SQL statements.
Generally, querying SuiteCRM tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC 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 |