Home > Data > Loading Data > Add Data Connection > Mapping of External Data Types > ADS Composite Information Server Data Types

ADS Composite Information Server Data Types

When you are setting up a connection against an external data source, Spotfire has to map the data types in the data source against data types in Spotfire. See below for a list of the different data type mappings applicable when working against an ADS (Composite Information Server) database.

ADS (Composite Information Server) Database Type	Spotfire Data Type	Supported
BIT	Boolean	Yes
CHAR	String	Yes
VARCHAR	String	Yes
LONGVARCHAR	String	Yes
DATE	Date	Yes
TIMESTAMP	DateTime	Yes
TIME	Time	Yes
DOUBLE	Real	Yes
FLOAT	SingleReal	Yes
INTEGER	Integer	Yes
SMALLINT	Integer	Yes
TINYINT	Integer	Yes
BIGINT	LongInteger	Yes
DECIMAL(p, s)	When p <= 9 and s = 0: Integer When 9 < p <= 18 and s = 0: LongInteger Else: Real	Yes

Any other data types are not supported.