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.
Salesforce Data Type |
Spotfire Data Type |
Supported |
BOOLEAN |
Boolean/Bool |
Yes |
DATE |
Date |
Yes |
DATETIME |
DateTime |
Yes |
INT |
Integer/Int |
Yes |
DOUBLE |
Real/Double |
Yes |
CURRENCY |
Real/Double |
Yes |
PERCENT |
Real/Double |
Yes |
STRING |
String |
Yes |