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 147. 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
LONGVARBINARY¹	Edm.Binary
LONGVARCHAR²	Edm.String
REAL	Edm.Single
SMALLINT	Edm.Int16
TIME	Edm.TimeOfDay
TIMESTAMP	Edm.DateTimeOffset
TINYINT	Edm.Byte \| Edm.SByte³
VARBINARY	Edm.Binary
VARCHAR	Edm.String

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

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

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