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 data from TIBCO Data Virtualization.
Note: In custom queries, Spotfire parses INTERVAL types to String. This is because of a limitation in the driver regarding non-specific type IDs. If you want the column or columns to be of, for example the TimeSpan type, you can edit the column’s type and cast it to INTERVAL DAY TO SECOND in the custom query.
TIBCO Data Virtualization Data Type |
Spotfire Data Type |
BINARY |
Binary |
BLOB |
Binary |
VARBINARY |
Binary |
BOOLEAN |
Boolean |
BIT |
Boolean |
DATE |
Date |
INTERVAL YEAR TO MONTH |
Date Note: The date 00-00-000 [mm-dd-yyyy] is not valid, since in Spotfire, the data type 'Date' starts from 01-01-0000. This is the reason for the conversion of INTERVAL YEAR TO MONTH to 'Date' instead of 'Integer'. |
TIMESTAMP |
DateTime |
INTEGER |
Integer |
INTERVAL MONTH |
Integer |
INTERVAL YEAR |
Integer |
SMALLINT |
Integer |
TINYINT |
Integer |
BIGINT |
LongInteger |
REAL |
Real |
FLOAT |
SingleReal |
CHAR |
String |
CLOB |
String |
LONGVARCHAR |
String |
STRING |
String |
VARCHAR |
String |
XML |
String |
TIME |
Time |
INTERVAL |
TimeSpan |
INTERVAL DAY |
TimeSpan |
INTERVAL DAY TO HOUR |
TimeSpan |
INTERVAL DAY TO MINUTE |
TimeSpan |
INTERVAL DAY TO SECOND |
TimeSpan |
INTERVAL HOUR |
TimeSpan |
INTERVAL HOUR TO MINUTE |
TimeSpan |
INTERVAL HOUR TO SECOND |
TimeSpan |
INTERVAL MINUTE |
TimeSpan |
INTERVAL MINUTE TO SECOND |
TimeSpan |
INTERVAL SECOND |
TimeSpan |
DECIMAL(p, s) |
When p <= 9 and
s = 0: Integer |
Any other data types are not supported.