Configure inbound integration for Workday

Pulling data from the Workday service requires verification and/or configuration of the HR integration services, web services, service mapping, schema mapping, and transform maps.

  1. Verify base inbound integration for Workday.
  2. If needed, create or modify HR integration services.
  3. If needed, create or modify HR web services for inbound.
  4. If needed, create or modify HR service mapping for inbound.
  5. If needed, create or modify HR schema mapping.
  6. If needed, create or modify HR transform maps.

Verify base inbound integration for Workday

The base inbound integration for Workday is configured for version 24.1 and allows you to pull employee profile data (departments, locations, job profiles, worker profiles, effective worker profiles, and future worker profiles) from the Workday service. You can verify the base settings and determine whether they meet your needs or if further customization is required.

Before you begin

Role required: sn_hr_integrations.admin

Procedure

  1. Verify the base HR integration services.
    1. Navigate to HR Integrations > HR Integration Service.
    2. In the HR Integrations Services list, verify that the base HR integration services for Workday are correctly mapped to their staging tables.
      Table 1. HR integration services and staging tables
      HR integration service Staging table
      Departments sn_hr_integrations_dept_staging
      Locations sn_hr_integrations_loc_staging
      Job Profiles sn_hr_integrations_job_profile
      Worker Profiles sn_hr_integrations_worker_profile
      Effective Worker Profiles sn_hr_integrations_worker_profile
      Future Worker Profiles sn_hr_integrations_worker_profile
  2. Verify the base HR web services.
    1. Navigate to HR Integrations > HR Webservices.
    2. In the SOAP Messages list, verify that the base SOAP messages and functions for Workday are correctly configured.
  3. Verify the base HR service mapping.
    1. Navigate to HR Integrations > HR Service Mapping.
    2. In the HR Integrations Service Mapping list, verify that the service mapping for each Workday record for the inbound integration is correct. Hover over the information icon next to each record.
      • Workday - Departments
      • Workday - Effective Worker Profiles
      • Workday - Future Worker Profiles
      • Workday - Job Profiles
      • Workday - Locations
      • Workday - Worker Profiles
  4. Verify the base HR schema mapping.
    1. Navigate to HR Integrations > HR Schema Mapping.
    2. In the HR Integrations Schema Mapping list, verify that the schema mapping for each Workday record is correct. Hover over the information icon for each record.
  5. Verify the base HR transform maps.
    1. Navigate to HR Integrations > HR Transform Maps.
    2. In the Table Transform Maps list, verify that the staging tables are correctly mapped to their target tables.
      Table 2. Staging and target tables
      Staging table Target table
      HR Integrations Department Staging [sn_hr_integrations_dept_staging] Department [cmn_department]
      HR Integrations Job Profile [sn_hr_integrations_job_profile] Job Profile [sn_hr_core_job_profile]
      HR Integrations Worker Profile [sn_hr_integrations_worker_profile] HR Profile [sn_hr_core_profile]
      HR Integrations Location Staging [sn_hr_integrations_loc_staging] Location [cmn_location]

What to do next

If you need to further customize the inbound integration, create or modify the appropriate settings. Otherwise, configure the outbound integration.

Create or modify HR integration services for Workday

If you need to create or modify any HR integration services, you can define the inbound service and map it to the appropriate staging table that data from the Workday service will be pulled to.

Before you begin

If you need to create a new staging table, see Create a table . Make sure the staging table is an extension of the core HR integrations staging table [sn_hr_integrations_staging].

Role required: sn_hr_integrations.admin

Procedure

  1. Navigate to HR Integrations > HR Integration Service.
  2. Click New or open a record.
  3. Fill in the fields on the form.
    Table 3. HR Integrations Service form
    Field Description
    Name Name of the HR integration service.
    Staging Table Name of the staging table that data from the third-party HR service will be pulled to.
    Note: The staging table must be an extension of the core HR integrations staging table [sn_hr_integrations_staging].
    Active Check box to activate the HR integration service. Only active HR integration services are available to use.
    Order Order number for when data is pulled. Lower numbered data is pulled before higher numbered data.
  4. Click Submit or Update.

What to do next

If you need to further customize the inbound integration, create or modify the appropriate settings. Otherwise, configure the outbound integration.

Create or modify inbound HR web services for Workday

If you need to create or modify any HR web services for the inbound integration, you can define the SOAP message and/or functions.

Before you begin

Role required: sn_hr_integrations.admin

