Teradata 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 type mappings applicable when working with a Teradata database.

Note that no user defined data types, including geometry types, are supported.

Teradata Database Type	Spotfire Data Type	Supported
BIGINT	LongInteger	Yes
BLOB	Binary	Yes
BYTE	Binary	Yes
VARBYTE	Binary	Yes
BYTEINT	Integer	Yes
INTEGER	Integer	Yes
SMALLINT	Integer	Yes
FLOAT	Real	Yes
NUMBER	Real	Yes
DECIMAL(p,s)	When p <= 9 and s = 0: Integer When 9 < p <= 18 and s = 0: LongInteger Else: Real	Yes
CHARACTER	String	Yes
CLOB		No
GRAPHIC	String	Yes
PERIOD DATE	Date	Yes (as two columns, begin/end)
PERIOD TIME	Time	Yes (as two columns, begin/end)
PERIOD TIME WITH TIME ZONE	Time	Yes (as two columns, begin/end)
PERIOD TIMESTAMP	DateTime	Yes (as two columns, begin/end)
PERIOD TIMESTAMP WITH TIME ZONE	DateTime	Yes (as two columns, begin/end)
VARCHAR	String	Yes
LONG VARCHAR	String	Yes
VARGRAPHIC	String	Yes
LONG VARGRAPHIC	String	Yes
TIME	Time	Yes
TIME WITH TIME ZONE	Time	Yes
DATE	Date	Yes
TIMESTAMP	DateTime	Yes
TIMESTAMP WITH TIMEZONE	DateTime	Yes
INTERVAL DAY	TimeSpan	Yes
INTERVAL DAY TO HOUR	TimeSpan	Yes
INTERVAL DAY TO MINUTE	TimeSpan	Yes
INTERVAL DAY TO SECOND	TimeSpan	Yes
INTERVAL HOUR	TimeSpan	Yes
INTERVAL HOUR TO MINUTE	TimeSpan	Yes
INTERVAL HOUR TO SECOND	TimeSpan	Yes
INTERVAL MINUTE	TimeSpan	Yes
INTERVAL MINUTE TO SECOND	TimeSpan	Yes
INTERVAL SECOND	TimeSpan	Yes
INTERVAL MONTH		No
INTERVAL YEAR		No
INTERVAL YEAR TO MONTH		No