SAP HANA DB Insert

You can use this activity to run the insert SQL statements on SAP HANA Database. It allows you to insert multiple rows in the database. The transaction commit is done only when all insert statements are successful whereas it rolls back, if any of the insert statements fail. This activity returns the information in the form of total rows affected.

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 Insert 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 Parameter column refers to the fields that must be part of insert SQL statement. By default, the Parameter column is selected for all the fields.

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 will be 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: 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. The output schema contains rowsAffected field which displays the total number of rows affected after the activity is run. 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.

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.