Procedure

  1. Navigate to HR Integrations > HR Webservices.
  2. Click New or open a record.
  3. Fill in the fields on the form.
    Table 4. SOAP Message form
    Field Description
    Name Name of the HR web service.
    WSDL URL for the Web Service Description Language (WSDL) that describes the table schema and available operations.
    Download WSDL Check box to indicate that the WSDL can be downloaded. If checked, provide the URL in the WSDL field. If unchecked, provide the XML in the WSDL XML field.
    Use mutual authentication Check box to indicate that mutual authentication is being used. If checked, select a protocol profile.
    Application Name of the application using the HR web service.
    Accessible from Scope the application is accessible from.
    Authentication type Type of authentication: none or basic. If basic, provide a basic auth profile.
    Description Description of the HR web service.
    WSDL XML XML for the Web Service Description Language (WSDL) that describes the table schema and available operations.
  4. Click Submit or Update.

What to do next

If you need to further customize the inbound integration, create or modify the appropriate settings. Otherwise, configure the outbound integration.

Create or modify inbound HR service mapping for Workday

If you need to create or modify any HR service mappings for the inbound integration, you can define the service mapping to map the HR integration service to the appropriate web service (SOAP message and function).

Before you begin

Role required: sn_hr_integrations.admin

Procedure

  1. Navigate to HR Integrations > HR Service Mapping.
  2. Click New or open a record.
  3. Fill in the fields on the form.
    Table 5. HR Integrations Service Mapping form
    Field Description
    Name Name of the HR service mapping.
    HR external source Name of the third-party HR service.
    HR service Name of the HR service (if applicable).
    HR integration service Name of the HR integration service (if applicable).
    HR integration outbound service Name of the HR integration outbound service (if applicable).
    Active Check box to activate the HR integrations service mapping. Only active service mappings are available to use.
    Outbound service Name of the web service, e.g., the SOAP message service used for end-user connection.
    Outbound service function Name of the web service function, e.g., the SOAP message function defining what information should be pulled from or pushed to the third-party HR service.
    Outbound service function all Name of the web service function, e.g., the SOAP message function defining what information should be pulled from or pushed to the third-party HR service (if applicable).
    Response root key
    Response total results key
    Response total pages key
    Response page results key
    Response current page key
  4. Click Submit or Update.

What to do next

If you need to further customize the inbound integration, create or modify the appropriate settings. Otherwise, configure the outbound integration.

Create or modify HR schema mapping for Workday

If you need to create or modify any HR schema mappings for the inbound integration, you can define the schema mapping to map data from the Workday service to the appropriate fields in the staging tables.

Before you begin

Role required: sn_hr_integrations.admin

Procedure

  1. Navigate to HR Integrations > HR Schema Mapping.
  2. Click New or open a record.
  3. Fill in the fields on the form.
    Table 6. HR Integrations Schema Mapping form
    Field Description
    Source Name of the third-party HR service.
    Staging Table Name of the staging table that the data from the third-party HR service is pulled to.
    Staging table column Name of the column in the staging table that the data from the third-party HR service is pulled to.
    Service mapping Name of the HR service mapping.
    Type Value type of the column: XPath (variable) or constant.
    External Entity Column Key If XPath, the name of the variable.
  4. Click Submit or Update.
  5. In the HR Integrations Schema Mapping list, locate the record, double-click the Mandatory field, and provide a value of true or false.
    • If true, then the field value cannot be null. If the value is null, then the record it originates from will be ignored and not placed into the staging table.
    • If false (default), then any field value is accepted.

What to do next

If you need to further customize the inbound integration, create or modify the appropriate settings. Otherwise, configure the outbound integration.

Create or modify HR transform maps for Workday

If you need to create or modify any HR transform maps, you can define the transform map to map the staging table to the appropriate target table.

Before you begin

Role required: sn_hr_integrations.admin

Procedure

  1. Navigate to HR Integrations > HR Transform Maps.
  2. Click New or open a record.
  3. Fill in the fields on the form.
    Table 7. Table Transform Map form
    Field Description
    Name Name of the transform map.
    Source table Name of the staging table.
    Active Check box to activate the transform map. Only active transform maps are available to use.
    Run business rules Check box to run business rules.
    Enforce mandatory fields Enforcement type: no mandatory fields, only mapped fields, or all fields.
    Copy empty fields Check box to copy empty fields.
    Application Name of the application using the transform map.
    Created Date of creation.
    Target table Name of the target table.
    Order Order number for when transform maps are applied. Lower numbered transform maps are applied before higher numbered transform maps.
    Run script Check box to run script. If checked, provide the script.
  4. Click Submit or Update.

What to do next

If you need to further customize the inbound integration, create or modify the appropriate settings. Otherwise, configure the outbound integration.