Querying data stores with SQL : Supported data types

Try Now

Supported data types

Data types differ depending on the data store you are accessing and whether your application connects using ODBC, JDBC, or OData.

Note: Salesforce data stores include Salesforce, Veeva CRM, FinancialForce, and ServiceMax.

In this section:

Entity Data Model (EDM) types for OData Version 4

Entity Data Model (EDM) types for OData Version 2

Amazon Redshift data types

Apache Hive data types

Autonomous REST Connector data types

Google Analytics data types

Greenplum data types

Informix data types

Microsoft Dynamics CRM Online data types

Microsoft SQL Server data types

MySQL data types

Oracle data types

Oracle Marketing Cloud (Eloqua) data types

Oracle Sales Cloud data types

Oracle Service Cloud data types

PostgreSQL data types

Progress OpenEdge data types

Progress Rollbase data types

Salesforce-type data types

SugarCRM data types

Sybase data types