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: