JDBC Driver for SugarCRM

Build 22.0.8462

Tables

The driver models the data in SugarCRM into a list of tables that can be queried using standard SQL statements.

Generally, querying SugarCRM 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 SugarCRM Tables

Name Description
Accounts Create, update, delete, and query the Accounts module in SugarCRM.
ACLRoles Create, update, delete, and query the ACLRoles module in SugarCRM.
Activities Create, update, delete, and query the Activities module in SugarCRM.
Administration Create, update, delete, and query the Administration module in SugarCRM.
Bugs Create, update, delete, and query the Bugs module in SugarCRM.
Calls Create, update, delete, and query the Calls module in SugarCRM.
CampaignLog Create, update, delete, and query the CampaignLog module in SugarCRM.
Campaigns Create, update, delete, and query the Campaigns module in SugarCRM.
CampaignTrackers Create, update, delete, and query the CampaignTrackers module in SugarCRM.
Cases Create, update, delete, and query the Cases module in SugarCRM.
Comments Create, update, delete, and query the Comments module in SugarCRM.
Contacts Create, update, delete, and query the Contacts module in SugarCRM.
Contracts Create, update, delete, and query the Contracts module in SugarCRM.
ContractTypes Create, update, delete, and query the ContractTypes module in SugarCRM.
Currencies Create, update, delete, and query the Currencies module in SugarCRM.
CustomQueries Create, update, delete, and query the CustomQueries module in SugarCRM.
DataSets Create, update, delete, and query the DataSets module in SugarCRM.
DocumentRevisions Create, update, delete, and query the DocumentRevisions module in SugarCRM.
Documents Create, update, delete, and query the Documents module in SugarCRM.
EAPM Create, update, delete, and query the EAPM (external API module) in SugarCRM.
EmailAddresses Create, update, delete, and query the EmailAddresses module in SugarCRM.
EmailMarketing Create, update, delete, and query the EmailMarketing module in SugarCRM.
Emails Create, update, delete, and query the Emails module in SugarCRM.
EmailTemplates Create, update, delete, and query the EmailTemplates module in SugarCRM.
Employees Create, update, delete, and query the Employees module in SugarCRM.
Filters Create, update, delete, and query the Filters module in SugarCRM.
ForecastManagerWorksheets Create, update, delete, and query the ForecastManagerWorksheets module in SugarCRM.
Forecasts Create, update, delete, and query the Forecasts module in SugarCRM.
ForecastSchedule Create, update, delete, and query the ForecastSchedule module in SugarCRM.
ForecastWorksheets Create, update, delete, and query the ForecastWorksheets module in SugarCRM.
InboundEmail Create, update, delete, and query the InboundEmail module in SugarCRM.
KBDocuments Create, update, delete, and query the KBDocuments module in SugarCRM.
Leads Create, update, delete, and query the Leads module in SugarCRM.
Manufacturers Create, update, delete, and query the Manufacturers module in SugarCRM.
Meetings Create, update, delete, and query the Meetings module in SugarCRM.
Notes Create, update, delete, and query the Notes module in SugarCRM.
Notifications Create, update, delete, and query the Notifications module in SugarCRM.
OAuthKeys Create, update, delete, and query the OAuthKeys module in SugarCRM.
OAuthTokens Create, update, delete, and query the OAuthTokens module in SugarCRM.
Opportunities Create, update, delete, and query the Opportunities module in SugarCRM.
PdfManager Create, update, delete, and query the PdfManager module in SugarCRM.
ProductCategories Create, update, delete, and query the ProductCategories module in SugarCRM.
Products Create, update, delete, and query the Products module in SugarCRM.
ProductTemplates Create, udpate, delete, and query the ProductTemplates module in SugarCRM.
ProductTypes Create, udpate, delete, and query the ProductTypes module in SugarCRM.
Project Create, update, delete, and query the Project module in SugarCRM.
ProjectTask Create, update, delete, and query the ProjectTask module in SugarCRM.
ProspectLists Create, update, delete, and query the ProspectLists module in SugarCRM.
Prospects Create, update, delete, and query the Prospects module in SugarCRM.
Quotas Create, update, delete, and query the Quotas module in SugarCRM.
Quotes Create, update, delete, and query the Quotes module in SugarCRM.
Releases Create, update, delete, and query the Releases module in SugarCRM.
ReportMaker This is a table representing the ReportMaker module in SugarCRM.
Reports This is a table representing the Reports module in SugarCRM.
Reports_1 This is a table representing the Reports module in SugarCRM.
RevenueLineItems This is a table representing the RevenueLineItems module in SugarCRM.
Roles This is a table representing the Roles module in SugarCRM.
SavedSearch This is a table representing the SavedSearch module in SugarCRM.
Schedulers This is a table representing the Schedulers module in SugarCRM.
Shippers This is a table representing the Shippers module in SugarCRM.
Styleguide This is a table representing the Styleguide module in SugarCRM.
Subscriptions This is a table representing the Subscriptions module in SugarCRM.
SugarFavorites This is a table representing the SugarFavorites module in SugarCRM.
Tasks This is a table representing the Tasks module in SugarCRM.
TaxRates This is a table representing the TaxRates module in SugarCRM.
TeamNotices This is a table representing the TeamNotices module in SugarCRM.
Teams This is a table representing the Teams module in SugarCRM.
TimePeriods This is a table representing the TimePeriods module in SugarCRM.
TrackerPerfs This is a table representing the TrackerPerfs module in SugarCRM.
TrackerQueries This is a table representing the TrackerQueries module in SugarCRM.
Trackers This is a table representing the Trackers module in SugarCRM.
TrackerSessions This is a table representing the TrackerSessions module in SugarCRM.
Users This is a table representing the Users module in SugarCRM.
UserSignatures This is a table representing the UserSignatures module in SugarCRM.
WebLogicHooks This is a table representing the WebLogicHooks module in SugarCRM.
WorkFlow This is a table representing the WorkFlow module in SugarCRM.

The driver can also expose custom modules on your SugarCRM account that are not mentioned in the Tables. You can query against these custom modules as with any other table. Additionally, you can query against custom fields of standard modules.

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