Essbase Studio uses JDBC interfaces to extract data types of relational columns. It makes the following association between the data types of relational columns and logical metadata elements.
Association with integer:
INTEGER
TINYINT
SMALLINT
BIT
Association with long:
BIGINT
Association with boolean:
BOOLEAN
Association with date:
DATE
Association with time:
TIME
Association with datetime:
TIMESTAMP
Association with double:
DOUBLE
FLOAT
REAL
DECIMAL
NUMERIC
Association with string:
CHAR
VARCHAR
NCHAR
NVARCHAR
LONGVARCHAR
CLOB
VARBINARY
Association with binary:
BINARY
BLOB
LONGVARBINARY
and other SQL data types that are not in the list above