When you configure a Source transformation, select the Eloqua REST connection and choose an operation to represent an Eloqua source. You can parameterize an Eloqua REST connection.
When you select an Eloqua REST connection for a source, you can select an operation from the list of operations. You can use the request message template to configure the request message in a JSON format. You can parameterize the input values in the request message. Configure the advanced properties to set the tracing level and the cache size for the web service response.
You can view the response structure in the field mapping. When you map the elements from the response structure to the output fields, the Secure Agent creates the output groups, along with the primary and foreign keys for the field names. When you deploy the mapping in a mapping task and run the task, the Secure Agent reads the data from Eloqua.
Source Transformation Properties
You can use one or more source transformations in a mapping.
When you select a source, the Properties panel displays the following information:
•General. Configure the name and a description for the source.
•Source. Select the connection and the operation, configure the request message in the request options, and configure the advanced source properties.
•Field Mapping. Map elements of the response structure with the output fields.
•Fields. Edit the metadata source field metadata that you want to use in the mapping.
Advanced Source Properties
In a mapping, you can configure a source to represent an Eloqua REST source. For Eloqua REST connections used in Mapping tasks, you can configure advanced properties on the Source page of the Mapping Task wizard.
Property
Description
Tracing Level
Amount of detail that appears in the log.
Use the following tracing levels:
- Terse
- Normal
- Verbose Initialization
- Verbose data
Default is normal.
Cache Size for Web Service Response (KB)
Not Applicable.
Note: Do not change the value of this property unless Informatica Global Customer Support instructs you to do so.
Source Transformation Mapping Example
To read data from Eloqua and write to a flat file using Eloqua REST connection, perform the following tasks:
1Create an Eloqua REST connection to read data from an Eloqua source.
2Create a flat file connection to write data to the flat file.
3Create a Eloqua REST mapping.
4Add a Source transformation. Specify a name and description in the general properties.
5On the Source tab, perform the following steps:
aIn the Connection field, select the configured Eloqua REST connection to connect to Eloqua.
bIn the Operation field, select the required operation.
The following image shows the Operation field:
cIn the Request Options section, configure the request message in the following JSON format, specify the attributes in the message, and validate the message:
{ "id" : 0, "depth" : "", "viewId" : 0 }
You can hide the optional elements to see the mandatory elements required for the request message.
dIn the Advanced Properties section, set the tracing level to Normal, and use the default cache size of 1024 MB.
6On the Field Mapping tab, select the elements in the response structure that you want to map to the output fields.
The following image shows the response structure on the left pane in a hierarchical format and the output groups on the right pane in a relational format:
7Add a Target transformation to include the flat file object and add the flat file connection. Specify name and description in the general properties.
8Draw a link to connect the Eloqua REST source to the flat file.
The following image shows the Eloqua REST mapping:
9On the Field Mapping tab, select the automatic field map option.
