SAP HANA DB Query

You can use this activity to run the query SQL statements on SAP HANA Database. This activity returns information in the form of rows.

Configuration

This tab has the following fields.

Field	Description
SAP HANA Database Connection	Name of the connection which is used to connect the SAP HANA Database. If you have created multiple SAP HANA Database connection, select the connection from the drop-down list.
Entity Type	Select the type of the entity from the drop-down list. Note: For this release, only TABLE is supported as the entity type.
Entity Name	Enter the name of the entity you want to use for SAP HANA DB Query activity.

Field

Description

SAP HANA Database Connection

Name of the connection which is used to connect the SAP HANA Database.

If you have created multiple SAP HANA Database connection, select the connection from the drop-down list.

Entity Type

Select the type of the entity from the drop-down list.

Note: For this release, only TABLE is supported as the entity type.

Entity Name

Enter the name of the entity you want to use for SAP HANA DB Query activity.

Input Settings

The Input Settings tab has the following fields:

Field	Description
Entity Metadata	Displays the metadata based on the SAP HANA Database connection details, catalog, and entity name. The Selected column refers to the fields that must be part of the select query of an SQL statement. By default, Selected column is selected for all the fields. The Parameter column refers to the fields that must be part of the 'where clause' of a query SQL statement. Note: You cannot edit the fields that consist of unsupported datatypes. The Dimension column of such fields is displayed as "-"

Field

Description

Entity Metadata

Displays the metadata based on the SAP HANA Database connection details, catalog, and entity name.

The Selected column refers to the fields that must be part of the select query of an SQL statement. By default, Selected column is selected for all the fields. The Parameter column refers to the fields that must be part of the 'where clause' of a query SQL statement.

Note: You cannot edit the fields that consist of unsupported datatypes. The Dimension column of such fields is displayed as "-"

Input

The Input tab contains the input schema. On the Input Settings tab, the fields for which Parameter column is selected are available in the schema. You can either enter the input manually or map them to a field from the output of a preceding activity in the flow using the Mapper.

Note: Only AND operation is supported between the parameters in 'where clause'.

Note: For information about SAP HANA Database data types and corresponding Flogo data types, refer to the Supported SAP HANA Datatypes topic.

Output

The Output tab displays the output schema of the activity as a tree structure. The output is read-only. On the Input Settings tab, the fields for which Selected column is selected are available in the schema. The properties that are displayed in the schema correspond to the output of this activity and can be used as input by subsequent activities in the flow.

Note: The output of SAP HANA Database Query activity for any boolean data type field is 1/0 instead of true/false respectively.

Iterator

Use the Iterator tab to iterate a certain piece of logic multiple times. If you leave this tab blank, the activity is executed only once. For more information about Iterator, see "Using the Iterator in an Activity" in the TIBCO Flogo® apps documentation.