Microsoft SQL Server Analysis Services Data Types


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 a Microsoft SQL Server Analysis Services data source.

Analysis Services Database Type

Spotfire Data Type

Supported

BigInt

LongInteger/Long

Yes

Binary

Binary

Yes

Boolean

Boolean/Bool

Yes

Currency

Currency

Yes

Date

DateTime

Yes

Double

Real/Double

Yes

Integer

Integer

Yes

Single

SingleReal/Float

Yes

SmallInt

Integer

Yes

TinyInt

Integer

Yes

UnsignedBigInt

LongInteger/Long

Yes

UnsignedInt

Integer

Yes

UnsignedSmallInt

Integer

Yes

UnsignedTinyInt

Integer

Yes

WChar

String

Yes

See also:

Working with Microsoft SQL Server Analysis Services