Scenario: You have a request by IT to modify the WICT NewHireIntegration that you created eariler. The new requirement has two parts: 

1.       A CSV file is required. 

2.       They need for only the last 4 digits of the Social Security Number to be output in the CSV file (not the entire Social Security Number).

Tasks to Use 

Configure Integration System 

Create Integration Transformation (upload custom XSLT) 

Launch Integration System 

TASK 1: PREPARE TO UPLOAD XSL TRANSFORMATION (.XSL FILE) 

1.       Locate the Act_19-20_XSLT folder in the class .zip file 

2.       Find the Act19_XSLT_IntNewHire_SubstringSSN.xsl file and right-click and select Open With to open it with the Notepad text editor, or Wordpad, or Notepad++, or any other text editor (IMPORTANT: do not open the .xsl file with a browser such as IE)

3.       View the XSL file:

a.       Verify that the Custom Report Name in the namespace is WDINST_EIB_IntNewHire (spaces in the custom report name are changed to underscores)

b.      Verify that the flat file header line appropriately matches with the desired output columns 

c.       Verify that the detail sections of the XSLT match with the XML coming out of Workday

 Hint: Compare with your Column Heading Override XML Alias.. We will edit the report to match these values. 

4.       Close the editor, making sure not to change the contents of this file (close, do not save). 

5.       Search for the WDINST EIB IntNewHire report. Choose the Reporting or All of Workday category. Select Custom Report > Edit from the related action. 

6.       Simplify the Column Heading Override XML Alias setting for use with the XSLT document as shown:

7.    Click OK to save. Then click Done.

TASK 2: CONFIGURE INTEGRATION SYSTEM 

1.       Find the WICT NewHireIntegration (Integration System) using search (Don’t forget the Integrations category.) 

2.       Click the link in the search results to view the integration system 

3.      Use the related action off of the Transformation to select

Custom Report Transformation > Delete 

4.      Click OK and then click Done 

5.       Use the related action off of the Integration System to choose Enterprise Interface > Launch Configuration Wizard

6.       Click the  icon to configure the Transform step

7.       Click the Custom Transformation radio button and its prompt  icon

8.       Click the Create option and choose the Create XSLT Attachment Transformation task

9.       Name the XSLT Attachment Transformation WICT Transform IntNewHire

10.   Click the Attach button to locate the custom Act19_XSLT_IntNewHire_SubstringSSN.xsl file 

11.   Click the OK button to save your Transformation 

12.   Click Save to save the changes to your EIB 

TASK 3: LAUNCH INTEGRATION AND VIEW PROCESS MONITOR 

1.       Use the related action icon to Launch/Schedule the WICT NewHireIntegration integration system

2.       Accept the defaulted Run Frequency of Run Now, click OK

3.       Enter January 1^st, 2013 for the Start 

4.       Enter Today’s date for the End 

5.       Click on the OK button to launch the integration 

6.       Open and review the output, verifying that only the final 4 digits of the Social Security Number appear in the output for employees who have SSNs entered in the tenant.