Application Ingestion and Replication

Back Next

Workday Source and Amazon Redshift Target

The following table identifies the recommended data type mappings for

configurations with a Workday source and an Amazon Redshift target:

Workday Source Data Type	Amazon Redshift Target Data Type
json	super
string	character varying(p), 4 <= p <= 4000
xml	character varying(65535)
xsd	numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
xsd:boolean	boolean
xsd:date	date
xsd:datetime	timestamp with time zone
xsd:string	character varying(p), 4 <= p <= 4000