SAP HANA Database Query

Use this activity to run the query SQL statements on SAP HANA Database.

General

The following table lists the configurations in the General tab of the SAP HANA Database Query activity:

Field Module Property Description
Name No Specify the name to be displayed as the label for the activity in the process.
HANA JDBC Resource Yes

Click to select a SAP HANA Database JDBC Connection shared resource.

If no matching SAP HANA Database JDBC Connection shared resource is found, click Create Shared Resource to create one. For more details, see Creating and Configuring the SAP HANA Database JDBC Connection Resource.

Entity No Click to select an entity.

The entities downloaded in selected SAP HANA Database JDBC Connection shared resource will be available for selection.

Maximum rows Yes The maximum number of rows to retrieve. To retrieve all rows, specify 0.

Default value: 100.

Description

In the Description tab enter a short description for the SAP HANA Database Query activity.

SQL Builder

The SQL Builder tab displays the metadata of the entity selected in the General tab.

Fields Editable Description
Field Name No Displays name of the column.
Data Type No Displays the data type of the column.
Primary Key No Displays if the column is a primary key.
Not Null No Displays if the column accepts null value.
Dimension No Displays the dimension of the column.
Selected Yes Displays the fields that must be part of the SELECT query of an SQL statement. By default, the Selected column is selected for all the fields.
Parameter Yes Displays the fields that must be part of the WHERE clause of a query SQL statement.

Input

All the fields in the SQL Builder tab that have Parameter column selected, will be part of the Input tab.

The Input tab displays the input schema of the activity as a tree structure. The information in the schema depends on the fields selected on the SQL Builder tab.
Note: It is not mandatory to provide values for fields on the input tab for SAP HANA Database Query activity. A default mapping will be displayed at the ActivityInput element when the activity is created for the first time. If the required symbol is visible, then right-click the ActivityInput element and click Show Check and Repair > Select ActivityInput field and click OK.

For more information about SAP HANA Database datatype mapping to XSD mapping, see SAP HANA Database Datatype Mapping to XSD Mapping.

Output

All the fields in the SQL Builder tab that have Selected column selected will be part of Output tab. Output of SAP HANA Database Query activity holds multiple records.

The Output tab displays the output schema of the activity as a tree structure. The output is read-only. The information in the schema depends on the fields selected on the SQL Builder tab.

Fault

The Fault tab lists exceptions that are thrown by this activity. This activity throws the following exceptions:
  • SapHanaDatabaseJdbcSQLException: Thrown when the error originates from the SAP HANA Database system.
  • SapHanaDatabaseJdbcPluginException: Thrown when the error originates from the plug-in.
Error Schema Element Datatype Description
msg string The error message returned by the plug-in
msgCode string The error code returned by the plug-in
For more information, see Error Codes.