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 type mappings applicable when working with an OData service.

OData Database Type

Spotfire Data Type

Supported

Edm.Binary

Binary

Yes

Edm.Stream

Binary

Yes

Edm.Boolean

Boolean

Yes

Edm.Byte

Integer

Yes

Edm.SByte

Integer

Yes

Edm.Int16

Integer

Yes

Edm.Int32

Integer

Yes

Edm.Double

Real

Yes

Edm.Int64

LongInteger

Yes

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

Yes

Edm.Guid

String

Yes

Edm.String

String

Yes

Edm.Date

Date

Yes

Edm.DateTime

DateTime

Yes

Edm.DateTimeOffset

DateTime

Yes

Edm.Time

Time

Yes

Edm.TimeOfDay

Time

Yes

Edm.Duration

TimeSpan

Yes

Note: Collection properties are not supported by the Spotfire OData connector.

Note: Navigation properties are not supported by the Spotfire OData connector.

See also:

Details on OData Connection