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:
In
Data Integration
, click
New
Mapping
Create
.
The
New Mapping
dialog box appears.
Enter a name and description for the mapping.
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:
On the
Source
tab, perform the following steps to configure the source properties:
In the
Connection
field, select the configured Oracle HCM Cloud V1 connection to connect to Oracle HCM Cloud application.
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:
In the
Request Options
section, click
Configure
to configure the request message. For more information about configuring the request message, see
Configuring Request Message.
In the
Advanced Properties
section, set the tracing level to normal, and use the default cache size of 1024.
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:
On the Target transformations, specify the target connection, target type, object, and operation for the target transformations.
Map the source and target.
Click
Save and Run
the mapping.
In
Data Integration
, click
New
Task
.
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.