Reference: Supported JDBC-compliant Data Types

Integration only supports a subset of the JDBC-compliant data types. Those data types not supported are not reported back to the server during the import structure process.

The JDBC drivers map the underlying data types to a JDBC type, so to understand what DBMS types are supported, you need to consult documentation for the specific DBMS. This section contains the supported data types for general JDBC-compliant databases, Oracle, SQL Server, and H2 databases.

Supported JDBC data types

JDBC TYPE	DISCOVERY TYPE
CHAR	STRING
VARCHAR	STRING
LONGVARCHAR	STRING
BIT	BOOLEAN
BOOLEAN	BOOLEAN
TINYINT	LONG
SMALLINT	LONG
INTEGER	LONG
BIGINT	LONG
REAL	DOUBLE
DOUBLE	DOUBLE
FLOAT	DOUBLE
DATE	DATE
TIME	DATE
TIMESTAMP	DATE

The following JDBC types are not supported: BINARY, VARBINARY, LONGVARBINARY, DECIMAL, and NUMERIC.

Supported MS SQL Server data types

SQL Server	JDBC	Support
bigint	BIGINT	Y
bit	BIT	Y
decimal	DECIMAL	N
int	INTEGER	Y
money	DECIMAL	N
numeric	NUMERIC	N
smallint	SMALLINT	Y
smallmoney	DECIMAL	N
tinyint	TINYINT	Y
float	DOUBLE	Y
real	REAL	Y
date	VARCHAR	Y
datetime2	VARCHAR	Y
datetime	TIMESTAMP	Y
datetimeoffset	VARCHAR	Y
smalldatetime	TIMESTAMP	Y
time	VARCHAR	Y
char	CHAR	Y
varchar	VARCHAR	Y
text	CLOB	N
nchar	CHAR	Y
nvarchar	CLOB	N
ntext	CLOB	N
binary	BINARY	N
image	BLOB	N
hierarchyid	BLOB	N
sql_variant	VARCHAR	Y
timestamp	BINARY	N
uniqueidentifier	CHAR	Y
xml	CLOB	N

Supported Oracle data types

Oracle	JDBC	Support
CHAR	CHAR	Y
VARCHAR2	VARCHAR	Y
NCHAR	OTHER	N
NVARCHAR2	OTHER	N
NUMBER	DECIMAL	N
FLOAT	FLOAT	Y
BINARY_FLOW		N
BINARY_DOUBLE		N
RAW	VARBINARY	N
DATE	TIMESTAMP	Y
TIMESTAMP	TIMESTAMP	Y
INTERVAL_YEAR_TO_MONTH		N
INTERVAL_DAY_TO_SECOND		N
BLOB	BLOB	N
CLOB	CLOB	N
NCLOB	OTHER	N
BFILE		N
CHARACTER	CHAR	Y
VARCHAR	VARCHAR	Y
NATIONAL_CHARACTER	OTHER	N
NATIONAL_CHAR	OTHER	N
NUMERIC	DECIMAL	N
DECIMAL	DECIMAL	N
DEC	DECIMAL	N
INTEGER	DECIMAL	N
INT	DECIMAL	N
SMALLINT	DECIMAL	N
DOUBLE_PRECISION	FLOAT	Y
REAL	FLOAT	Y

Supported H2 data types

H2	JDBC	Support
INT	INTEGER	Y
INTEGER	INTEGER	Y
MEDIUMINT	INTEGER	Y
INT4	INTEGER	Y
SIGNED	INTEGER	Y
BOOLEAN	BOOLEAN	Y
BIT	BOOLEAN	Y
BOOL	BOOLEAN	Y
TINYINT	TINYINT	Y
SMALLINT	SMALLINT	Y
INT2	SMALLINT	Y
YEAR	SMALLINT	Y
BIGINT	BIGINT	Y
IDENTITY	BIGINT	Y
DECIMAL	DECIMAL	N
NUMBER	DECIMAL	N
DEC	DECIMAL	N
NUMERIC	DECIMAL	N
DOUBLE	DOUBLE	Y
FLOAT	DOUBLE	Y
FLOAT4	REAL	Y
FLOAT8	DOUBLE	Y
REAL	REAL	Y
TIME	TIME	Y
DATE	DATE	Y
TIMESTAMP	TIMESTAMP	Y
DATETIME	TIMESTAMP	Y
SMALLDATETIME	TIMESTAMP	Y
BINARY	VARBINARY	N
VARBINARY	VARBINARY	N
LONGVARBINARY	VARBINARY	N
RAW	VARBINARY	N
BYTEA	VARBINARY	N
OTHER	OTHER	N
VARCHAR	VARCHAR	Y
LONGVARCHAR	VARCHAR	Y
VARCHAR2	VARCHAR	Y
NVARCHAR	VARCHAR	Y
NVARCHAR2	VARCHAR	Y
VARCHAR_CASESENSTIVE	VARCHAR	Y
VARCHAR_IGNORECASE	VARCHAR	Y
CHAR	CHAR	Y
CHARACTER	CHAR	Y
NCHAR	CHAR	Y
BLOB	BLOB	N
TINYBLOB	BLOB	N
MEDIUMBLOB	BLOB	N
LONGBLOB	BLOB	N
IMAGE	BLOB	N
OID	BLOB	N
CLOB	CLOB	N