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.

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.

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 "-"
Note: Do not click Add row and Delete link.

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.