SAP HANA Database Insert
Use this activity to run the insert SQL statements on SAP HANA Database. You can insert multiple rows in the database in batches. Error in one batch does not stop the execution of the subsequent batch. The failure record of a batch depends on the behavior of the underlying HANA JDBC driver. If a batch fails to insert one or more records, the detailed message is displayed in logs including the batch number, reason of failure, and rows that failed to insert. This activity returns the information in the form of total rows attempted and total rows affected.
General
The following table lists the configurations in the General tab of the SAP HANA Database Insert 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
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
|
| Batch size | Yes |
All incoming messages to be inserted are stored until this size is reached. Then, a bulk insert operation is performed on the selected entity. The default value is 1000. |
to select a SAP HANA Database JDBC Connection shared resource.
Description
In the Description tab, you can enter a short description for the SAP HANA Database Insert 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. |
| Values | Yes | Displays the fields that must be part of the VALUES clause for an insert SQL statement.
By default, Values column is selected for all the fields. |
Input
All the fields in the SQL Builder tab that have Values column checked, will be part of 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. You must enter information for any mandatory fields
For more information about SAP HANA Database datatype mapping to XSD mapping, see SAP HANA Database Datatype Mapping to XSD Mapping.
Output
The Output tab displays the rowsAttempted and rowsAffected fields.
The rowsAttempted field holds the count of number of rows that were attempted by SAP HANA Database Insert activity and rowsAffected field holds the count of number of rows affected after the SAP HANA Database Insert activity is invoked. The difference between these two is the number of rows that failed to insert.
The Output tab displays the output schema of the activity as a tree structure. The output is read-only.
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 |