Objectives
After completing this lesson, you should be able to:
•Understand some of the ways in which Oracle Fusion HCM supports data import
•Describe how HCM Data Loader imports data
•Describe how HCM Spreadsheet Data Loader imports data
•Describe how specialized data loaders import data
•Select the appropriate data-import mechanism for your purposes, based on your integration strategies, approaches, and data-migration plans
Importing Data: Introduction
Data import is a necessary activity, irrespective of how you implement Oracle Fusion HCM. You may be:
•Migrating your existing data completely to Oracle Fusion HCM before retiring a legacy product. This scenario typically requires a one-time data upload.
•Loading data from a third-party supplier
•Implementing a coexistence scenario, where Oracle Fusion HCM is being used with another HR product. For example, you may want to use Talent Management in Oracle Fusion HCM but maintain person records elsewhere. Such scenarios require repeated data uploads to Oracle Fusion HCM.
Importing Data: Key Data Loaders
The two key data loaders are:
•HCM Data Loader
•HCM Spreadsheet Data Loader
HCM Spreadsheet Data Loader
HCM Data Loader
Loads nonhierarchical and simple hierarchical data
Loads complex hierarchical data
Loads small-to-medium data volumes
Loads large data volumes
Best suited for one-time data migration
Supports scenarios where data update is required
No support for loading object history
Supports loading object history
HCM Data Loader Overview
A tool for bulk-loading data from any source into Oracle Fusion HCM. It is suitable for:
•One-time data migration
•Maintenance of Oracle Fusion HCM data
•Coexistence scenarios
HCM Data Loader: Benefits
HCM Data Loader supports:
•Business objects belonging to key Oracle Fusion HCM products
•Bulk-loading of:
–Flexfield data
–Person images
–Document of record attachments
–Translation data
–Department and organization hierarchies
