Entity Data Model (EDM) types for OData Version 2

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 144. Supported Data Types for OData version 2
SQL Data Type	EDM Data Type
BIGINT	Edm.Int64
BINARY	Edm.Binary
BIT	Edm.Boolean
BOOLEAN	Edm.Boolean
CHAR	Edm.String
DATE	Edm.DateTime
DECIMAL	Edm.Decimal
DOUBLE	Edm.Double
FLOAT	Edm.Double
INTEGER	Edm.Int32
LONGVARBINARY1	Edm.Binary
LONGVARCHAR1	Edm.String
REAL	Edm.Single
SMALLINT	Edm.Int16
TIME	Edm.DateTime
TIMESTAMP	Edm.DateTime (no timezone) Edm.DateTimeOffset (with timezone)
TINYINT	Edm.SByte
VARBINARY	Edm.Binary
VARCHAR	Edm.String