HCM Data Loader

HCM Data Loader is a powerful tool for bulk-loading and maintaining data. It supports file-based upload of business objects, components, and component attributes using a flexible, delimited file.

HCM Data Loader loads:

  • Complex, hierarchical data

  • Large volumes of data, such as complete system extracts

  • Object history

You can use HCM Data Loader for both data migration and ongoing data maintenance. Major benefits of HCM Data Loader include support for:

  • Most HCM business objects

  • Incremental or partial data loading

  • Four types of keys to identify records uniquely

  • Configured descriptive flexfields and extensible flexfields, translation data, tree hierarchies, person images, and document-record attachments

HCM Data Loader provides:

  • A comprehensive user interface for initiating data upload, monitoring progress, and reviewing errors

  • A template file for each supported business-object hierarchy, which you can use as the basis for your own data files

  • A user interface for reviewing the structure and attributes of every supported business-object hierarchy

  • A web service that you can use to automate data upload

Note: The precursor of HCM Data Loader is HCM File-Based Loader. For information, see Overview: Transitioning from HCM File-Based Loader to HCM Data Loader (2206596.1) on My Oracle Support at https://support.oracle.com.

For more information on HCM Data Loader, see the HCM Data Loader guide.

HCM Spreadsheet Data Loader

Use HCM Spreadsheet Data Loader to import data to the HCM Data Loader stage tables from spreadsheets. HCM Spreadsheet Data Loader supports most of the business objects that HCM Data Loader supports. It offers both ease of use and flexibility. For example, you can configure spreadsheet templates to suit business needs by omitting attributes, changing attribute order, changing attribute labels, and adding help text.

For more information on HCM Spreadsheet Data Loader, see the HCM Data Loader guide.