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 an Oracle database..
Oracle Data Type |
Spotfire Data Type |
BFILE |
Binary |
BINARY_DOUBLE / REAL |
Real |
BINARY_FLOAT / FLOAT |
SingleReal |
BLOB |
Binary |
CHAR |
String |
CLOB |
String |
DATE |
Date |
INTERVAL DAY TO SECOND |
TimeSpan |
LONG |
String |
LONG RAW |
Binary |
NCHAR |
String |
NCLOB |
String |
NUMBER (NUMBER(x, s)) |
|
Boolean (NUMBER(1)) |
Boolean |
Integer (NUMBER(p) 2 <= p <= 9) |
Integer |
Long (NUMBER(p) 10 <= p <= 18) |
LongInteger |
Double (NUMBER(x, s) 16 > x > s > 0) |
Real |
(NUMBER(x, s)) |
Real |
NVARCHAR / NVARCHAR2 |
String |
RAW |
Binary |
RAW(16) |
String |
ROWID |
String |
SDO_GEOMETRY |
Binary |
TIMESTAMP |
DateTime |
UROWID |
String |
VARCHAR / VARCHAR2 |
String |
Any other data types are not supported.