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.

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 Insert 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 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 "-"

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 "-"

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.