When you are setting up a connection against an external data source, Spotfire has to map the data types in the data source against data types in Spotfire. See below for a list of the different data type mappings applicable when working against an Oracle MySQL database.
Oracle MySQL Database Type |
Spotfire Data Type |
Supported |
INT |
Integer |
Yes |
MEDIUMINT |
Integer |
Yes |
SMALLINT |
Integer |
Yes |
TINYINT |
Integer |
Yes |
YEAR |
Integer |
Yes |
FLOAT |
SingleReal |
Yes |
DOUBLE |
Real |
Yes |
BIGINT |
LongInteger |
Yes |
DECIMAL(p, s) |
When p <= 9 and
s = 0: Integer |
Yes |
BIT |
Boolean |
Yes |
CHAR |
String |
Yes |
NCHAR |
String |
Yes |
TINYTEXT |
String |
Yes |
MEDIUMTEXT |
String |
Yes |
LONGTEXT |
String |
Yes |
VARCHAR |
String |
Yes |
NVARCHAR |
String |
Yes |
ENUM |
String |
Yes |
SET |
String |
Yes |
VARBINARY |
String |
Yes |
DATE |
Date |
Yes |
TIME |
TimeSpan |
Yes |
TIMESTAMP |
DateTime |
Yes |
DATETIME |
DateTime |
Yes |
BLOB |
Binary |
Yes |
MEDIUMBLOB |
Binary |
Yes |
LONGBLOB |
Binary |
Yes |
BINARY |
Binary |
Yes |
TINYBLOB |
Binary |
Yes |
Any other data types are not supported.
See also:
Adding Data Connections to an Analysis
Details on Oracle MySQL Connection