Oracle HCM Cloud V1 Connector

Oracle HCM Cloud V1 Connector

Target transformation mapping example for Import and Load Data object

Target transformation mapping example for Import and Load Data object

You can use a pre-configured DAT file in zip format to directly upload HDL files to Oracle Cloud. Create a flat file and specify the details of the HDL ZIP file path and the business object name. To upload the HDL files to Oracle Cloud, select the Import and Load data object for the write operation.
Pre-requisites:
  • Before you begin, create a flat file and specify the details of the
    HDLZipFilePath
    and the
    BusinessObjectName
    . The sample file shows the configured details in the flat file:
    The
    HDLZipFilePath
    specifies the path to the zip file that encloses the DAT file and
    BusinessObjectName
    specifies the name of the Oracle HCM target object.
  1. In
    Data Integration
    , click
    New
    Mapping
    Create
    .
    The
    New Mapping
    dialog box appears.
  2. Enter a name and description for the mapping.
  3. In the Source transformation, specify a name and description in the general properties.
  4. In the Connection field, select the flat file connection to connect to the configured flat file that contains the DAT file details.
  5. In the Target transformation, specify a name and description in the general properties.
    Perform the following tasks on the
    Target
    tab:
    1. In the
      Connection
      field, select the Oracle HCM Cloud V1 connection to connect to Oracle HCM Cloud application.
    2. In the
      Operation
      field, select the
      Import and Load data
      object in the
      Package Explorer
      section.
      The following image shows the list of the write operations:
  6. On the
    Field Mapping
    tab, map the source fields to the target fields.
    The following image shows all the mapped fields between the input file and the Oracle HCM Cloud V1 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.
In
Monitor
, you can monitor the status of the logs after you run the task.

0 COMMENTS

We’d like to hear from you!