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 1. 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

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