HCM Data Loader vs HCM Spreadsheet Data Loader
SummaryWhat is the difference between these two tools
HCM Data Loader (HDL) provides bulk loading capabilities for many HCM objects using a pipe delimited flat file format. It is recommended for data migration and ongoing automated integrations. The expected user is the integration specialist, someone technical. The data files are usually generated by an extract routine though they can be manually created for simpler business objects.
HCM Spreadsheet Data Loader (HSDL) utilizes the HDL processes, but provides a spreadsheet front end. The user first creates a object specific template, which defines the shape of the spreadsheet to be used for data entry. Then the template can be shared with less technical users to simplify data entry. The data upload is initiated from the spreadsheet, any errors found are reported against the failed lines in the spreadsheet. Data can then be corrected in the spreadsheet and upload attempted again.