Oracle HCM Cloud V1 Connector

Oracle HCM Cloud V1 Connector

Source Transformation Mapping Example

Source Transformation Mapping Example

You can map an Oracle HCM Cloud V1 source to a target and use the mapping to perform a
mapping
task.
To read data from an Oracle HCM Cloud and write to a flat file, 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 transformation, specify a name and description in the general properties.
    The following image shows a simple Oracle HCM Cloud V1 reader mapping:
  4. On the
    Source
    tab, perform the following steps to configure the source properties:
    1. In the
      Connection
      field, select the configured Oracle HCM Cloud V1 connection to connect to Oracle HCM Cloud application.
    2. In the
      Operation
      field, select the required object in the
      Package Explorer
      section and select the required operation.
      The following image shows the list of the read operations:
    3. In the
      Request Options
      section, click
      Configure
      to configure the request message. For more information about configuring the request message, see Configuring Request Message.
    4. In the
      Advanced Properties
      section, set the tracing level to normal, and use the default cache size of 1024.
  5. On 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:
  6. On the Target transformations, specify the target connection, target type, object, and operation for the target transformations.
  7. Map the source and target.
  8. Click
    Save and Run
    the mapping.
  9. In
    Data Integration
    , click
    New
    Task
    .
  10. Click
    Mapping Task
    Create
    and select the mapping for the task.
    The following image shows the
    Mapping
    Task wizard with the applied mapping:
In
Monitor
, you can monitor the status of the logs after you run the task.

0 COMMENTS

We’d like to hear from you!