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 Greenplum database.
Greenplum Data Type |
Spotfire Data Type |
BYTEA |
Binary |
BOOL |
Boolean/Bool |
DATE |
Date |
TIMESTAMP |
DateTime |
TIMESTAMPTZ |
DateTime |
INT2 |
Integer/Int |
INT4 |
Integer/Int |
OID |
Integer/Int |
REGCLASS |
Integer/Int |
REGOPER |
Integer/Int |
REGOPERATOR |
Integer/Int |
REGPROC |
Integer/Int |
REGPROCEDURE |
Integer/Int |
REGTYPE |
Integer/Int |
INT8 |
LongInteger/Long |
FLOAT8 |
Real/Double |
FLOAT4 |
SingleReal/Float |
BIT |
String |
BPCHAR |
String |
CHAR |
String |
CIDR |
String |
INET |
String |
INTERVAL |
String |
MACADDR |
String |
MONEY |
String |
NAME |
String |
TEXT |
String |
VARBIT |
String |
VARCHAR |
String |
TIME |
Time |
TIMETZ |
Time |
RELTIME |
Time |
NUMERIC(p,s) |
When p <= 9 and s = 0: Integer/Int When 9 < p <= 18 and s = 0: LongInteger/Long When p <= 15: Real/Double Else: Currency/Decimal |
Any other data types are not supported.