When you select an Eloqua REST connection for a target, you can select an operation from the list of operations.
You can add multiple input groups into the Eloqua REST target and define the primary and foreign key relationships between the multiple input groups before the mapping.
Target Transformation Properties
You can configure target properties, such as target details and advanced properties, based on the connection type you select. Configure target transformation properties on the Target tab of the Properties panel.
When you select a target, the Properties panel displays the following areas and information:
•General. Defines the transformation name and a description.
•Incoming Fields. Includes the field rules that define the data written to the target. Allows a preview of target fields.
•Target. Defines the target connection, operation, and advanced options.
•Target Fields. Not applicable for Web Service targets.
•Field Mapping. Defines the field mappings from the upstream transformation to the target.
Advanced Target Properties
In a mapping, you can configure a target to represent an Eloqua REST target. For Eloqua REST target connections used in mapping tasks, you can configure advanced properties in the Targets page of the Mapping Task wizard.
The following table describes the advanced properties that you can configure in a Target transformation:
Property
Description
Cache Size for Web Service Request (KB)
Not Applicable.
Note: Do not change the value of this property unless Informatica Global Customer Support instructs you to do so.
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.
Input settings properties
You can enable Sorted Input under Input Settings. Sorted Input indicates that input data is presorted. Default is disabled.
Enable sorted input for better performance.
Note: When Sorted Input is enabled and the input is not sorted, the Secure Agent does not process input and the mapping fails.
Target Transformation Mapping Example
To write data to Eloqua from a flat file using Eloqua REST connection, perform the following tasks:
1Create a flat file connection to read data from the flat file.
2Create an Eloqua REST connection to write data to Eloqua.
3Create a Eloqua REST mapping.
4Add a Source transformation to include the flat file object and add the flat file connection.
5Add a Target transformation to write data to Eloqua.
Perform the following tasks on the Target tab:
aIn the Connection field, select the Eloqua REST connection to connect to Eloqua.
bIn the Operation field, select the required operation.
The following image shows the Operation field:
cIn the Advanced Properties section, set the cache size and the transaction commit interval.
6On the Field Mapping tab, select the input elements to map to the target fields.
The following image shows all the mapped fields between the input file and the Eloqua REST target:
7Save and run the mapping in a mapping task.
The following image shows the Eloqua REST mapping:
