Table of Contents

Search

  1. Preface
  2. Workday Connector
  3. Workday connections
  4. Workday operations
  5. Mappings and mapping tasks with Workday
  6. Appendix A: Workday data type reference
  7. Appendix B: General considerations when using Workday V2 Connector
  8. Appendix C: Workday target approaches

Workday V2 Connector

Workday V2 Connector

Web Services transformation mapping example

Web Services transformation mapping example

You are a human resources administrator and you want to archive the details of employees who left the organization in the past month. You can find the employee in Workday based on employee ID and archive their details in a flat file.
Configure a mapping task to archive the details from Workday to a flat file You must have a Workday V2 connection with Human Resources as the Module Name and version v25.0 configured in the connection properties. You must have a flat file connection to archive the employee data.
To create a mapping, perform the following tasks in the Mapping Designer:
  1. Create a Workday connection. Verify that you select Human Resources as the Module Name in the connection properties.
  2. Create a flat file connection to specify the input data.
  3. Create a Workday business service
    WDAY_GetWorkers_ec2
    . Select the Workday connection associated with the Human Resources Workday module. Select
    Get_Workers
    as the operation for the Web Service
  4. Create a mapping and specify the name
    _m_WDAY_Webservice_GetWorkers
    and description in the general properties.
    The following image shows the Workday Connector configured midstream in a Web Services transformation in a mapping:
  5. Add the Source transformation
    FF_WDAY_GetWorkers
    and specify a flat file connection and source object
    Get_Workers.csv
    file to provide input to the web service operation.
    Verify that the flat file contains the employee information such as
    Worker_Reference_ID
    and
    Worker_Reference_Type
    fields that you want to pass to Workday to extract the details.
  6. Add the Web Services transformation
    WDAY_WebServices
    . Perform the following steps:
    1. Click the
      Web Service
      tab and select the Workday business service
      WDAY_GetWorkers_ec2
      with the Get_Workers operation.
    2. Draw a link to connect the Source transformation to the Web Services transformation.
    3. Click the
      Request Mapping
      tab to map the incoming worker reference ID and type fields with the ID and type fields in the request structure.
      The following image shows the mapped incoming fields with the request structure:
    4. Click the
      Response Mapping
      tab and select the output fields that you want from the response structure form Workday for the GetWorkers operation.
      The following image shows the selected output fields from the response structure that you want to write to the target:
  7. Add two Sorter transformations to sort the master and detail data obtained from the Web Services transformation. Specify the PK and FK fields as sort conditions and configure each sort field to sort in ascending order:
    1. The Sort transformation Name_Data sorts the master data, which contains First_name, Last_Name, PK_Worker, Worker_Reference_ID, and Worker_Reference_Type by the PK_Worker field.
    2. The Sort transformation Phone_Data sorte the phone data, such as FK_Worker, Phone_Extension, Phone_Number, Worker_Reference_ID, and Worker_Reference_Type by the FK_Worker field.
  8. Add a Joiner transformation
    WDAY_Joiner
    to join the master and detail data.
    1. Specify the following Join condition for the Master, Operator, and Detail fields:
      NameData_PK_Worker = Phdata_FK_Worker
      .
    2. Select
      Sorted Input
      in the advanced properties of the Joiner transformation.
  9. Add the Target transformation
    FF_WorkersData
    and specify the flat file connection and target object
    WebService_WokerData.csv.
    When you save and run the mapping, Workday Connector gets the employee details based on ID values in the source object and writes them to the flat file.