Striim 4.0.4 documentation

... for Oracle sources

Oracle source type

BigQuery

MySQL

Oracle

PostgreSQL

Snowflake

Spanner

SQL Server / Azure Synapse

binary_double

float64

double

double precision

double Precision

float

float64

float(s)

binary_float

float64

float(s) 

float

real

float

float64

float(s)

blob

bytes

longblob

blob

bytea

binary

bytes(p)

bytes(max) if p > 10485760

varbinary(p) if <= 8000

varbinary(max) if > 8000 

character

string

character(1)

character(1)

character(1)

character(1)

string(1)

character(1)

character(s)

string

character(s)

longtext if (s)>255

character(s)

character(s)

character(s)

string(s)

character(s)

clob

string

text

clob

text

varchar

string(4000)

string(max) if (s) > 2621440

varchar(s) 

varchar(max) if (s) > 8000 

date 

date

datetime

date

timestamp without time zone

date

date

datetime2

float

float64

double 

float

double precision

float

float64

varchar(8000)

float(s)

float64

float(s)

float

double precision

float

float64

float(s)

int

numeric

decimal(38,0)

number(38,0)

numeric(38,0)

numeric(38,0)

float64

numeric(38,0)

interval day to second

string

varchar(100)

interval day(2) to second(6)

character varying 

varchar

string(max)

varchar(100)

interval year to Month

string

varchar(100)

interval year(2) to month

character varying 

varchar

string(max)

varchar(100)

nchar(s)

string

nvarchar(s)

nchar(s)

character(s)

character(s)

string(s)

nchar(s)

nclob

string

longtext

nclob

text

varchar

string(s)

string(max) if > 2621440

nvarchar if <= 4000 

nvarchar(max) if > 4000

number

numeric

decimal(65)

number

numeric

numeric

float64

numeric(38)

number(p,s)

numeric 

string if (s)>9 

decimal(p,s)

numeric(p,s)

numeric (p,s)

numeric(p,s)

numeric 

string(max) if (s)>15

numeric(p,s)

number(p)

numeric

decimal(p,0)

number(p,0)

numeric(p,0)

numeric(p,0)

float64

numeric(p,0)

nvarchar2(s)

string

nvarchar(s) 

nvarchar2(s)

character varying(s)

varchar(s)

string(s)

nvarchar(s)

Object type

not supported 

not supported 

not supported 

not supported 

not supported 

not supported

not supported 

raw

bytes

longblob

blob

bytea

binary

bytes(p)

bytes(max) if > 10485760

varbinary(p) if <= 8000

varbinary(max) if > 8000 

timestamp

datetime

datetime

timestamp

timestamp without timezone 

timestamp

timestamp

datetime2

timestamp with local time zone

timestamp

datetime 

timestamp with time zone

timestamp with time zone

timestamp with time zone

timestamp

datetimeOffset

timestamp with time zone

timestamp

datetime

timestamp with time zone

timestamp with time zone

timestamp with time zone

timestamp

datetimeoffset

varchar

string

varchar(s)

Mapped with varchar(s)

character varying(s)

Mapped with varchar(s)

string(s)

varchar(s)

varchar2(s)

string

varchar(s)

varchar2(s)

character Varying(s)

varchar(s)

string(s)

varchar(s)

xml

string

longtext 

xmltype

xml

varchar

string(max)

 xml

Oracle source types ADT, ARRAY, BFILE, LONG, LONG RAW, NESTED TABLE, REF, ROWID, SD0_GEOMETRY, UDT, and UROWID are not supported.

VARCHAR with a JSON constraint is not supported in this release (DEV-26815).

Oracle suggests using CLOB in place of LONG or LONG RAW.