JDBC Driver for SuiteCRM

Build 22.0.8462

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462