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 types | Data Orchestrator data types |
binary_double | string |
binary_float | string |
blob | string |
char | string |
char(3 char) | string |
clob | string |
date | timestamp |
decimal | float |
float | float |
float(5) | float |
integer | float |
interval year to month | string |
long raw | string |
number | float |
number(6, 2) | float |
nvarchar(3) | string |
raw | string |
timestamp | timestamp |
timestamp with local time zone | timestamp |
timestamp with time zone | timestamp |
varchar2 | string |
varchar2(256) | string |
xmltype | string |