This page describes the Oracle data types and the Anaplan Data Orchestrator data types they map to when you create a connection. The data type mapping is fixed.

Oracle data typesData Orchestrator data types
binary_doublestring
binary_floatstring
blobstring
charstring
char(3 char)string
clobstring
datetimestamp
decimalfloat
floatfloat
float(5)float
integerfloat
interval year to monthstring
long rawstring
numberfloat
number(6, 2)float
nvarchar(3)string
rawstring
timestamptimestamp
timestamp with local time zonetimestamp
timestamp with time zonetimestamp
varchar2string
varchar2(256)string
xmltypestring