OData V2 Protocol Reader Connector > OData V2 Protocol Reader data type reference > OData V2 Protocol Reader and transformation data types
  

OData V2 Protocol Reader and transformation data types

The following table lists the OData V2 data types that OData V2 Protocol Reader Connector supports along with the corresponding transformation data types:
Data types for hierarchical data fields:
OData V2 Protocol Reader Data Type
Transformation Data Type
Description
String
String
-
Boolean
String
-
GUID
String
-
Int32
Integer
-
Int16
Integer
-
DateTime
String
For example, /Date(1592956800000)/
DateTimeOffset
String
For example, /Date(1592956800000)/
Decimal
Decimal
-
Byte
Integer
-
Time
String
-
Note: You must manually edit the precision and scale of the data types if they do not match the required metadata.
Data types for flat data fields:
OData V2 Protocol Reader Data Type
Transformation Data Type
Description
String
String
-
Boolean
String
-
Int64
Integer
-
Int32
Integer
-
Int16
Integer
-
DateTime
String
Dates earlier than 1752-09-14 or pre-Gregorian calendar dates are not read accurately.
DateTimeOffset
String
Dates earlier than 1752-09-14 or pre-Gregorian calendar dates are not read accurately.
Decimal
Decimal
-
Byte
Integer
-
Time
String
-