OData Data Types


When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. See below for a list of the different data types that Spotfire supports and the applied data type mappings when working with an OData service.

OData Data Type

Spotfire Data Type

Edm.Binary

Binary

Edm.Stream

Binary

Edm.Boolean

Boolean

Edm.Date

Date

Edm.DateTime

DateTime

Edm.DateTimeOffset

DateTime

Edm.Byte

Integer

Edm.SByte

Integer

Edm.Int16

Integer

Edm.Int32

Integer

Edm.Int64

LongInteger

Edm.Double

Real

Edm.Guid

String

Edm.String

String

Edm.Time

Time

Edm.TimeOfDay

Time

Edm.Duration

TimeSpan

Edm.Decimal (p, s)

When p = 0 and s = 0: Currency

When p <= 9 and s = 0: Integer

When 9 < p <= 18 and s = 0: LongInteger

Else: Real

Any other data types are not supported.

Note: The Spotfire OData connector does not support collection properties or navigation properties.

See also:

Details on OData Connection