SAP HANA Source Data Type | Microsoft Azure Synapse Analytics Target Data Type |
|---|---|
alphanum(precision), 1 <= p <= 127 | char(size), 1 <= size <= 127 |
array | varbinary(max) |
bigint | bigint |
binary(size), 1 <= size <= 2000 | binary(size), 1 <= size <= 2000 |
boolean | bit |
char(size), 1 <= size <= 2000 | char(size), 1 <= size <= 2000 |
date | date |
decimal | varchar(255) |
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 | decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 |
double | float |
float | float |
integer | int |
nchar(size), 1 <= size <= 2000 | char(size), 4 <= size <= 8000 |
nvarchar(size), 1 <= size <= 5000 | varchar(size), 4 <= size <= max |
real | real |
seconddate | datetime2(0) |
shorttext(precision), 1 <= p <= 5000 | varchar(size), 1 <= s <= 5000 |
smalldecimal | varchar(255) |
smallint | smallint |
st_geometry | varbinary(max) |
st_point | varbinary(max) |
time | time(0) |
timestamp | datetime2(precision), 0 <= p <= 7 |
tinyint | tinyint |
varbinary(size), 1 <= size <= 5000 | varbinary(size), 1 <= size <= 5000 |
varchar(size), 1 <= size <= 5000 | varchar(size), 1 <= size <= 5000 |