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

Oracle CRM Cloud V1 Source Transformation in Mappings

When you configure a Source transformation, select an Oracle CRM Cloud V1 connection and choose an Oracle CRM Cloud operation to represent an Oracle CRM Cloud V1 source.

Source Transformation Properties

You can use one or more Source transformations in a mapping.
Use to configure the name and a description for the source.
Use to select the connection and operation. You can configure the request options and advanced source properties.
Field Mapping
Use to map elements of the response structure with the output fields.
Use to edit the source field metadata that you want to use in the mapping.

Oracle CRM Cloud V1 Advanced Source Properties in Mappings

In a mapping, you can configure or create a Source transformation and configure the advanced properties in the Source page of the Mapping Task wizard.
The following table describes the advanced properties that you can configure in a Source transformation:
Tracing Level
Amount of detail that appears in the log for the Source transformation. Use the following tracing levels:
  • - Terse
  • - Normal
  • - Verbose Initialization
  • - Verbose
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

You can map an Oracle CRM Cloud V1 source to a target and use the mapping to perform a mapping task.
To read and download the data from the Oracle CRM Cloud application, perform the following tasks:
    1. In Data Integration, click New > Mapping > Create.
    The New Mapping dialog box appears.
    2. Enter a name and description for the mapping.
    3. On the Source tab, perform the following steps:
    1. a. In the general properties, specify a name and description.
    2. The following image shows a sample of the Oracle CRM Cloud V1 mapping:
    3. b. In the Connection field, select the configured Oracle CRM Cloud V1 connection to connect to the Oracle CRM Cloud application.
    4. c. In the Operation field, select the required object in the Package Explorer section and select the required operation.
    5. Note: When you select an object in the Package Explorer section, all the read and write operations appear in the operation selection section. You must select the read related operations to read data from an Oracle CRM Cloud V1 source.
      The following image shows all the list of the operations:
    6. d. In the Request Options section, click Configure to configure the request message.
    7. Specify the request message and attributes in the JSON format. Request messages are different for each of the objects and you can configure the request message if you want to filter the data that you want to read.
      The following example shows a sample request message for the Actions object:
      "expand" : " ",
      "fields" : " ",
      "onlyData" : " ",
      "dependency" : " ",
      "limit" : 0,
      "offset" : 0,
      "totalResults" : " ",
      "q" : " ",
      "orderBy" : " ",
      "finder" : " "
      Note: In the request message, you can provide the maximum value of the Limit property as 499. The default value is 25.
    8. e. In the Advanced Properties section, you can set the tracing level to normal and use the default cache size of 1024.
    4. On the Field Mapping tab, you can select the elements in the response structure that you want to map to the output fields.
    Select the check box and expand the option. Select Map All Decendants > Output Group to choose the source from where you want to read.
    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:
    5. On the Target transformations, specify the target connection, target type, object, and operation for the target transformations.
    6. Map the source and target.
    7. Click Save and Run the mapping.
    8. In Data Integration, click New > Task.
    9. Click Mapping Task > Create and select the mapping for the task.
    The following image shows the Mapping Task wizard with the applied mapping: