Application Ingestion and Replication

Back Next

SAP ODP Source and Amazon Redshift Target

The following table identifies the recommended data type mappings for

configurations with an SAP ODP source and an Amazon Redshift target:

SAP ODP Source Data Type	Amazon Redshift Target Data Type
accp(6)	character varying(24)
char(p), 1 <= p <= 255	character varying(p), 4 <= p <= 1020
clnt(p), 1 <= p <= 3	character varying(p), 4 <= p <= 12
cuky(p), 1 <= p <= 5	character varying(p), 4 <= p <= 20
curr(p,s), 1 <= p <= 38, 0 <= s <= 16	numeric(p,s), 1 <= p <= 38, 0 <= s <= 16
d16d(p,s), 1 <= p <= 38, 0 <= s <= 16	numeric(p,s), 1 <= p <= 38, 0 <= s <= 16
d16r	double precision
d34d(p,s), 1 <= p <= 38, 0 <= s <= 16	numeric(p,s), 1 <= p <= 38, 0 <= s <= 16
d34r	double precision
dats	date
dec(p,s), 1 <= p <= 38, 0 <= s <= 16	numeric(p,s), 1 <= p <= 38, 0 <= s <= 16
fltp	double precision
int1	smallint
int2	smallint
int4	integer
int8	bigint
lang(1)	character varying(4)
lchr *	character varying (65535)
lraw *	binary varying (1024000)
numc(p), 1 <= p <= 255	character varying(p), 4 <= p <= 1020
quan(p,s), 1 <= p <= 38, 0 <= s <= 16	numeric(p,s), 1 <= p <= 38, 0 <= s <= 16
raw(p), 1 <= p <= 255	binary varying(p), 1 <= p <= 255
sstr(p), 1 <= p <= 1333	character varying(p), 4 <= p <= 5332
strg *	character varying (65535)
tims	time without time zone
unit(p), 1 <= p <= 5	character varying(p), 4 <= p <= 20
* SAP doesn't specify the maximum length for these data types.