Salesforce.com Data Types


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

See also:

Loading Data from Salesforce.com

Details on Salesforce.com Connection