Oracle Source Data Type | Microsoft Azure Synapse Analytics Target Data Type |
|---|---|
binary_double | float |
binary_float | real |
blob | varbinary(max) |
char(s byte), 1 <= size <= 2000 | varchar(size), 4 <= size <= 2000 |
char(s char), 1 <= size <= 2000 | varchar(size), 4 <= size <= 8000 |
clob | varchar(max) |
date | datetime2(0) |
float(precision), 1 <= p <= 126 | varchar(255) |
integer | varchar(255) |
long raw | varbinary(max) |
long(2147483648 byte) | varchar(max) |
nchar(s char), 1 <= size <= 2000 | nchar(size), 1 <= size <= 2000 |
nclob | nvarchar(max) |
number | varchar(255) |
number(*,s), -84 <= s <= 127 | varchar(255) |
number(p,s), 1 <= p <= 38, -37 <= s <= 38 | decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 |
number(p,s), 1 <= p <= 38, -84 <= s <= 127 | varchar(size), 40 <= size <= 130 |
nvarchar2(s char), 1 <= s <= 4000 | nvarchar(size), 1 <= size <= 4000 |
raw(size), 1 <= s <= 2000 | varbinary(size), 1 <= size <= 2000 |
rowid | varchar(18) |
timestamp(precision) with time zone, 0 <= p <= 7 | datetimeoffset(precision), 0 <= p <= 7 |
timestamp(precision) with time zone, 8 <= p <= 9 | char(size), 68 <= size <= 69 |
timestamp(precision), 1 <= p <= 7 | datetime2(precision), 1 <= p <= 7 |
timestamp(precision), 8 <= p <= 9 | char(size), 28 <= size <= 29 |
varchar2(s byte), 1 <= size <= 4000 | varchar(size), 4 <= size <= 4000 |
varchar2(s char), 1 <= size <= 4000 | varchar(size), 4 <= size <= max |
xml | varchar(max) |