Striim 3.9.8 documentation

Database Writer data type support and correspondence

Use the following when the input stream is of a user-defined type. (See the Change Data Capture Guide when the input is the output of a CDC or DatabaseReader source.)

Most Striim data types can map to any one of several column types in the target DBMS.

TQL type

Cassandra

MariaDB / MySQL

Oracle

java. lang. Byte

blob

  • BIGINT

  • LONGTEXT

  • MEDIUMINT

  • MEDIUMTEXT

  • SMALLINT

  • TEXT

  • TINYINT

  • INT

  • NUMBER

java. lang. Double

double

  • DOUBLE

  • REAL

  • BINARY_DOUBLE

  • BINARY_FLOAT

  • FLOAT

  • NUMBER

java. lang. Float

float

FLOAT

  • BINARY_DOUBLE

  • BINARY_FLOAT

  • FLOAT

  • NUMBER

java. lang. Integer

int

  • BIGINT

  • INT

  • MEDIUMINT

  • SMALLINT

  • TINYINT

  • INT

  • NUMBER

java. lang. Long

bigint

  • BIGINT

  • SMALLINT

  • TINYINT

  • INT

  • NUMBER

java. lang. Short

int

  • BIGINT

  • SMALLINT

  • TINYINT

  • INT

  • NUMBER

java. lang. String

varchar

  • CHAR

  • TINYTEXT

  • VARCHAR

  • CHAR

  • NCHAR

  • NVARCHAR

  • VARCHAR

  • VARCHAR2

org.joda. time. DateTime

timestamp

  • DATE

  • DATETIME

  • TIMESTAMP

  • YEAR

  • DATE

  • TIMESTAMP

TQL type

PostgreSQL

SAP HANA

SQL Server

java. lang. Byte

not supported

  • BLOB

  • VARBINARY

  • BIGINT

  • SMALLINT

  • TEXT

  • TINYINT

java. lang. Double

double precision

  • DOUBLE

  • FLOAT

FLOAT

java. lang. Float

float

  • FLOAT

  • REAL

  • FLOAT

  • REAL

java. lang. Integer

  • integer

  • serial

INTEGER

  • BIGINT

  • NUMERIC

  • SMALLINT

  • TINYINT

java. lang. Long

  • bigint

  • bigserial

BIGINTEGER

  • BIGINT

  • SMALLINT

  • TINYINT

java. lang. Short

  • smallint

  • smallserial

SMALLINT

  • BIGINT

  • SMALLINT

  • TINYINT

java. lang. String

  • character

  • character varying

  • date

  • numeric

  • text

  • timestamp with timezone

  • timestamp without timezone

  • ALPHANUM

  • NVARCHAR

  • VARCHAR

  • CHAR

  • NCHAR

  • NVARCHAR

  • TEXT

  • UNIQUEIDENTIFER

  • VARCHAR

  • XML

org.joda. time. DateTime

  • timestamp with timezone

  • timestamp without timezone

  • DATE

  • SECONDDATE

  • TIME

  • TIMESTAMP

  • DATE

  • DATETIME

  • DATETIME2

  • TIME