skip to main content
Querying data stores with SQL : Supported data types : Salesforce-type data types : Querying against Salesforce external data sources
  

Try Now
Querying against Salesforce external data sources
Salesforce allows you to attach external data sources so they are exposed as if they are part of the Salesforce API. One of the mechanisms is OData, so if you have an OData data source, you can expose it through Salesforce via SOQL.
The following table provides the mapping from the underlying OData data types to the equivalent JDBC and ODBC data types. If you have connected tables to Salesforce using OData, you must use these data type mappings.
Table 169. Supported data types
External OData data type
Salesforce data type
JDBC data type
ODBC data type
Edm.Binary
Not supported by Salesforce
Edm.Boolean
CHECKBOX
BOOLEAN
SQL_BIT
Edm.Byte
NUMBER(3,0)
INTEGER
SQL_INTEGER
Edm.DateTime
DATE/TIME
DATETIME
SQL_TYPE_TIMESTAMP
Edm.DateTimeOffset
DATE/TIME
DATETIME
SQL_TYPE_TIMESTAMP
Edm.Decimal
NUMBER(14,4)
DOUBLE
SQL_DOUBLE
Edm.Double
NUMBER(10,8)
DOUBLE
SQL_DOUBLE
Edm.Guid
TEXT(64)
VARCHAR(64)
SQL_VARCHAR(64)
Edm.Int16
NUMBER(8,0)
INTEGER
SQL_INTEGER
Edm.Int32
NUMBER(18,0)
DOUBLE
SQL_DOUBLE
Edm.Int64
NUMBER(18,0)
DOUBLE
SQL_DOUBLE
Edm.String
TEXT if the length is less than or equal to 255. Otherwise, LONGTEXTAREA
VARCHAR
SQL_WVARCHAR
TIME
Salesforce ignores fields of this type.