Supported data types
The following table shows the supported SAP HANA source data types and their default mapping to Qlik Talend Data Integration data types.
For information on how to view the data type that is mapped in the target, see the section for the target connector you are using.
| SAP HANA data types | Qlik Talend Data Integration data types |
|---|---|
|
DATE |
DATE |
|
TIME |
TIME |
|
SECONDDATE |
DATETIME |
|
TIMESTAMP |
DATETIME |
|
TINYINT |
UINT1 |
|
SMALLINT |
INT2 |
|
INTEGER |
INT4 |
|
BIGINT |
INT8 |
|
DECIMAL (p,s) |
NUMERIC |
|
DECIMAL |
STRING |
|
SMALLDECIMAL |
STRING |
|
REAL |
REAL4 |
|
DOUBLE |
REAL8 |
| VARCHAR | STRING |
| NVARCHAR | WSTRING |
|
ALPHANUM |
STRING |
|
SHORTTEXT |
WSTRING |
|
VARBINARY |
BYTES |
|
BLOB |
BLOB |
|
CLOB |
CLOB |
|
NCLOB |
NCLOB |
|
TEXT |
NCLOB |
|
BOOLEAN |
UINT1 |
Unsupported data types
The following data types are not supported:
- ARRAY
- ST_GEOMETRY
- ST_POINT