Oracle to Azure Synapse mapping

AutoSync maps Oracle object types to the following Azure Synapse column types:


Oracle object type	Azure Synapse column type
`char`	`char`
`varchar2`	`varchar`
`nchar`	`nchar`
`nvarchar2`	`nvarchar`
`number`	`decimal`
`number (without precision and scale)`	`float`
`float`	`float`
`binary_float`	`float`
`binary_double`	`float`
`long`	`varchar`
`long raw`	`varchar`
`raw`	`varchar`
`date`	`date`
`timestamp`	`datetime`
`timestamp with time zone`	`datetimeoffset`
`timestamp with local time zone`	`datetime`
`interval year to month`	`varchar`
`interval day to second`	`varchar`
`blob`	`varchar`
`clob`	`varchar`
`nclob`	`nvarchar`
`bfile`	`varchar`
`rowid`	`varchar`
`urowid`	`varchar`
`anydata`	`varchar`
`xmltype`	`varchar`