Connector for IBM DB2 — Features and settings

You can connect to and access data from IBM DB2 databases with the connector for IBM DB2. 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 DB2.

Page content

Connector features

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


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 DB2.


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
Database	The name of the database where your data is located.

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 DB2 connector supports.


Database data type	Spotfire data type
CHAR () FOR BIT DATA	Binary
LONG VARCHAR FOR BIT DATA	Binary
VARCHAR () FOR BIT DATA	Binary
DATA	Date
TIMESTAMP	DateTime
INTEGER	Integer/Int
SMALLINT	Integer/Int
BIGINT	LongInteger/Long
DOUBLE	Real/Double
DECIMAL	s > 26 \|\| p > 28 => Real/Double otherwise => Currency/Decimal
REAL	SingleReal/Float
CHAR	String
LONG VARCHAR	String
VARCHAR	String
TIME	Time

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 DB2 connector supports.


Function type	Functions supported
Date and Time	`Day, DayName, DayOfWeek, DayOfYear, Hour, Microsecond, Minute, Month, MonthName, Month_Between, Next_Day, Quarter, Second, Week, WeekOfYear, Year, DayOfMonth, SecondOfDay, WeekOfMonth`
Conversion	`SN`
Math	`Abs, Ceiling, Degress, Exp, Floor, Ln, Log10, Max, Min, Mod, Power, Radians, Rand, Round, Sign, Sqrt, Trunc, Acos, Asin, Atan, Atan2, Atanh, Cos, Cosh, Cot, Sin, Sinh, Tan, Tanh`
Operators	`%, -, +, *, /`
Statistical	`Avg, Count, UniqueCount, Count_Big, Min, Max, Stddev, Sum, Variance`
Text	`ASCII, Concat, Initcap, Insert, Instr, Lcase, LeftStr, Length, Lower, Lpad, Ltrim, Overlay, Position, PosStr, Repeat, Replace, RightStr, Rpad, Rtrim, Soundex, Space, SubStr, Trim, Ucase, Upper`

Binning is not supported by this connector.