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 Aster database.
Note that no user defined data types, including geometry types, are supported.
Teradata Database Type |
Spotfire Data Type |
Supported |
BYTEA |
Binary |
Yes |
BIGINT |
LongInteger |
Yes |
BOOL |
Boolean |
Yes |
BIT |
String |
Yes |
INTERVAL |
String |
Yes |
IP4 |
String |
Yes |
IP4RANGE |
String |
Yes |
CHARACTER |
String |
Yes |
TEXT |
String |
Yes |
UNKOWN |
String |
Yes |
UUID |
String |
Yes |
VARBIT |
String |
Yes |
VARCHAR |
String |
Yes |
TIMESTAMP WITH TIME ZONE |
DateTime |
Yes |
TIMESTAMP WITHOUT TIME ZONE |
DateTime |
Yes |
TIME WITH TIME ZONE |
Time |
Yes |
TIME WITHOUT TIME ZONE |
Time |
Yes |
DATE |
Date |
Yes |
DOUBLE PRECISION |
Real |
Yes |
NUMERIC |
When p <= 9 and
s = 0: Integer |
Yes |
INTEGER |
Integer |
Yes |
SMALLINT |
Integer |
Yes |
REAL |
SingleReal |
Yes |
BIGSERIAL |
|
No |
SERIAL |
|
No |
See also:
Details on Teradata Aster Connection