Teradata Aster 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 Teradata Aster database.

Teradata Data Type	Spotfire Data Type
BYTEA	Binary
BOOL	Boolean
DATE	Date
TIMESTAMP WITH TIME ZONE	DateTime
TIMESTAMP WITHOUT TIME ZONE	DateTime
INTEGER	Integer
SMALLINT	Integer
BIGINT	LongInteger
DOUBLE PRECISION	Real
REAL	SingleReal
BIT	String
CHARACTER	String
INTERVAL	String
IP4	String
IP4RANGE	String
TEXT	String
UNKOWN	String
UUID	String
VARBIT	String
VARCHAR	String
TIME WITH TIME ZONE	Time
TIME WITHOUT TIME ZONE	Time
NUMERIC	When p <= 9 and s = 0: Integer When 9 < p <= 18 and s = 0: LongInteger Else: Real

Any other data types are not supported.

Note: User defined data types, including geometry types, are not supported.