TIBCO ComputeDB 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 a TIBCO ComputeDB database.

TIBCO ComputeDB Data Type

Spotfire Data Type

Comment

BOOLEAN

Boolean

 

TIMESTAMP

DateTime

 

INT

Integer

 

SMALLINT

Integer

 

TINYINT

Integer

 

BIGINT

LongInteger

 

DOUBLE

Real

 

FLOAT

SingleReal

 

CHAR

String

 

STRING

String

 

DECIMAL (precision (p), scale (s))

When p = 0 and s = 0: Currency

When p <= 9 and s = 0: Integer

When p <=18 and s = 0: LongInteger

When p <= 15: Real

Else: Currency

DECIMAL columns from temporary tables/views are always mapped to the Spotfire data type Currency, because their precision (p, s) is unlimited (0, 0).

Any other data types are not supported.

See also:

Accessing Data from TIBCO ComputeDB

Supported Functions - TIBCO ComputeDB