Striim 3.9.4 / 3.9.5 documentation

DatabaseWriter data type support and conversion

The following type conversions are used when the input stream is of a user-defined type. (See the Change Data Capture Guide for data type support 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

MySQL

Oracle

PostgreSQL

SQL Server

java. lang. Byte

blob

  • BIGINT

  • LONGTEXT

  • MEDIUMINT

  • MEDIUMTEXT

  • SMALLINT

  • TEXT

  • TINYINT

  • INT

  • NUMBER

not supported

  • BIGINT

  • SMALLINT

  • TEXT

  • TINYINT

java. lang. Double

double

  • DOUBLE

  • REAL

  • BINARY_DOUBLE

  • BINARY_FLOAT

  • FLOAT

  • NUMBER

double precision

FLOAT

java. lang. Float

float

FLOAT

  • BINARY_DOUBLE

  • BINARY_FLOAT

  • FLOAT

  • NUMBER

float

  • FLOAT

  • REAL

java. lang. Integer

int

  • BIGINT

  • INT

  • MEDIUMINT

  • SMALLINT

  • TINYINT

  • INT

  • NUMBER

  • integer

  • serial

  • BIGINT

  • NUMERIC

  • SMALLINT

  • TINYINT

java. lang. Long

bigint

  • BIGINT

  • SMALLINT

  • TINYINT

  • INT

  • NUMBER

  • bigint

  • bigserial

  • BIGINT

  • SMALLINT

  • TINYINT

java. lang. Short

int

  • BIGINT

  • SMALLINT

  • TINYINT

  • INT

  • NUMBER

  • smallint

  • smallserial

  • BIGINT

  • SMALLINT

  • TINYINT

java. lang. String

varchar

  • CHAR

  • TINYTEXT

  • VARCHAR

  • CHAR

  • NCHAR

  • NVARCHAR

  • VARCHAR

  • VARCHAR2

  • character

  • character varying

  • date

  • numeric

  • text

  • timestamp with timezone

  • timestamp without timezone

  • CHAR

  • NCHAR

  • NVARCHAR

  • TEXT

  • UNIQUEIDENTIFER

  • VARCHAR

  • XML

org.joda. time. DateTime

timestamp

  • DATE

  • DATETIME

  • TIMESTAMP

  • YEAR

  • DATE

  • TIMESTAMP

  • timestamp with timezone

  • timestamp without timezone

  • DATE

  • DATETIME

  • DATETIME2

  • TIME