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 types that Spotfire supports and the applied data type mappings when working with a Microsoft SQL Server Analysis Services data source.

Analysis Services Data Type

Spotfire Data Type

Binary

Binary

Boolean

Boolean/Bool

Currency

Currency

Date

DateTime

Integer

Integer

SmallInt

Integer

TinyInt

Integer

UnsignedInt

Integer

UnsignedSmallInt

Integer

UnsignedTinyInt

Integer

BigInt

LongInteger/Long

UnsignedBigInt

LongInteger/Long

Double

Real/Double

Single

SingleReal/Float

WChar

String

Any other data types are not supported.

See also:

Working with Microsoft SQL Server Analysis Services