SAP OData V2 Connector > Mappings and mapping tasks with SAP OData V2 Connector > SAP OData V2 targets in mappings
  

SAP OData V2 targets in mappings

To write data to entities that are exposed and accessible through OData V2-compliant applications in SAP, configure an SAP OData V2 object as a target in a mapping.
Specify the name and description of the SAP OData V2 target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure for an SAP OData V2 target:
Property
Description
Connection
Name of the target connection.
You can select an existing connection or create a new connection for the target connection property.
Target Type
Type of the target object.
Select Single Object as the target type.
Default is Single Object.
Object
Name of the SAP OData V2 target object that you want to create.
Select the target object for a single target. You can also select an existing object from the list.
Operation
Type of the target operation.
Select one of the following operations from the list:
  • - Insert
  • - Update
  • - Upsert (Update or Insert)
  • - Delete
  • - Data Driven
Update Columns
Select the unique key column as the condition field for the update, upsert, delete, or data driven operation in an SAP OData V2 target.
Data Driven Condition
Enables you to define expressions that flag rows for an insert, update, reject, or delete operation.
This property appears only when the operation type is Data Driven.
You can use one of the following constants in an expression:
  • - DD_INSERT
  • - DD_UPDATE
  • - DD_REJECT
  • - DD_DELETE
The following table describes the advanced target properties that you can configure for an SAP OData V2 target:
Property
Description
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the mapping task forwards rejected rows to the next transformation.
If you select the Forward Rejected Rows option, the agent flags the rows for reject and writes them to the reject file.
If you do not select the Forward Rejected Rows option, the agent drops the rejected rows and writes them to the session log file. The agent does not write the rejected rows to the reject file.
Cache Size for Web Service Request (KB)
The memory in KB available for the web service request.
If the target contains many rows or columns, you might want to increase the cache size.
Default is 1024.
Transaction Commit Control
Control to commit or roll back transactions based on the set of rows that pass through the transformation.
Use the transaction commit control if you have a large amount of data and you want to control how it is processed.
Transformation Scope
The method in which the mapping applies the transformation logic to incoming data.
Select one of the following transformation scopes from the list:
  • - All Input. Processes data from a source that is not real-time.
  • - Transaction. Processes data from a real-time source.
Default is All Input.
You can connect only one effective real-time source to a real-time target.
Optimize transformation
Select to improve performance for processing records at run time.
Default is disabled.