When you are configuring 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 Salesforce.com.
Salesforce.com Database Type |
Spotfire Data Type |
Supported |
BIT |
Boolean |
Yes |
DOUBLE |
Real |
Yes |
INTEGER |
Integer |
Yes |
SMALLINT |
Integer |
Yes |
LONGVARBINARY |
Binary |
Yes |
NUMERIC(p,s) |
When p - s > 28: Real When p < 10 and s = 0: Integer When p < 19 and s = 0: LongInteger Else: Currency |
Yes |
TYPE_DATE |
Date |
Yes |
TYPE_TIME |
Time |
Yes |
TYPE_TIMESTAMP |
DateTime |
Yes |
VARCHAR |
String |
Yes |