ODBC Driver for Salesforce

Build 24.0.9029

Tables

The driver models the data in Salesforce as a list of tables in a relational database that can be queried using standard SQL statements.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9029