IBM Netezza 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 an IBM Netezza database.

IBM Netezza Data Type	Spotfire Data Type
VARBINARY	Binary
BOOLEAN	Boolean
DATE	Date
TIMESTAMP	DateTime
BYTEINT	Integer
INTEGER	Integer
SMALLINT	Integer
BIGINT	LongInteger
DOUBLE	Real
FLOAT	SingleReal
REAL	SingleReal
CHAR	String
JSON	String
NCHAR	String
NVARCHAR	String
VARCHAR	String
TIME	Time
NUMERIC(p,s), DECIMAL(p, s)	When p <= 9 and s = 0: Integer When 9 < p <= 18 and s = 0: LongInteger Else: Real

Any other data types are not supported.