The DTS SAP Hana Connector supports remote calls for any SAP Hana stored procedures and functions, scalar-valued as well as table-valued.
DTS Naming
DTS Name |
<proc_or_func_name> |
DTS Key |
<schema_name>.<proc_or_func_name> |
Arguments and Results
▪Table type arguments to functions and procedures, as well as results of table-valued functions are fully supported for remote calling
oThe table arguments are always passed through DTS as arrays of custom objects, each object representing a row in the input table
oThe result of a table-valued function is always a DTS stream
See Streams
▪SAP Hana does not have a way of representing a single custom object, other than a table with a single row, so that extends to DTS, where they will become arrays with a single element.
For argument and result native and user type mappings, please see Types.
Metadata
The connector is also capable of extracting metadata regarding the arguments and results of a procedure or function:
▪DATA_TYPE_NAME
▪LENGTH
▪SCALE
▪POSITION
▪PARAMETER_TYPE
▪TABLE_TYPE
▪HAS_DEFAULT_VALUE
▪IS_NULLABLE
Standard functionality only makes use of DATA_TYPE_NAME, POSITION, PARAMETER_TYPE and TABLE_TYPE, but the other items are available for extension in DTS descriptor objects.