Connector for IBM Netezza — Features and settings

You can connect to and access data from IBM Netezza databases with the connector for IBM Netezza. On this page, you can find information about the capabilities, available settings, and things to keep in mind when you work with data connections to IBM Netezza.

Page content

Connector features

The following functionality is available when you access data with the connector for IBM Netezza.


Feature	Supported?
Load methods	Import (in-memory) External (in-database) On-demand
Custom queries	Yes
Stored procedures	No
Custom connection properties	No
Single sign-on with identity provider	No
Authoring in web client	No
Included in Spotfire distribution on Linux	Yes, if a driver exists

Data source properties

The following are the supported data source properties that you can configure when you create a data connection with the connector for IBM Netezza.


Option	Description
Server	The name of the server where your data is located. To include a port number, add it directly after the name preceded by colon. Example with port number: MyDatabaseServer:1234
Connect	Connects you to the specified server and populates the list of available databases below.
Database	Select the database of interest from the drop-down list.

Supported 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. The following are the data types that the IBM Netezza connector supports.


Database 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

Supported functions

Supported functions are the functions that you can use when you work with in-database data tables, for example for calculated columns and custom expressions.

Note: Some supported functions might not be possible to use with your database. This depends on what functions are available in the database, which often differs between database versions and types.

The following are the functions that the IBM Netezza connector supports.


Function type	Functions supported
Date and Time	`Year, Quarter, Month, Week, Day, DayOfMonth, DayOfYear, DayOfWeek, Hour, Minute, Second, Millisecond, Add_months`
Conversion	`SN, To_char`
Math	`Abs, ACos, ASin, ATan, ATan2, Ceil, Cos, Degrees, Ln, Sin, Tan, Cot, Exp, Floor, Log, Pi, Pow, Radians, Round, Sign, Sqrt, Trunc`
Operators	`+, -, *, /, %`
Statistical	`Sum, Avg, Max, Min, Median, Count, Stddev, Stddev_pop, Stddev_samp, Variance, Var_pop, Var_samp`
Text	`Ascii, Btrim, Chr, Initcap, Instr, Length, Lower, Lpad, Repeat, Rpad, Strpos, Substr, Translate, Unichr, Unicode, Upper, LTrim, RTrim`
Other	`Le_dst, Dle_dst`

Binning is also supported by this connector.