Create transform maps in Enterprise Service Management Integrations Framework

Create a transform map to specify data relationships between the import set table and the target table.

Before you begin

Role required: sn_hr_integr_fw.admin

About this task

For every transformation, you must either create a transform map or select an existing one.

Procedure

1. Navigate to Integrations Framework > Transform Maps.

2. View the existing transform maps.

   Name	Description
   HR Pull to-do transform map	Moves tasks or Todos from the HR Pulled To-do Integration Staging [sn_hr_integr_fw_todo_inbound_staging] table into the HR Pulled Integration To-do [sn_hr_integr_fw_todo_inbound] table.
   HR Profile Transform Map	Maps workers, future workers, and effective workers from the HR Profile Staging [sn_hr_integr_fw_hr_profile_staging] table into the HR Profile [sn_hr_core_profile] table.
   Job Transform Map	Maps job profiles from the Job Staging [sn_hr_integr_fw_job_staging] table to the Job [sn_hr_core_job] table.
   Department Transform Map	Maps departments from the Department Staging [sn_hr_integr_fw_department_staging] table to the Department [cmn_department] table.
   Location Transform Map	Maps locations from the Location Staging [sn_hr_integr_fw_location_staging] table to the Location [cmn_location] table.
   Position Transform Map	Maps positions from the Position Staging [sn_hr_integr_fw_position_staging] table to the Position [sn_hr_core_position] table.

3. To create a transform map, click New.

   For details of how to create a transform map, refer to the table in Transformation scripts.