HDL- HCM Data
Loader
It is a Bulk Data Loader to load HCM Cloud related to Objects.
What are the Business
Objects we can load using HDL?
Location
Jobs
Positions
Grades
Worker-Complex one(hierarchy we need to follow)
What is the process?
HDL will contain templates
Identify the templates for the BO which u are going to
load.
Prepare data for the template.
.date file(a pipe delimeter file) in zip format is ready
then we will go for the import process.
Import process will move data to Stage Tables.
Load process will move the data to Base
Tables(Application Tables)
Once data is there in base tables then you will be able
to see it in UI.
Navigation:
Navigation bar, MyClient GroupsàData Exchange.
We can find HDL, HSDL & HCM Extracts.
What are the location base
tables?
Per_locations
Per_locations_details_f
Per_locations_details_f_tl
Click on View Business Objects.
Search for locations
Location will store Place, address and other details of
the organization.
File name should be as: Location.dat.
We should not change the file names.(Template Name)
Download the template.
Bkp is for structure
Location is the duplicate file.
Both are DAT file
Open Location with Notepad++
It is a HDL file
COMMENT: It consists of short text or long text. Compiler ignores the lines in Comment section.
METADATA means column structure.
Eg:
Insert into dept(deptno,dname,loc) values(20,’software’,’blr’);
In the same way
Metadata means columns for the location.
Merge means values for the location
Optional columns we can remove
Insert into dept(deptno,dname) values(20,’software’,);
Template provide the all the possible columns for the
component Location.
Location Extra Ino is a component
LocationLegislative
LocationOtherAddress
Are all these mandatory?
We need to check.
Go to Myclient groups
Workforce structures
Locations
Create a location
Extra info optional
Legislative info optional
So, remove optional columns from the HDL file
Every column need to be separated with single pipe
delimeter.
Click on Location in search section.
File Descriminator: Location
Click on Attributes
LocationId is a Surrogate Key
LocationCode and SetCode are User Key
Surrogate Id will be only available when updating the
existing locations.
For creating a Location, Location Id(primary key)
surrogate key is not required to pass.
Only when you are going o update existing Location, we can use Location Id.
Location Code- within the set the code to identify
Location uniquely (User Key)
SetCode- COMMON
Within the SetCode Common the location code should be
there uniquely.
ActiveStatus- is required for new records.
There is a Lookup available to check status.
To check Lookups, navigate to ‘’Setup and Maintenance’’ ,
go to Global search and search a Task called ‘’Manage Common Lookups’’
Search for the Lookup name
EffectiveStartDate= mandatory pass the value
EffectiveEndDate= optional leave it as null
Country=Mandatory
LocationName =Mandatory
SetId=Mandatory(we don’t have ID so alternativel we
passed Setcode)
Once you are ready with dat zip file, go to HDL page and
click on import
Select zip file, click on submit
We have two options Import only or Import and Load
File has placed in UCM content server and created an id
automatically for it.
Check delete source file and click on submit.
Then click on Refresh
Metadata will be only one on the top
Merge will be multiple records
Once you do the correction, delete the existing zip file
and convert dat file again to zip folder.
Every import has content id
Now, search the location which is created in front-end.
Let us try one negative case and two positive case
Change the dates for other records and try to import
For old record, effectiveenddate will be provided.
For new record, no effectiveend date
Negative case
COMMENT Data for Business Object: Location Version: V2
Created on: 03-08-2024
METADATA|Location|LocationCode|LocationName|SetCode|ActiveStatus|EffectiveStartDate|EffectiveEndDate|Country
MERGE|Location|xx_blr01_HDL|BLR01|COMMON|A|2024/09/20||IN
MERGE|Location|xx_blr01_HDL|BLR01|COMMON|A|2024/09/20||IN
Positive Case:
COMMENT Data for Business Object: Location Version: V2
Created on: 03-08-2024
METADATA|Location|LocationCode|LocationName|SetCode|ActiveStatus|EffectiveStartDate|EffectiveEndDate|Country
MERGE|Location|xx_blr01_HDL|BLR01|COMMON|A|2024/09/20||IN
MERGE|Location|xx_blr07_HDL|BLR07|COMMON|A|2024/09/21||IN
MERGE|Location|xx_blr008_HDL|BLR0|COMMON|A|2024/09/21||IN
date
HDL Error Report
Excel output
