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: