TDV Adapter for Oracle Sales
Build 24.0.9060
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
Assets
ContactAddresses
ContactAddressPurposes
ContactNotes
ContactPrimaryAddresses
ContactRelationships
Contacts
ContactSalesAccountResources
Leads
LightboxDocuments
Opportunities
OpportunityCompetitors
OpportunityContacts
OpportunityLeads
OpportunityNotes
OpportunityPartners
OpportunityRevenueItems
OpportunityRevenueTerritories
OpportunitySources
OpportunityTeamMembers
PartnerContacts
PartnerProgramBenefits
PartnerPrograms
Partners
ProgramEnrollments
Proposals
SalesOrders
ServiceProviders
Territories
TerritoryForecasts
Views
ActivityFunctionLookups
CatalogProductGroups
EmployeeResourceAttachments
EmployeeResources
OpportunityDeals
OpportunityRevenueProductGroups
OpportunityRevenueProducts
Resources
ServiceDetails
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.