Oracle CRM Cloud V1 Connector > Mappings and Mapping Tasks with Oracle CRM Cloud V1 Connector > Oracle CRM Cloud V1 Midstream Transformation in Mappings
  

Oracle CRM Cloud V1 Midstream Transformation in Mappings

Before you configure a midstream transformation, you must create a business service. Select an Oracle CRM Cloud V1 connection and choose an Oracle CRM Cloud 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 Oracle CRM Cloud 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.

Oracle CRM Cloud V1 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 Oracle CRM Cloud V1 source and to write the data to a flat file, perform the following tasks:
    1. Create an Oracle CRM Cloud V1 connection to read data from an Oracle CRM Cloud V1 source.
    2. In 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 Oracle CRM Cloud V1 connection and an operation:
    3. On the Web Services transformation, specify a name and description in the general properties.
    The following image shows the source, web service, and target in the Oracle CRM Cloud V1 mapping:
    4. On the Web Service tab, select the business service and the operation that you configured.
    The following image shows the configured web service:
    5. On 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:
    6. On 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 source details fields that you want to write to the target file:
    7. On the Advanced tab, you can 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.
    8. If required, map the incoming fields to the flat file fields.
    The following image shows the mapped fields between the source field and the target field:
    9. Click Task Wizards > Mapping Task, and select the mapping for the task.
    10. When you save and run the mapping, the Secure Agent reads the data that you map on the Request Mapping tab from the Oracle CRM Cloud application and writes the data to the corresponding flat files.