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 a SQL Server database.
SQL Server Data Type |
Spotfire Data Type |
BINARY |
Binary |
GEOGRAPHY |
Binary |
GEOMETRY |
Binary |
IMAGE |
Binary |
ROWVERSION |
Binary |
TIMESTAMP |
Binary |
VARBINARY |
Binary |
BIT |
Boolean |
DECIMAL |
Currency |
MONEY |
Currency |
NUMERIC |
Currency |
SMALLMONEY |
Currency |
DATE |
Date |
DATETIME |
DateTime |
DATETIME2 |
DateTime |
SMALLDATETIME |
DateTime |
INT |
Integer |
SMALLINT |
Integer |
TINYINT |
Integer |
BIGINT |
LongInteger |
FLOAT |
Real |
REAL |
SingleReal |
CHAR |
String |
NCHAR |
String |
NTEXT |
String |
NVARCHAR |
String |
TEXT |
String |
UNIQUEIDENTIFIER |
String |
VARCHAR |
String |
TIME |
Time |
Any other data types are not supported.