WORKLOAD AUTOMATION COMMUNITY
  • Home
  • Blogs
  • Forum
  • Resources
  • Events
    • IWA 9.5 Roadshows
  • About
  • Contact
  • What's new

Simplify The Data Loading Using Oracle UCM and HCM Data Loader plugins with Workload Automation

9/28/2020

0 Comments

 
Picture
Customers using Oracle Human Resources Cloud face the challenge of continuous bulk loading of large amounts of data at regular intervals. Oracle Human Resources Cloud provides the tools like HCM Data Loader which address this business use case. Now you can automate data loading into Oracle Human Resources cloud using the Oracle UCM and Oracle HCM Data Loader plugins which leverage the HCM Data Loader for the Workload automationusers.
​
Business Process automated:
Picture
Source:https://docs.oracle.com/en/cloud/saas/human-resources/20a/faihm/introduction-to-hcm-data-loader.html#FAIHM1372446

The above diagram shows the business process automated through these plugins:

This process is divided into 2 steps and hence the 2 plugins:
  1. A .zip file containing .dat files is placed on the Oracle WebCenter Content server. Here the Oracle WebCenter Content server acts as a staging infrastructure for files that are loaded and processed by the HCM Data Loader.
  2. HCM Data Loader imports the data first into its stage tables and then into application tables. Any errors that occur during either the import phase or load phase are reported in the job status and details in job log.


Technical description and workflow
Oracle UCM plugin

The Oracle UCM enables you to stage data files for processing to HCM Data Loader.
It provides easier integration with other business processes by using the Oracle Universal Content Management (UCM) integration.
The Oracle UCM Data Loader automates the process of bulk-loading of data. You can load the data files and monitor them from a single point of control.
The data is uploaded as zip files to Oracle UCM, which is processed by the HCM Data Loader.
This integration helps you save time, resources, and speed up data loading in a secure manner.

Prerequisite for the plugins to work:
– Oracle Human Resources Cloud service account with correct permissions to access File Import and Export task in the Oracle Human Resources Cloud web user interface.
– Credentials (username and password) for Oracle Human Resources Cloud web user interface.

Log in to the Dynamic Workload Console and open the Workload Designer. Choose to create a new job and select “Oracle UCM” job type in the Cloud section:
Picture
Establishing connection to the Oracle Cloud:
In the connection tab provide URL, Username and Password.
Picture
A connection message is displayed when the connection is established.
Picture
Required File path which can be browsed using the Browse button
Picture
Submitting the job stream:
Picture
Track/ monitor the submitted job:
You can easily monitor the  submitted  job  in WA through navigating to “Monitor Workload” page.
Picture
Picture
Logs for the Oracle UCM file upload:
Picture
Picture
UCM File upload status from UI:
Picture
Oracle HCM Data Loader plugin

The Oracle HCM Data Loader integration enables you to import and load the data from data files uploaded to Oracle UCM by the Oracle UCM plugin to Oracle Human Resources Cloud.
The plugin internally invokes the importAndLoadData function from the HCMCommonDataLoader web service.
HCM Data Loader decompresses the .zip file and imports individual data lines to its stage tables. In the stage tables, related data lines are grouped to form business objects. Any errors that occur during the import phase are reported on the failed job log.
HCM Data Loader calls the relevant logical object interface method (delivered in product services) to load valid objects to the application tables. Any errors that occur during the load phase are reported on the failed job log.

Prerequisite for the plugins to work:
– Oracle Human Resources Cloud service account with Human Capital Management Integration Specialist job role or privileges to access HCM Data Loader.
– Credentials(username and password) for Oracle Human Resources Cloud web user interface.


Log in to the Dynamic Workload Console and open the Workload Designer. Choose to create a new job and select “Oracle UCM” job type in the Cloud section:
Picture
Establishing connection to the Oracle Cloud:
In the connection tab provide URL, Username and Password.
Picture
A connection message is displayed when the connection is established.
Picture
Required Content ID which is generated by the Oracle UCM plugin
Picture
Submitting the job stream:
Picture
Track/ monitor the submitted job:
You can easily monitor the  submitted  job  in WA through navigating to “Monitor Workload” page.
Picture
Logs for the Oracle HCM Data Loader:
Picture
HCM Data Loader import and load status from UI:
Picture
Author's BIO
Picture
Gaurav Kulkarni, Technical Specialist, HCL Software

Experience in Java technologies like Hibernate, Spring boot, Web Services and REST APIs, UI technologies like native JavaScript, jQuery, ReactJS, python flask, Databases like Postgres, Oracle. Enthusiast about full stack software development and other similar technologies.
View my profile on LinkedIn
Picture
Rooparani Karuti – Senior Test Specialist at HCL Software
Working as senior test specialist for Workload Automation-Plugin Factory team in HCL Software Lab, Bangalore. Having experience in both manual and automation test scenarios across various domains. ​
View my profile on LinkedIn
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Archives

    March 2023
    February 2023
    January 2023
    December 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    January 2020
    December 2019
    November 2019
    October 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

    Categories

    All
    Analytics
    Azure
    Business Applications
    Cloud
    Data Storage
    DevOps
    Monitoring & Reporting

    RSS Feed

www.hcltechsw.com
About HCL Software 
HCL Software is a division of HCL Technologies (HCL) that operates its primary software business. It develops, markets, sells, and supports over 20 product families in the areas of DevSecOps, Automation, Digital Solutions, Data Management, Marketing and Commerce, and Mainframes. HCL Software has offices and labs around the world to serve thousands of customers. Its mission is to drive ultimate customer success with their IT investments through relentless innovation of its products. For more information, To know more  please visit www.hcltechsw.com.  Copyright © 2019 HCL Technologies Limited
  • Home
  • Blogs
  • Forum
  • Resources
  • Events
    • IWA 9.5 Roadshows
  • About
  • Contact
  • What's new