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 type mappings applicable when working with an Attivio database.
|
Attivio Database Type |
Spotfire Data Type |
Supported |
|
LONG |
LongInteger |
Yes |
|
BIGINT |
LongInteger |
Yes |
|
BIGINTEGER |
LongInteger |
Yes |
|
BOOLEAN |
Boolean |
Yes |
|
BYTE |
Integer |
Yes |
|
TINYINT |
Integer |
Yes |
|
SHORT |
Integer |
Yes |
|
SMALLINT |
Integer |
Yes |
|
CHAR |
String |
Yes |
|
VARBINARY |
Binary |
Yes |
|
DATE |
Date |
Yes |
|
DOUBLE |
Real |
Yes |
|
INTEGER |
Integer |
Yes |
|
SERIAL |
Integer |
Yes |
|
NUMERIC |
Currency |
Yes |
|
BIGDECIMAL |
Currency |
Yes |
|
DECIMAL |
Currency |
Yes |
|
REAL |
SingleReal |
Yes |
|
FLOAT |
SingleReal |
Yes |
|
STRING |
String |
Yes |
|
VARCHAR |
String |
Yes |
|
TIME |
Time |
Yes |
|
TIMESTAMP |
DateTime |
Yes |
Any other data types are not supported.