To write data to an OData Consumer service, configure an OData Consumer resource object as the Target transformation in a mapping.
Specify the name and description of the OData Consumer target. Configure the target and advanced properties for the target object.
The following table describes the source properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the target connection.
Source Type
Target type. Select Single Object for a single target object.
Object
Target object for the mapping.
Operation
Select Insert for insert operation. Update, Delete, and Upsert are not applicable.
The following table describes the advanced source properties that you can configure in a Target transformation:
Advanced Source Property
Description
Data Serialization Format
The format of data that is transferred over the network.
Specify the property to override the Data Serialization Format value you specified in the OData Consumer connection.
Select one of the following options:
- Connection Default
- JSON
When you specify Connection/Default, the Secure Agent uses the Data Serialization Format value you specified in the OData Consumer connection.
ATOM/XML is not applicable.
Default is Connection Default.
Update Mode
Not applicable.
Use Custom Headers
Select the check box to use custom headers during write operation. Map the custom header port when you want to use custom headers.
By default, the Use Custom Headers check box is not selected.
Success File Directory
Directory for the success log files. Specify a directory path that is available on each agent machine in the runtime environment. By default, the agent writes the success log files to the following directory:
Directory for the error log files. Specify a directory path that is available on each agent machine in the runtime environment. By default, the agent writes the error log files to the following directory:
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.
Mapping with Custom Headers Example
You can use custom headers during write operation. Map the custom header port when you want to use custom headers.
Use the following format to specify a custom header field:
name1 "=" value1 ";" name2 "=" value2
Perform the following steps to map flat files that use custom headers:
1 Create a flat file that contains custom headers. For example, create a flat file named A with custom headers.
The following image shows a flat file with custom header defined:
2Create a flat file that contains data to be written to OData Consumer. For example, create a flat file named B, that contains data to be written to OData Consumer.
The following image shows a flat file that contains data to be written to OData Consumer:
3Place the flat file A and flat file B in a folder.
4In Informatica Intelligent Cloud Services, go to Data Integration tab and click New.
5Under Mappings, click Create.
6Select the flat file A from the flat file connection.
7Under Formatting Options tab, specify pipe | as the delimiter.
8Select the flat file B from the flat file connection.
9Under Formatting Options tab, specify comma , as the delimiter.
10Select Joiner from the Design tab.
11Join the flat file A and the flat file B using a join condition. For example, the join condition is nos=no. The flat files used to define a join condition are known as Master and Detail. For example, flat file A is Master, and flat file B is Detail.
The following image shows the Master and Detail joined by the = operator:
12Select an OData Consumer connection and select the target object to which you want to write the custom headers. For example, airlines is the target object.
13In the Advanced section in target properties, select Use Custom Headers check box.
14Select Field Mapping and map the joiner output fields to the target object fields.
