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.