SAP HANA Connector

SAP HANA Connector

SAP HANA and transformation data types

SAP HANA and transformation data types

SAP HANA data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table compares SAP HANA data types and transformation data types:
SAP HANA Datatype
Range
Transformation Datatype
Range
Alphanum
Precision 1 to 127
Nstring
1 to 104,857,600 characters
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
Binary
Used to store bytes of binary data
Binary
1 to 104,857,600 bytes
Bintext
-
String
Precision 32000
Blob
Up to 2 GB
Binary
1 to 104,857,600 bytes
Boolean
True/False
Integer
Boolean (True/False) values, precision 10
Clob
Up to 2 GB
String
1 to 104,857,600 characters
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Precision 10, scale 0
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Decimal (precision, scale) or Dec (p, s)
Precision 1 to 34
Decimal
Precision 1 to 28, scale 0 to 28
For transformations that support precision up to 38 digits, the precision is 1 to 38 digits, and the scale is 0 to 38.
For transformations that support precision up to 28 digits, the precision is 1 to 28 digits, and the scale is 0 to 28.
If you specify the precision greater than the maximum number of digits, the Secure Agent converts decimal values to double in high precision mode.
Double
Specifies a single-precision 64-bit floating-point number
Double
Precision 15
Float
Precision 1 to 53
Double
Precision 15
Integer
-2,147,483,648 to 2,147,483,647
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
NClob
Up to 2 GB
String
1 to 104,857,600 characters
Nvarchar
Precision 1 to 5000
String
1 to 104,857,600 characters
Real
Specifies a single-precision 32-bit floating-point number
Double
Precision 7, scale 0
Seconddate
0001-01-01 00:00:01 to 9999-12-31 24:00:00
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Shorttext
Specifies a variable-length character string, which supports text search and string search features
String
1 to 104,857,600 characters
Smalldecimal
Precision 1 to 16
Decimal
Precision 1 to 28, scale 0 to 28
Smallint
-32,768 to 32,767
Integer
Precision 5, scale 0
Text
Specifies a variable-length character string, which supports text search features
String
1 to 104,857,600 characters
Time
24-hour time period
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Timestamp
0001-01-01 00:00:00.0000000 to 9999-12-31 23:59:59.9999999
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Tinyint
0 to 255
Integer
Precision 5, scale 0
Varchar
Precision 1 to 5000
String
1 to 104,857,600 characters
Varbinary
1 to 5000 bytes
Binary
1 to 104,857,600 bytes