SAP HANA Connector

SAP HANA Connector

SAP HANA targets in mappings

SAP HANA targets in mappings

To write data to an SAP HANA database, configure an SAP HANA object as the Target transformation in a mapping.
Specify the name and description of the SAP HANA target. Configure the target and advanced properties for the source object.
The following table describes the source properties that you can configure for an SAP HANA source:
Property
Description
Connection
The name of the SAP HANA target connection.
Target Type
The type of the SAP HANA target object available.
You can choose from the following target types:
  • Single Object
  • Parameter
Multiple objects target type is not applicable.
Object
The name of the SAP HANA target object.
You can select an existing target object or create an SAP HANA target at runtime with an object name that you specify.
Operation
The target operation.
You can choose from the following operations:
  • Insert
  • Update
  • Upsert
  • Delete
  • Data Driven
Truncate target
The Secure Agent truncates the target before writing the data.
When you configure a mapping, you can configure the advanced target properties. The following table describes the SAP HANA advanced target properties:
Property
Description
Pre SQL
The SQL statement that you want to run before reading data from the source.
Post SQL
The SQL statement that you want to run after writing data into the target.
Success File Directory
Not applicable.
Error File Directory
Not applicable.
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the agent forwards rejected rows to the next transformation.