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 a Microsoft SQL Server Analysis Services data source.
Analysis Services Database Type |
Spotfire Data Type |
Supported |
BigInt |
LongInteger/Long |
Yes |
Binary |
Binary |
Yes |
Boolean |
Boolean/Bool |
Yes |
Currency |
Currency |
Yes |
Date |
DateTime |
Yes |
Double |
Real/Double |
Yes |
Integer |
Integer |
Yes |
Single |
SingleReal/Float |
Yes |
SmallInt |
Integer |
Yes |
TinyInt |
Integer |
Yes |
UnsignedBigInt |
LongInteger/Long |
Yes |
UnsignedInt |
Integer |
Yes |
UnsignedSmallInt |
Integer |
Yes |
UnsignedTinyInt |
Integer |
Yes |
WChar |
String |
Yes |