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 type mappings applicable when working with an SAP HANA database.
SAP HANA Database Type |
Spotfire Data Type |
Supported |
TINYINT |
Integer/Int |
Yes |
SMALLINT |
Integer/Int |
Yes |
INTEGER |
Integer/Int |
Yes |
BIGINT |
LongInteger/Long |
Yes |
FLOAT |
SingleReal/Float |
Yes |
REAL |
SingleReal/Float |
Yes |
DOUBLE |
Real/Double |
Yes |
DECIMAL(p, s) / DEC |
When p
<= 9 and s = 0: Integer |
Yes |
SMALLDECIMAL |
When p <= 9 and s
= 0: Integer |
Yes |
VARBINARY |
Binary |
Yes |
TEXT |
Binary |
Yes |
ALPHANUM |
String |
Yes |
SHORTTEXT |
String |
Yes |
VARCHAR |
String |
Yes |
NVARCHAR |
String |
Yes |
SECONDDATE |
DateTime |
Yes |
TIMESTAMP |
DateTime |
Yes |
DATE |
Date |
Yes |
TIME |
Time |
Yes |
BOOLEAN |
Boolean/Bool |
Yes |
STRING |
String |
Yes |
BLOB |
|
No |
CLOB |
|
No |
NCLOB |
|
No |
See also:
Details on SAP HANA Connection