TDV Adapter for Oracle Sales
Build 23.0.8839
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
SQL Compliance
SELECT Statements
Aggregate Functions
JOIN Queries
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
PIVOT and UNPIVOT
Data Model
Tables
AccountAddresses
AccountAddressPurposes
AccountNotes
AccountPrimaryAddresses
AccountRelationships
AccountResources
Accounts
Activities
ActivityAssignees
ActivityContacts
ActivityNotes
ActivityObjectives
ContactAddresses
ContactAddressPurposes
ContactNotes
ContactPrimaryAddresses
ContactRelationships
Contacts
ContactSalesAccountResources
EmployeeResourceAttachments
EmployeeResources
Opportunities
OpportunityCompetitors
OpportunityContacts
OpportunityDeals
OpportunityLeads
OpportunityNotes
OpportunityPartners
OpportunityRevenueItems
OpportunityRevenueProductGroups
OpportunityRevenueProducts
OpportunityRevenueTerritories
OpportunitySources
OpportunityTeamMembers
Territories
Stored Procedures
CreateSchema
Connection String Options
Authentication
HostURL
Username
Password
Connection
IncludeCustomFields
IncludeCustomObjects
SSL
SSLServerCert
Firewall
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
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.