Tables
The driver models the data in Salesforce into a list of tables that can be queried using standard SQL statements.
Generally, querying Salesforce 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 ODBC Driver for Salesforce Tables
| Name | Description |
| AcceptedEventRelation | This is a table representing the AcceptedEventRelation entities in Salesforce. |
| Account | This is a table representing the Account entities in Salesforce. |
| AccountContactRole | This is a table representing the AccountContactRole entities in Salesforce. |
| AccountFeed | This is a table representing the AccountFeed entities in Salesforce. |
| AccountHistory | This is a table representing the AccountHistory entities in Salesforce. |
| AccountPartner | This is a table representing the AccountPartner entities in Salesforce. |
| AccountShare | This is a table representing the AccountShare entities in Salesforce. |
| AdditionalNumber | This is a table representing the AdditionalNumber entities in Salesforce. |
| ApexClass | This is a table representing the ApexClass entities in Salesforce. |
| ApexComponent | This is a table representing the ApexComponent entities in Salesforce. |
| ApexLog | This is a table representing the ApexLog entities in Salesforce. |
| ApexPage | This is a table representing the ApexPage entities in Salesforce. |
| ApexTestQueueItem | This is a table representing the ApexTestQueueItem entities in Salesforce. |
| ApexTestResult | This is a table representing the ApexTestResult entities in Salesforce. |
| ApexTrigger | This is a table representing the ApexTrigger entities in Salesforce. |
| AppMenuItem | This is a table representing the AppMenuItem entities in Salesforce. |
| Approval | This is a table representing the Approval entities in Salesforce. |
| Asset | This is a table representing the Asset entities in Salesforce. |
| AssetFeed | This is a table representing the AssetFeed entities in Salesforce. |
| AssignmentRule | This is a table representing the AssignmentRule entities in Salesforce. |
| AsyncApexJob | This is a table representing the AsyncApexJob entities in Salesforce. |
| Attachment | This is a table representing the Attachment entities in Salesforce. |
| AuthProvider | This is a table representing the AuthProvider entities in Salesforce. |
| AuthSession | This is a table representing the AuthSession entities in Salesforce. |
| BrandTemplate | This is a table representing the BrandTemplate entities in Salesforce. |
| BusinessHours | This is a table representing the BusinessHours entities in Salesforce. |
| BusinessProcess | This is a table representing the BusinessProcess entities in Salesforce. |
| CallCenter | This is a table representing the CallCenter entities in Salesforce. |
| Campaign | This is a table representing the Campaign entities in Salesforce. |
| CampaignFeed | This is a table representing the CampaignFeed entities in Salesforce. |
| CampaignMember | This is a table representing the CampaignMember entities in Salesforce. |
| CampaignMemberStatus | This is a table representing the CampaignMemberStatus entities in Salesforce. |
| CampaignShare | This is a table representing the CampaignShare entities in Salesforce. |
| Case | This is a table representing the Case entities in Salesforce. |
| CaseComment | This is a table representing the CaseComment entities in Salesforce. |
| CaseContactRole | This is a table representing the CaseContactRole entities in Salesforce. |
| CaseFeed | This is a table representing the CaseFeed entities in Salesforce. |
| CaseHistory | This is a table representing the CaseHistory entities in Salesforce. |
| CaseShare | This is a table representing the CaseShare entities in Salesforce. |
| CaseSolution | This is a table representing the CaseSolution entities in Salesforce. |
| CaseStatus | This is a table representing the CaseStatus entities in Salesforce. |
| CaseTeamMember | This is a table representing the CaseTeamMember entities in Salesforce. |
| CaseTeamRole | This is a table representing the CaseTeamRole entities in Salesforce. |
| CaseTeamTemplate | This is a table representing the CaseTeamTemplate entities in Salesforce. |
| CaseTeamTemplateMember | This is a table representing the CaseTeamTemplateMember entities in Salesforce. |
| CaseTeamTemplateRecord | This is a table representing the CaseTeamTemplateRecord entities in Salesforce. |
| CategoryData | This is a table representing the CategoryData entities in Salesforce. |
| CategoryNode | This is a table representing the CategoryNode entities in Salesforce. |
| ChatterActivity | This is a table representing the ChatterActivity entities in Salesforce. |
| ClientBrowser | This is a table representing the ClientBrowser entities in Salesforce. |
| CollaborationGroup | This is a table representing the CollaborationGroup entities in Salesforce. |
| CollaborationGroupFeed | This is a table representing the CollaborationGroupFeed entities in Salesforce. |
| CollaborationGroupMember | This is a table representing the CollaborationGroupMember entities in Salesforce. |
| CollaborationGroupMemberRequest | This is a table representing the CollaborationGroupMemberRequest entities in Salesforce. |
| CollaborationInvitation | This is a table representing the CollaborationInvitation entities in Salesforce. |
| Community | This is a table representing the Community entities in Salesforce. |
| Contact | This is a table representing the Contact entities in Salesforce. |
| ContactFeed | This is a table representing the ContactFeed entities in Salesforce. |
| ContactHistory | This is a table representing the ContactHistory entities in Salesforce. |
| ContactShare | This is a table representing the ContactShare entities in Salesforce. |
| ContentDocument | This is a table representing the ContentDocument entities in Salesforce. |
| ContentDocumentFeed | This is a table representing the ContentDocumentFeed entities in Salesforce. |
| ContentDocumentHistory | This is a table representing the ContentDocumentHistory entities in Salesforce. |
| ContentDocumentLink | This is a table representing the ContentDocumentLink entities in Salesforce. |
| ContentVersion | This is a table representing the ContentVersion entities in Salesforce. |
| ContentVersionHistory | This is a table representing the ContentVersionHistory entities in Salesforce. |
| Contract | This is a table representing the Contract entities in Salesforce. |
| ContractContactRole | This is a table representing the ContractContactRole entities in Salesforce. |
| ContractFeed | This is a table representing the ContractFeed entities in Salesforce. |
| ContractHistory | This is a table representing the ContractHistory entities in Salesforce. |
| ContractStatus | This is a table representing the ContractStatus entities in Salesforce. |
| CronJobDetail | This is a table representing the CronJobDetail entities in Salesforce. |
| CronTrigger | This is a table representing the CronTrigger entities in Salesforce. |
| Dashboard | This is a table representing the Dashboard entities in Salesforce. |
| DashboardComponent | This is a table representing the DashboardComponent entities in Salesforce. |
| DashboardComponentFeed | This is a table representing the DashboardComponentFeed entities in Salesforce. |
| DashboardFeed | This is a table representing the DashboardFeed entities in Salesforce. |
| DeclinedEventRelation | This is a table representing the DeclinedEventRelation entities in Salesforce. |
| Document | This is a table representing the Document entities in Salesforce. |
| DocumentAttachmentMap | This is a table representing the DocumentAttachmentMap entities in Salesforce. |
| Domain | This is a table representing the Domain entities in Salesforce. |
| DomainSite | This is a table representing the DomainSite entities in Salesforce. |
| EmailServicesAddress | This is a table representing the EmailServicesAddress entities in Salesforce. |
| EmailServicesFunction | This is a table representing the EmailServicesFunction entities in Salesforce. |
| EmailTemplate | This is a table representing the EmailTemplate entities in Salesforce. |
| EntitySubscription | This is a table representing the EntitySubscription entities in Salesforce. |
| Event | This is a table representing the Event entities in Salesforce. |
| EventFeed | This is a table representing the EventFeed entities in Salesforce. |
| EventRelation | This is a table representing the EventRelation entities in Salesforce. |
| FeedComment | This is a table representing the FeedComment entities in Salesforce. |
| FeedItem | This is a table representing the FeedItem entities in Salesforce. |
| FeedPollChoice | This is a table representing the FeedPollChoice entities in Salesforce. |
| FeedPollVote | This is a table representing the FeedPollVote entities in Salesforce. |
| FieldPermissions | This is a table representing the FieldPermissions entities in Salesforce. |
| FiscalYearSettings | This is a table representing the FiscalYearSettings entities in Salesforce. |
| Folder | This is a table representing the Folder entities in Salesforce. |
| ForecastShare | This is a table representing the ForecastShare entities in Salesforce. |
| Group | This is a table representing the Group entities in Salesforce. |
| GroupMember | This is a table representing the GroupMember entities in Salesforce. |
| HashtagDefinition | This is a table representing the HashtagDefinition entities in Salesforce. |
| Holiday | This is a table representing the Holiday entities in Salesforce. |
| Lead | This is a table representing the Lead entities in Salesforce. |
| LeadFeed | This is a table representing the LeadFeed entities in Salesforce. |
| LeadHistory | This is a table representing the LeadHistory entities in Salesforce. |
| LeadShare | This is a table representing the LeadShare entities in Salesforce. |
| LeadStatus | This is a table representing the LeadStatus entities in Salesforce. |
| LoginHistory | This is a table representing the LoginHistory entities in Salesforce. |
| LoginIp | This is a table representing the LoginIp entities in Salesforce. |
| MailmergeTemplate | This is a table representing the MailmergeTemplate entities in Salesforce. |
| MobileDeviceRegistrar | This is a table representing the MobileDeviceRegistrar entities in Salesforce. |
| Note | This is a table representing the Note entities in Salesforce. |
| ObjectPermissions | This is a table representing the ObjectPermissions entities in Salesforce. |
| Opportunity | This is a table representing the Opportunity entities in Salesforce. |
| OpportunityCompetitor | This is a table representing the OpportunityCompetitor entities in Salesforce. |
| OpportunityContactRole | This is a table representing the OpportunityContactRole entities in Salesforce. |
| OpportunityFeed | This is a table representing the OpportunityFeed entities in Salesforce. |
| OpportunityFieldHistory | This is a table representing the OpportunityFieldHistory entities in Salesforce. |
| OpportunityHistory | This is a table representing the OpportunityHistory entities in Salesforce. |
| OpportunityLineItem | This is a table representing the OpportunityLineItem entities in Salesforce. |
| OpportunityPartner | This is a table representing the OpportunityPartner entities in Salesforce. |
| OpportunityShare | This is a table representing the OpportunityShare entities in Salesforce. |
| OpportunityStage | This is a table representing the OpportunityStage entities in Salesforce. |
| Organization | This is a table representing the Organization entities in Salesforce. |
| OrgWideEmailAddress | This is a table representing the OrgWideEmailAddress entities in Salesforce. |
| Partner | This is a table representing the Partner entities in Salesforce. |
| PartnerRole | This is a table representing the PartnerRole entities in Salesforce. |
| Period | This is a table representing the Period entities in Salesforce. |
| PermissionSet | This is a table representing the PermissionSet entities in Salesforce. |
| PermissionSetAssignment | This is a table representing the PermissionSetAssignment entities in Salesforce. |
| PermissionSetLicense | This is a table representing the PermissionSetLicense entities in Salesforce. |
| PermissionSetLicenseAssign | This is a table representing the PermissionSetLicenseAssign entities in Salesforce. |
| Pricebook2 | This is a table representing the Pricebook2 entities in Salesforce. |
| Pricebook2History | This is a table representing the Pricebook2History entities in Salesforce. |
| PricebookEntry | This is a table representing the PricebookEntry entities in Salesforce. |
| ProcessDefinition | This is a table representing the ProcessDefinition entities in Salesforce. |
| ProcessInstance | This is a table representing the ProcessInstance entities in Salesforce. |
| ProcessInstanceStep | This is a table representing the ProcessInstanceStep entities in Salesforce. |
| ProcessInstanceWorkitem | This is a table representing the ProcessInstanceWorkitem entities in Salesforce. |
| ProcessNode | This is a table representing the ProcessNode entities in Salesforce. |
| Product2 | This is a table representing the Product2 entities in Salesforce. |
| Product2Feed | This is a table representing the Product2Feed entities in Salesforce. |
| Profile | This is a table representing the Profile entities in Salesforce. |
| PushTopic | This is a table representing the PushTopic entities in Salesforce. |
| QueueSobject | This is a table representing the QueueSobject entities in Salesforce. |
| Quote | This is a table representing the Quote entities in Salesforce. |
| QuoteDocument | This is a table representing the QuoteDocument entities in Salesforce. |
| QuoteFeed | This is a table representing the QuoteFeed entities in Salesforce. |
| QuoteLineItem | This is a table representing the QuoteLineItem entities in Salesforce. |
| RecentlyViewed | This is a table representing the RecentlyViewed entities in Salesforce. |
| RecordType | This is a table representing the RecordType entities in Salesforce. |
| Report | This is a table representing the Report entities in Salesforce. |
| ReportFeed | This is a table representing the ReportFeed entities in Salesforce. |
| Scontrol | This is a table representing the Scontrol entities in Salesforce. |
| SelfServiceUser | This is a table representing the SelfServiceUser entities in Salesforce. |
| SetupEntityAccess | This is a table representing the SetupEntityAccess entities in Salesforce. |
| Site | This is a table representing the Site entities in Salesforce. |
| SiteFeed | This is a table representing the SiteFeed entities in Salesforce. |
| SiteHistory | This is a table representing the SiteHistory entities in Salesforce. |
| Solution | This is a table representing the Solution entities in Salesforce. |
| SolutionFeed | This is a table representing the SolutionFeed entities in Salesforce. |
| SolutionHistory | This is a table representing the SolutionHistory entities in Salesforce. |
| SolutionStatus | This is a table representing the SolutionStatus entities in Salesforce. |
| StaticResource | This is a table representing the StaticResource entities in Salesforce. |
| Task | This is a table representing the Task entities in Salesforce. To retrieve archived tasks, you must explicitly query for records with IsArchived set to True. |
| TaskFeed | This is a table representing the TaskFeed entities in Salesforce. |
| TaskPriority | This is a table representing the TaskPriority entities in Salesforce. |
| TaskStatus | This is a table representing the TaskStatus entities in Salesforce. |
| Topic | This is a table representing the Topic entities in Salesforce. |
| TopicAssignment | This is a table representing the TopicAssignment entities in Salesforce. |
| TopicFeed | This is a table representing the TopicFeed entities in Salesforce. |
| UndecidedEventRelation | This is a table representing the UndecidedEventRelation entities in Salesforce. |
| User | This is a table representing the User entities in Salesforce. |
| UserFeed | This is a table representing the UserFeed entities in Salesforce. |
| UserLicense | This is a table representing the UserLicense entities in Salesforce. |
| UserLogin | This is a table representing the UserLogin entities in Salesforce. |
| UserPreference | This is a table representing the UserPreference entities in Salesforce. |
| UserProfile | This is a table representing the UserProfile entities in Salesforce. |
| UserRecordAccess | This is a table representing the UserRecordAccess entities in Salesforce. |
| UserRole | This is a table representing the UserRole entities in Salesforce. |
| Vote | This is a table representing the Vote entities in Salesforce. |
| WebLink | This is a table representing the WebLink entities in Salesforce. |
The driver can also expose custom entities on your Salesforce account that are not mentioned in the Tables. You can query against these custom entities as with any other table. Additionally, you can query against custom fields of standard entities.
There is a naming limitation that applies to the lists and to the custom fields. Empty spaces in list names are converted to underscores for the table names. Also, all custom fields and custom entities are identified by Salesforce with a __c appended to the end of the name.
As of the Spring20 release of the Salesforce's APIs, access for users without the "Customize Application" permission to read unprotected custom metadata types is revoked. To minimize the impact on your users, admins with the Customize Application permission can grant read access through profile or permission sets. See this link for more info.