Striim 3.9.7 documentation

DatabaseWriter 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

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