Skip to main content

Data type support & mapping for Oracle sources

Oracle source type

BigQuery

Databricks

MySQL

Oracle

PostgreSQL

Snowflake

Spanner

SQL Server / Azure Synapse

binary_double

float64

double

double

double precision

double Precision

float

float64

float(s)

binary_float

float64

float

float(s)

float

real

float

float64

float(s)

blob

bytes

binary

longblob

blob

bytea

binary

bytes(p)

bytes(max) if p > 10485760

in Striim 4.2.0.3 and earlier:

varbinary(p) if <= 8000

varbinary(max) if > 8000

in Striim 4.2.0.4 and later:

varbinary(max)

character

string

string

character(1)

character(1)

character(1)

character(1)

string(1)

character(1)

character(s)

string

string

character(s)

longtext if (s)>255

character(s)

character(s)

character(s)

string(s)

character(s)

clob

string

string

text

clob

text

varchar

string(4000)

string(max) if (s) > 2621440

in Striim 4.2.0.3 and earlier:

varchar(s)

varchar(max) if (s) > 8000

in Striim 4.2.0.4 and later:

varchar(max)

date

date

date

datetime

date

timestamp without time zone

date

date

datetime2

float

float64

float

double

float

double precision

float

float64

varchar(8000)

float(s)

float64

float

float(s)

float

double precision

float

float64

float(s)

int

numeric

decimal(38)

decimal(38,0)

number(38,0)

numeric(38,0)

numeric(38,0)

float64

numeric(38,0)

interval day to second

string

string

varchar(100)

interval day(2) to second(6)

character varying

varchar

string(max)

varchar(100)

interval year to Month

string

string

varchar(100)

interval year(2) to month

character varying

varchar

string(max)

varchar(100)

long*

bytes

binary

longblob

longblob

bytea

binary

bytes(max)

varbinary(max)

long_raw*

bytes

binary

longblob

longblob

bytea

binary

bytes(max)

varbinary(max)

nchar(s)

string

string

nvarchar(s)

nchar(s)

character(s)

character(s)

string(s)

nchar(s)

nclob

string

string

longtext

nclob

text

varchar

string(s)

string(max) if > 2621440

nvarchar if <= 4000

nvarchar(max) if > 4000

number

numeric

decimal(38)

decimal(65)

number

numeric

numeric

float64

numeric(38)

number(p,s)

numeric

string if (s)>9

decimal(p,s) (if p<=38 and s<=37)

string (if p>38 or s>37)

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) (if p <= 38)

string (if p>38)

decimal(p,0)

number(p,0)

numeric(p,0)

numeric(p,0)

float64

numeric(p,0)

nvarchar2(s)

string

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

not supported

raw

bytes

binary

longblob

blob

bytea

binary

bytes(p)

bytes(max) if > 10485760

varbinary(p) if <= 8000

varbinary(max) if > 8000

timestamp

datetime

timestamp

datetime

timestamp

timestamp without timezone

timestamp

timestamp

datetime2

timestamp with local time zone

timestamp

timestamp

datetime

timestamp with time zone

timestamp with time zone

timestamp with time zone

timestamp

datetimeOffset

timestamp with time zone

timestamp

timestamp

datetime

timestamp with time zone

timestamp with time zone

timestamp with time zone

timestamp

datetimeoffset

varchar

string

string

varchar(s)

Mapped with varchar(s)

character varying(s)

Mapped with varchar(s)

string(s)

varchar(s)

varchar2(s)

string

string

varchar(s)

varchar2(s)

character Varying(s)

varchar(s)

string(s)

varchar(s)

xml

string

string

longtext

xmltype

xml

varchar

string(max)

xml

*OJet supports these types, but Oracle Reader does not. Oracle suggests using CLOB in place of LONG or LONG RAW.

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).