TIBCO Data Virtualization® Adapter Online Help > TDV Salesforce with SSO Adapter > Data Model > Data Type Mapping
 
Data Type Mapping
The adapter maps types from the data source to the corresponding data type available in the schema. The following table documents these mappings.
Salesforce with SSO UI
Salesforce API Type
CData Schema
Auto Number
string
string
Lookup Relationship
ID
string
Master-Detail Relationship
ID
string
External Lookup Relationship
ID
string
Checkbox
boolean
bool
Currency
double
float
Date
date
date
Date/Time
datetime
datetime
Email
string
string
Geolocation
Location*
string
Number
double
float
Percent
double
float
Phone
string
string
Picklist
string
string
Picklist (Multi-Select)
string
string
Text
string
string
Text Area
string
string
Text Area (Long)
string
string
Text Area (Rich)
string
string
Text (Encrypted)
string
string
Time
string
string
URL
string
string
Note: Entries marked with an asterisk "*" indicate a structured data type containing latitude and longitude.