ODBC Driver for Salesforce

Build 24.0.9029

Data Type Mapping

The driver maps types from the data source to the corresponding data type available in the schema. The following table documents these mappings.

Data Type Mapping

Salesforce 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 time time
URL string string

Note: Entries marked with an asterisk "*" indicate a structured data type containing latitude and longitude.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9029