TIBCO Data Virtualization Data Types

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 When 9 < p <= 18 and s = 0: LongInteger Else: Real

Any other data types are not supported.