Supported Data Types by Database

Oracle Analytics supports the following data types.

Database Type	Supported Data Types
Oracle	BINARY DOUBLE, BINARY FLOAT CHAR, NCHAR CLOB, NCLOB DATE FLOAT NUMBER, NUMBER (p,s), NVARCHAR2, VARCHAR2 ROWID TIMESTAMP, TIMESTAMP WITH LOCAL TIMEZONE, TIMESTAMP WITH TIMEZONE
DB2	BIGINT CHAR, CLOB DATE, DECFLOAT, DECIMAL, DOUBLE FLOAT INTEGER LONGVAR NUMERIC REAL SMALLINT TIME, TIMESTAMP VARCHAR
SQL Server	BIGINT, BIT CHAR DATE, DATETIME, DATETIME2, DATETIMEOFFSET, DECIMAL FLOAT INT MONEY NCHAR, NTEXT, NUMERIC, NVARCHAR, NVARCHAR(MAX) REAL SMALLDATETIME, SMALLINT, SMALLMONEY TEXT, TIME, TINYINT VARCHAR, VARCHAR(MAX) XML
MySQL	BIGINT, BIGINT UNSIGNED CHAR DATE, DATETIME, DECIMAL, DECIMAL UNSIGNED, DOUBLE, DOUBLE UNSIGNED FLOAT, FLOAT UNSIGNED INTEGER, INTEGER UNSIGNED LONGTEXT MEDIUMINT, MEDIUMINT UNSIGNED, MEDIUMTEXT SMALLINT, SMALLINT UNSIGNED TEXT, TIME, TIMESTAMP, TINYINT, TINYINT UNSIGNED, TINYTEXT VARCHAR YEAR
Apache Spark	BIGINT, BOOLEAN DATE, DECIMAL, DOUBLE FLOAT INT SMALLINT, STRING TIMESTAMP, TINYINT VARCHAR
Teradata	BIGINT, BYTE, BYTEINT CHAR, CLOB DATE, DECIMAL, DOUBLE FLOAT INTEGER NUMERIC REAL SMALLINT TIME, TIMESTAMP VARCHAR