SAP HANA Connector > Mappings and mapping tasks with 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 a target in a mapping.
Specify the name and description of the SAP HANA target. Configure the target and advanced properties for the target object.
You can parameterize the SAP HANA target connection at run time with values specified in a parameter file.
The following table describes the SAP HANA target properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the target connection.
You can select an existing connection, create a new connection, or define parameter values for the target connection property.
To overwrite the target connection properties at run time, select the Allow parameter to be overridden at run time option.
Object Type
Type of the target object.
Select one of the following object types from the list:
  • - Single Object
  • - Parameter
Note: Multiple objects target type is not applicable.
Default is Single Object.
Object
The target object for the task.
You can select an existing target object or create an SAP HANA target at run time with an object name that you specify.
Operation
The target operation.
You can choose from the following operations:
  • - Insert
  • - Update
  • - Upsert
  • - Delete
  • - Data Driven
Default is Insert.
Truncate target
The Secure Agent truncates the target before writing the data.
The following table describes the SAP HANA target advanced properties that you can configure in a Target transformation:
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.
Update Override
The SQL statement that overrides the default query generated by the specified target object used to write data to the SAP HANA target.
Schema Name
Overrides the schema name specified in the connection.
Table Name
Overrides the table name of the imported SAP HANA target table.
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.