Data Type Mapping in Oracle Database and Oracle Analytics Server

When you import metadata from an Oracle database, the Administration Tool uses the mapping in the following table to determine the corresponding data type in the BI Server for each imported column.

The mapping of data types from the Oracle Database to BI Server might differ depending on the database.

Oracle Database Data Type	BI Server Data Type
CHAR	CHAR
NCHAR	CHAR
VARCHAR2	VARCHAR
NVARCHAR2	VARCHAR
NUMBER	NUMERIC if ENABLE_NUMERIC_DATA_TYPE = YES; otherwise, DOUBLE
NUMBER (precision, scale)	INT if scale = 0 and 1 <= precision <= 9; otherwise, same as NUMBER
BINARY_FLOAT	FLOAT
BINARY_DOUBLE	DOUBLE
DATE	DATETIME
TIMESTAMP	TIMESTAMP
TIMESTAMP WITH TIME ZONE	TIMESTAMP
TIMESTAMP WITH LOCAL TIME ZONE	TIMESTAMP
BLOB	LONGVARBINARY
CLOB	LONGVARCHAR
NCLOB	LONGVARCHAR
BFILE	Not supported
LONG	LONGVARCHAR
LONG RAW	Not supported
ROWID	CHAR
XML Type	LONGVARBINARY
UriType	Not supported