When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. See below for a list of the different data types that Spotfire supports and the applied data type mappings when working with a SAP HANA database.
SAP HANA Data Type |
Spotfire Data Type |
BINARY |
Binary |
BINTEXT |
Binary |
BLOB |
Binary |
VARBINARY |
Binary |
BOOLEAN |
Boolean/Bool |
SMALLDECIMAL |
Currency/Decimal |
DATE |
Date |
SECONDDATE |
DateTime |
TIMESTAMP |
DateTime |
INTEGER |
Integer/Int |
SMALLINT |
Integer/Int |
TINYINT |
Integer/Int |
BIGINT |
LongInteger/Long |
DOUBLE |
Real/Double |
FLOAT |
SingleReal/Float |
REAL |
SingleReal/Float |
ALPHANUM |
String |
CHAR |
String |
CLOB |
String |
NCHAR |
String |
NCLOB |
String |
NVARCHAR |
String |
SHORTTEXT |
String |
STRING |
String |
TEXT |
String |
VARCHAR |
String |
TIME |
Time |
DECIMAL(p, s) / DEC |
When p = 0 and s = 0: Currency/Decimal When p <= 9 and s = 0: Integer When 9 < p <= 18 and s = 0: LongInteger When p <= 15 or p >= 29: Real/Double Else: Currency/Decimal |
Any other data types are not supported.