You are currently viewing Comparison of HDL, HSDL, and APIs for Data Load
Comparison of HDL, HSDL, and APIs for Data Load

In this article, we will look into the comparison of the data loader tools.

For Data Loads, we can use HCM Data Loader (HDL), HCM Spreadsheet Data Loader (HSDL), and REST APIs. Each of these tools has their own advantages/disadvantages and are best suited for different use cases.

HDL vs HSDL vs API Comparison

HCM Data LoaderHCM Spreadsheet Data LoaderREST APIs
Powerful tool and can be used for bulk data loadingCan be used for a limited number of rows. Beyond which it will have performance issuesPowerful tool but middleware or scripting knowledge is mandatory
Supports multiple Keys (Source Keys, Surrogate Key, User Key, GUID)Supports only User Keys, Surrogate Keys (for some objects)Supports User Keys
Supports delete operation too for some business objectsDelete operation supported by some business objectsDoesn’t support the Delete operation
Supports loading Attachments and ImagesDoesn’t support loading Attachments/ImagesDoesn’t support Attachments/Images
Complicated and needs a bit of technical backgroundBest fit for business users as the tool is based in MS ExcelBest fit for real-time integration scenarios between two systems. Not a solution of one-time data conversion
Wide range of HDL samples are available on Oracle DocumentationSome Samples are available on Cloud Customer ConnectSample payloads and invoking of APIs must be done in the hit and trial method. Not many samples are available.
Supports wide range of Business ObjectsSupports a wide range of Business ObjectsSupports Only limited Business Objects for which APIs are available
Errors can be easily seen on the application, and HDL file should be fixed and re-processedErrors can be easily seen, and HSDL files should be fixed and re-processedErrors will be available for every employee and there is a high chance that these errors might get unnoticed unless errors are consolidated.
The Preferred option for high volume Data ConversionsThe preferred option for End Users in maintaining a business objectThe preferred option for real-time integrations

These are the major differences that I could think of. If you want to add more, please post them in comments section.

If you like the content, please follow us on LinkedInFacebook, and Twitter to get updated with the latest content.