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
ACLRoles Create, update, delete, and query the ACLRoles table in SuiteCRM
Alerts Create, update, delete, and query the Alerts of your SuiteCRM account
Bugs Create, update, delete, and query the bugs in SuiteCRM
BusinessHours Create, update, delete, and query business hours information in SuiteCRM
Calls Create, update, delete, and query calls in SuiteCRM
CallsReschedule Create, update, delete, and query rescheduled call information for the SuiteCRM calls
CampaignLog Create, update, delete, and query logs related to SuiteCRM campaigns
Campaigns Create, update, delete, and query the SuiteCRM project's campaigns
CaseEvents Create, update, delete, and query the events related to the SuiteCRM cases
Cases Create, update, delete, and query the SuiteCRM cases
CaseUpdates Create, update, delete, and query updated made to the SuiteCRM cases
Contacts Create, update, delete, and query the contacts in SuiteCRM
Contracts Create, update, delete, and query contracts in SuiteCRM
Currencies Create, update, delete, and query currencies used in SuiteCRM financial trackings
DocumentRevisions Query and delete revisions to uploaded SuiteCRM documents
Documents Create, update, delete, and query SuiteCRM documents
EAPM Create, update, delete, and query the EAPM (External API Module) entries in SuiteCRM
EmailAddress Create, update, delete, and query email addresses saved in SuiteCRM
Emails Create, update, delete, and query sent or received emails
EmailTemplates Create, update, delete, and query email templates to be used for emails
Employees Create, update, delete, and query employees registered in the SuiteCRM project
Events Create, update, delete, and query events registered in the SuiteCRM project
InboundEmail Create, update, delete, and query SuiteCRM inbound emails
Index Create, update, delete, and query the available indexes in SuiteCRM
IndexEvent Create, update, delete, and query the Index Event entries in SuiteCRM
Invoices Create, update, delete, and query the invoices saved in the SuiteCRM
Leads Create, update, delete, and query the registered Leads
LineItemGroups Create, update, delete, and query the SuiteCRM line items groups
LineItems Create, update, delete, and query line items in SuiteCRM
Locations Create, update, delete, and query locations in SuiteCRM
MapAddressCache Create, update, delete, and query information on the Map Address saved in the server cache
MapAreas Create, update, delete, and query saved map areas in SuiteCRM
MapMarkers Create, update, delete, and query Google Maps Map Markers saved in SuiteCRM
Maps Create, update, delete, and query maps via Google Maps.
Meetings Create, update, delete, and query meeting information.
Notes Create, update, delete, and query notes in SuiteCRM
OAuthConsumerKeys Create, update, delete, and query information on OAuth keys distributed by the application.
OAuthTokens Query currently active OAuth tokens
Opportunities Create, update, delete, and query opportunities saved in SuiteCRM
OutboundEmailAccounts Create, update, delete, and query the outbound email accounts table
PDFTemplates Create, update, delete, and query PDFTemplates table.
ProcessAudit Create, update, delete, and query information on process audits
ProductCategories Create, update, delete, and query the product categories.
Products Create, update, delete, and query the products registered for the SuiteCRM project
Projects Create, update, delete, and query projects registered in SuiteCRM
ProjectTemplates Create, update, delete, and query any saved project template.
Quotes Create, update, delete, and query quotes saved in SuiteCRM
Releases Create, update, delete, and query the registered releases.
ReportCharts Create, update, delete, and query report charts.
ReportConditions Create, update, delete, and query report conditions.
ReportFields Create, update, delete, and query the saved report fields.
Reports Create, update, delete, and query information on reports made in SuiteCRM.
Roles Create, update, delete, and query the roles in SuiteCRM.
SavedSearches Query any saved searches
ScheduledReports Create, update, delete, and query information on SuiteCRM scheduled reports.
Schedulers Create, update, delete, and query schedulers.
SecurityGroupsManagement Create, update, delete, and query information on security groups
Spots Create, update, delete, and query the saved spots.
SuiteCRMFeed Create, update, delete, and query information on the activity feed in the SuiteCRM project.
TargetLists Create, update, delete, and query the saved target lists.
Targets Query targets saved in SuiteCRM
Tasks Create, update, delete, and query tasks in SuiteCRM.
TemplateSectionLine Create, update, delete, and query the template section line entries in SuiteCRM
Trackers Create, update, delete, and query the created trackers.
Users Create, update, delete, and query the SuiteCRM registered users.
WorkFlow Create, update, delete, and query the wokflow actions in SuiteCRM
WorkFlowActions Create, update, delete, and query the wokflow actions in SuiteCRM.
WorkFlowConditions Create, update, delete, and query the workflow conditions in SuiteCRM.

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