TDV Adapter for Oracle Sales
Build 26.0.9770
CData TDV Adapter for Oracle Sales
Getting Started
Basic Tab
Logging
Custom Fields and Objects
Changelog
Advanced Features
User Defined Views
SSL Configuration
Firewall and Proxy
Query Processing
Logging
Exception Handling
SQL Compliance
SELECT Statements
Aggregate Functions
JOIN Queries
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
PIVOT and UNPIVOT
Data Model
Tables
AccountAddresses
AccountAddressPurposes
AccountContactPoints
AccountNotes
AccountOrganizationContacts
AccountPrimaryAddresses
AccountRelationships
AccountResources
Accounts
Activities
ActivityAssignees
ActivityContacts
ActivityNotes
ActivityObjectives
Assets
CompetitorAccounts
ContactAddresses
ContactAddressPurposes
ContactContactPoints
ContactNotes
ContactPrimaryAddresses
ContactRelationships
Contacts
ContactSalesAccountResources
LightboxDocuments
Opportunities
OpportunityAssessments
OpportunityCampaigns
OpportunityCompetitors
OpportunityContacts
OpportunityLeads
OpportunityNotes
OpportunityPartners
OpportunityRevenueItems
OpportunityRevenueItemsChildSplitRevenue
OpportunityRevenueItemsRecurringRevenues
OpportunityRevenueTerritories
OpportunitySources
OpportunityTeamMembers
PartnerContacts
PartnerProgramBenefits
PartnerPrograms
Partners
ProgramEnrollments
Proposals
ResourceUsers
SalesLeadContacts
SalesLeadResources
SalesLeads
SalesLeadsLeadCampaigns
SalesLeadsLeadCompetitors
SalesLeadsLeadQualifications
SalesLeadsNotes
SalesOrders
ServiceProviders
Signatures
Territories
TerritoryForecasts
TerritoryResources
Views
AccountAttachments
AccountHierarchy
AccountsOrganizationDynamicFlexfields
ActivityAttachments
ActivityFunctionLookups
ActivityFunctionLookupsActivityTypeLookups
CatalogProductGroups
ContactAttachments
ContactsPictureAttachments
EmployeeResourceAttachments
OpportunityAttachments
OpportunityDeals
OpportunityRevenueProductGroups
OpportunityRevenueProducts
Resources
ResourceUsersResourceRoleAssignments
SalesLeadAttachments
SalesLeadsLeadOpportunity
SalesLeadsLeadTeam
SalesLeadsProductGroups
SalesLeadsProducts
SalesLeadsSalesLeadProducts
SalesLeadTerritories
ServiceDetails
Stored Procedures
CreateSchema
DeleteAccountsAttachment
DeleteActivityAttachment
DeleteContactsAttachment
DeleteContactsPictureAttachment
DeleteOpportunityAttachment
DeleteSalesLeadsAttachment
UpdateAccountsAttachment
UpdateActivityAttachment
UpdateContactPictureAttachment
UpdateContactsAttachment
UpdateOpportunityAttachment
UpdateSalesLeadsAttachment
UploadAccountsAttachment
UploadActivityAttachment
UploadContactAttachment
UploadContactPictureAttachment
UploadOpportunityAttachment
UploadSalesLeadsAttachment
Connection String Options
Authentication
HostURL
Username
Password
Connection
IncludeCustomFields
IncludeCustomObjects
SSL
SSLServerCert
Firewall
FirewallAutoDetect
FirewallType
FirewallServer
FirewallPort
FirewallUser
FirewallPassword
Proxy
ProxyAutoDetect
ProxyServer
ProxyPort
ProxyAuthScheme
ProxyUser
ProxyPassword
ProxySSLType
ProxyExceptions
Logging
LogModules
Schema
Location
Miscellaneous
ExpandFields
GenerateSchemaFiles
MaxRows
Other
Pagesize
Readonly
Timeout
UserDefinedViews
License
Third Party Copyrights
CData TDV Adapter for Oracle Sales
Oracle Sales Cloud Adapter
Oracle Sales Cloud Version Support
SQL Compliance
The
SQL Compliance
section shows the SQL syntax supported by the adapter and points out any limitations.