When you are configuring 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 data from Spotfire Data Streams.
Spotfire Data Streams Data Type |
Spotfire Data Type |
Comment |
blob |
Binary |
|
bool |
Boolean |
|
timestamp |
DateTime or TimeSpan The timestamp data type in Spotfire Data Streams can represent either an absolute timestamp, or an interval of time. Columns with timestamp data should be mapped to either the Spotfire data type DateTime or TimeSpan accordingly. Absolute timestamp data = DateTime Time interval data = TimeSpan By default, timestamp columns map to the DateTime data type in Spotfire. You must manually change the type mapping for timestamp columns with time interval type data to TimeSpan, when you create the connection. If such columns are mapped as DateTime, the data in the column will not load correctly. |
Timestamp columns that contain both absolute timestamp data and time interval data cannot be loaded. |
int |
Integer |
Yes |
long |
LongInteger |
Yes |
double |
Real |
Yes |
string |
String |
Yes |
Any other data types are not supported.