skip to main content
Querying data stores with SQL : Supported data types : Entity Data Model (EDM) types for OData Version 4
  

Try Now

Entity Data Model (EDM) types for OData Version 4

To support communication between an OData client and a backend data store, Hybrid Data Pipeline uses a schema map to convert data to the appropriate type for the receiver. You configure the schema map in Hybrid Data Pipeline where it is generated as a JSON string with the following OData Entity Data Model (EDM) types.
Table 149. Supported Data Types
SQL Data Type
EDM Data Type
BIGINT
Edm.Int64
BINARY
Edm.Binary
BIT
Edm.Boolean
BOOLEAN
Edm.Boolean
CHAR
Edm.String
DATE
Edm.Date
DECIMAL
Edm.Decimal
DOUBLE
Edm.Double
FLOAT
Edm.Double
INTEGER
Edm.Int32
LONGVARBINARY1
Edm.Binary
LONGVARCHAR2
Edm.String
REAL
Edm.Single
SMALLINT
Edm.Int16
TIME
Edm.TimeOfDay
TIMESTAMP
Edm.DateTimeOffset
TINYINT
Edm.Byte | Edm.SByte3
VARBINARY
Edm.Binary
VARCHAR
Edm.String

1 For values smaller than 32 KB. Values 32 KB and larger are not supported.

2 For values smaller than 32 KB. Values 32 KB and larger are not supported.

3 Value maps to EDM.Byte if described as unsigned. If the value is described as signed, it maps to EDM.SByte.