When you are setting up a connection against an external data source, Spotfire has to map the data types in the data source against data types in Spotfire. See below for a list of the different data type mappings applicable when working against a SQL Server database.
SQL Server Database Type |
Spotfire Data Type |
Supported |
BIGINT |
LongInteger |
Yes |
BINARY |
Binary |
Yes |
IMAGE |
Binary |
Yes |
ROWVERSION |
Binary |
Yes |
TIMESTAMP |
Binary |
Yes |
VARBINARY |
Binary |
Yes |
BIT |
Boolean |
Yes |
CHAR |
String |
Yes |
NCHAR |
String |
Yes |
NTEXT |
String |
Yes |
NVARCHAR |
String |
Yes |
TEXT |
String |
Yes |
UNIQUEIDENTIFIER |
String |
Yes |
VARCHAR |
String |
Yes |
XML |
String |
No |
DATE |
Date |
Yes |
DATETIME |
DateTime |
Yes |
DATETIME2 |
DateTime |
Yes |
DATETIMEOFFSET |
DateTime |
No |
SMALLDATETIME |
DateTime |
Yes |
DECIMAL |
Currency |
Yes |
MONEY |
Currency |
Yes |
NUMERIC |
Currency |
Yes |
SMALLMONEY |
Currency |
Yes |
FLOAT |
Real |
Yes |
SQL_VARIANT |
Real |
No |
INT |
Integer |
Yes |
SMALLINT |
Integer |
Yes |
TINYINT |
Integer |
Yes |
REAL |
SingleReal |
Yes |
TIME |
Time |
Yes |
See also:
Adding Data Connections to an Analysis
Details on Microsoft SQL Server Connection