Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
SAP HANA Source Data Type
| Amazon Redshift Target Data Type
|
|---|---|
alphanum( precision ), 1 <= p <= 127
| character( size ), 1 <= s <= 127
|
array 1
| character varying(65535)
|
bigint
| bigint
|
binary( size ), 1 <= s <= 2000
| character varying( size ), 2 <= s <= 4000
|
bintext 1
| |
blob 1
| |
boolean
| boolean
|
char( size ), 1 <= s <= 2000
| character( size ), 1 <= s <= 2000
|
clob 1
| |
date
| date
|
decimal
| character varying(255)
|
decimal(38,38)
| character varying(41)
|
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37
| numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
|
double
| double precision
|
float
| double precision
|
integer
| integer
|
nchar( size ), 1 <= s <= 2000
| character varying( size ), 4 <= s <= 8000
|
nclob 1
| |
nvarchar( size ), 1 <= s <= 5000
| character varying( size ), 4 <= s <= 20000
|
real
| real
|
real
| real
|
seconddate
| timestamp without time zone
|
shorttext( precision ), 1 <= p <= 5000
| character varying( size ), 1 <= s <= 5000
|
smalldecimal
| character varying(255)
|
smallint
| smallint
|
st_geometry 1
| character varying(65535)
|
st_point 1
| character varying(65535)
|
text 1
| |
time
| time without time zone
|
timestamp
| character varying(27)
|
timestamp
| timestamp without time zone
|
tinyint
| smallint
|
varbinary( size ), 1 <= s <= 5000
| character varying( size ), 2 <= s <= 10000
|
varchar( size ), 1 <= s <= 5000
| character varying( size ), 1 <= s <= 5000
|
1. Unsupported source data type. Mass Ingestion Databases replicates only nulls for columns that have these unsupported data types, even thought they are mapped to the default target data types.
| |
