Before you configure a midstream transformation, you must create a business service. Select an Eloqua REST connection and choose an Eloqua REST operation when you create a business service.
Midstream Transformation Properties
When you configure the midstream transformation, select the business service and the operation on the Web Service tab.
When you select a midstream transformation, the Properties panel displays the following areas and information:
General
Use to configure the name and a description for the transformation.
Incoming Fields
Includes the field rules that define the data that you read from the source. Allows a preview of the source fields.
Web Service
Specifies the business service and the operation that you want to perform in an Eloqua application.
Request Mapping
Maps the incoming fields from source file to elements in request structure.
Response Mapping
Maps the selected elements from the response structure with the output fields. You can view the response structure on the Response Mapping tab. 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.
Output Fields
Displays the fields included in the mapping.
Advanced
The properties required to configure a midstream transformation.
Eloqua REST Advanced Midstream Properties in Mappings
The following table describes the advanced properties that you can configure for a midstream transformation:
Property
Description
Cache Size for Web Service Request (KB)
Memory available for the web service request. If the request is more than 100 KB, you can increase the cache size.
Default is 100 KB.
Cache Size for Web Service Response (KB)
Memory available for the web service response. If the web service response contains many rows or columns, you might want to increase the cache size.
Default is 100 KB.
Allow Input Flush
Not applicable.
Transaction Commit Control
Not applicable.
Midstream Transformation Mapping Example
To read data from an Eloqua REST source and to write the data to a flat file, perform the following tasks:
1 Create an Eloqua REST connection to read data from an Eloqua REST source.
2In Data Integration, click New > Components > Business Sevice.
The Business Sevice Details dialog box appears.
The following image shows the configured business service that associates an Eloqua REST connection and an operation:
3Add a Web Services transformation. Specify a name and description in the general properties.
The following image shows the source, web service, and target in the Eloqua REST mapping:
4On the Web Service tab, select the business service and the operation that you configured.
The following image shows the configured web service:
5On the Request Mapping tab, map the incoming fields from the source to the elements of Request Structure to form a web service request:
The following image shows the fields that you map:
6On the Response Mapping tab, select the source details fields that you want to write to the target file on the Response Structure.
The following image shows the fields that you map:
7On the Advanced tab, specify the cache size details.
The fields that you select from the Response Structure of the Web Service transformation appear as incoming fields for the target object.
8If required, map the incoming fields to the flat file fields.
The following image shows the mapped fields in the Field Mapping tab:
9Click Task Wizards > Mapping Task, and select the mapping for the task.
10When you save and run the mapping, the Secure Agent reads the data that you map on the Request Mapping tab from Eloqua application and writes the data to the corresponding flat files.
