Create a Target transformation in the Mapping Task wizard to write data to Eloqua. When you select an Eloqua REST connection for a Target transformation in a mapping, you can select an operation from the list of operations. When you want to write data that is in relational format to Eloqua, the Secure Agent converts the relational data to a hierarchical format before you write the data to Eloqua.
When you configure an Eloqua target, you can select Operations on the Target tab to display the list of operations. The Secure Agent creates target fields based on the request message structure of the operation you select on the Target tab.
When you write data to Eloqua, the Secure Agent includes all the input fields from the source, by default. You can exclude the incoming fields, if required. You can add multiple input sources to write data to Eloqua target object and define the primary and foreign key relationships between the input sources before you run the mapping. Each input source appears as separate group in the Field Mapping tab in the target transformation. You can define key relationships on the Field Mapping tab.
Field Mapping in a Target Transformation
You can map fields that are in a relational structure to the hierarchical structure used by an Eloqua target.
On the Field Mapping tab for the Target transformation, the fields in the Target Fields appear in hierarchical format. The target fields are determined by the request message structure of the operation you select for the Target transformation.
Each source object displays as a group in the Input Fields area. You can select fields in the Input Fields area to map the fields to the request. If the input fields include multiple input groups, map the groups to the corresponding nodes in the request. Be sure to map all of the fields that you require in the request.
The following image shows an example of mapped input fields from the source file with the Eloqua target in an operation to insert data:
