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.

FinancialForce with SSO UI	FinancialForce 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.

TDV Adapter for Certinia