Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
SAP HANA Source Data Type
| Synapse Analytics Target Data Type
|
---|---|
alphanum( precision ), 1 <= p <= 127
| char( size ), 1 <= s <= 127
|
array
| varbinary(max)
|
bigint
| bigint
|
binary( size ), 1 <= s <= 2000
| binary( size ), 1 <= s <= 2000
|
boolean
| bit
|
char( size ), 1 <= s <= 2000
| char( size ), 1 <= s <= 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 <= s <= 2000
| char( size ), 4 <= s <= 8000
|
nvarchar( size ), 1 <= s <= 5000
| varchar( size ), 4 <= s <= max
|
real
| real
|
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 <= s <= 5000
| varbinary( size ), 1 <= s <= 5000
|
varchar( size ), 1 <= s <= 5000
| varchar( size ), 1 <= s <= 5000
|