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 an Oracle database.
Oracle Database Type |
Spotfire Data Type |
Supported |
BFILE |
Binary |
Yes |
BINARY_DOUBLE / REAL |
Real |
Yes |
BINARY_FLOAT / FLOAT |
SingleReal |
Yes |
BLOB |
Binary |
Yes |
CHAR |
String |
Yes |
CLOB |
String |
Yes |
DATE |
Date |
Yes |
INTERVAL DAY TO SECOND |
TimeSpan |
Yes |
INTERVAL YEAR TO MONTH |
LongInteger |
No |
LONG |
String |
Yes |
LONG RAW |
Binary |
Yes |
NCHAR |
String |
Yes |
NCLOB |
String |
Yes |
NUMBER (NUMBER(x, s)) |
|
|
Boolean (NUMBER(1)) |
Boolean |
Yes |
Integer (NUMBER(p) 2 <= p <= 9) |
Integer |
Yes |
Long (NUMBER(p) 10 <= p <= 18) |
LongInteger |
Yes |
Double (NUMBER(x, s) 16 > x > s > 0) |
Real |
Yes |
(NUMBER(x, s)) |
Real |
Yes |
NVARCHAR / NVARCHAR2 |
String |
Yes |
PLS_INTEGER |
|
No |
RAW |
Binary |
Yes |
RAW(16) |
String |
Yes |
REF |
|
No |
REF CURSOR |
|
No |
ROWID |
String |
Yes |
SDO_GEOMETRY |
Binary |
Yes |
TIMESTAMP |
DateTime |
Yes |
TIMESTAMP WITH LOCAL TIME ZONE |
DateTime |
No |
TIMESTAMP WITH TIME ZONE |
DateTime |
No |
UROWID |
String |
Yes |
VARCHAR / VARCHAR2 |
String |
Yes |
XMLType |
String |
No |