SAP HANA - Stored Procedure

Overview

This Snap executes a stored procedure in the database and writes any parameters or results to the output view.

This is a Write-type Snap.
Works in Ultra Tasks

Supported Accounts

SAP HANA Account

Prerequisites

None.

Limitations

This Snap does not support the INOUT parameter type.

Known issues

None.

Snap views


Type	Description	Examples of upstream and downstream Snaps
Input	This Snap allows at most one input view. If an input view is defined, then values from an incoming document can be used as input parameters to the stored procedure.	JSON Generator Mapper
Output	This Snap has exactly two document output views, one regular output view and one Result Set output view. Data output is dependent on SAP HANA SQL Script and SAP HANA JDBC version and capabilities - defined in the SAP HANA account. Therefore, it is recommended to verify the behavior of the particular versions by executing the Snap and checking the output view results.	Mapper JSON Formatter
Learn more about Error handling. Note: Database Write Snaps output all records of a batch (as configured in your account settings) to the error view if the write fails during batch processing.

Examples

Execute a stored procedure: Execute a stored procedure with parameters.

Snap settings

Note: Learn about the common controls in the Snap settings dialog.


Field/Field set	Description
Label `String`	Required. Specify a unique name for the Snap. Modify this to be more appropriate, especially if more than one of the same Snaps is in the pipeline. Default value: SAP HANA - Stored Procedure Example: Execute employee procedure
Schema Name `String/Expression/ Suggestion`	The schema name where the procedure resides. The property is suggestible and will return all schemas of the DB. Note: The values can be passed using the pipeline parameters but not the upstream parameter. Default value: [None] Example: dbo
Stored Procedure Name `String/Expression/ Suggestion`	Required. Stored procedure to execute. The property is suggestible and will return all procedures of the DB. If a schema is defined, then it will return all procedures of that schema. Default value: [None] Example: addSeventeen
Parameter Values `String/Expression`	Select the input parameter values for the stored procedure. If you define parameter values, you must do so in the same order as they appear in the stored procedure definition. Default value: [None] Example: Suppose there is a stored procedure named createGreeting. It has three parameters p1, p2 and p3. p1 and p2 are input parameters of type VARCHAR2. Then there has to be two string values provided. The first value goes to p1 and the second to p2. Tip: If you do not provide any parameters in the Snap, you can still view the required input parameters in the Target Schema of the upstream Mapper Snap. The parameters are dynamically populated based on the column keys of the stored procedure; you can map the parameters and pass them as an input to the Stored Procedure Snap.
Pass through `Checkbox`	If selected, the input document will be passed through to the output views under the key 'original'. The document will be passed to the Parameter output view, and it will also be passed to the Result Set output view if there is output sent from this view. Note: This property applies only to the Execute Snaps with SELECT statement or the Select Snaps. Default status: Deselected
Snap execution `Dropdown list`	Choose one of the three modes in which the Snap executes. Available options are: Validate & Execute: Performs limited execution of the Snap and generates a data preview during pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during pipeline runtime. Execute only: Performs full execution of the Snap during pipeline execution without generating preview data. Disabled: Disables the Snap and, by extension, its downstream Snaps. Default value: Execute only

Troubleshooting

None.