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

OData targets in mappings

To write data to an OData service, configure an OData resource object as the Target transformation in a mapping.
Specify the name and description of the OData target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the target connection.
Target Type
Target type. Select one of the following target types:
  • - Single Object
  • - Parameter. Select Parameter to define the target type when you configure the task.
Object
Name of the target object.
Operation
Target operation. Select one of the following operations:
  • - Insert
  • - Update
  • - Upsert
  • - Delete
  • - Data Driven. Configure an expression to specify an update strategy based on the data. You can use one of the following constants in an expression:
    • - DD_INSERT
    • - DD_UPDATE
    • - DD_REJECT
    • - DD_DELETE
Note: If you use the Data Driven operation, you cannot upsert.
Truncate Target
Truncates the target before loading data.
The following table describes the advanced target properties that you can configure in a Target transformation:
Advanced Property
Description
Primary Key Override
Column names that you want to use as the primary key. Use commas to separate multiple column names.
Success File Directory
Directory for the success file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Data Integration writes the success file to the following directory: <Secure Agent installation directory>/apps/Data_Integration_Server/data/success
Error File Directory
Directory for the error file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Data Integration writes the error file to the following directory: <Secure Agent installation directory>/apps/Data_Integration_Server/data/error
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.