Setting up the Workday integration using a SFTP
Creating an EIB Integration using sftp
- Create Custom Report in Workday and enable as Web Service (Advanced Tab)
- Add any sorting or filtering – (For Example, we excluded certain employee types from the report)
- Create Integration System User using the Create Integration System User task in Workday. Add this ISU to an existing integration system security group (ISSG) or create a new one.
- Using the Maintain Password Rules task, add this ISU account to the System Users exempt from password expiration list
- Update the relevant domain security policies giving the security group access to Get integration permissions
- Activate pending security policy changes
- Share the repot with authorized users including the ISSG/ISU
Using the Create EIB task, create the EIB (integration)
Choose name->Select Outbound
Under General Settings, enter an unique ID if you choose and description.
On the Get Data tab, choose custom report as the Data Source Type and then choose the Custom report you created.
On the Transform tab, choose New Custom Report Report Transformation. It will default the name to the name of the custom report + date transformation was created.
On the delivery tab, add the file name, type and document retention policy for the Workday attachment. Create a Sequence Generator for ilename (if desired) and restrict Workday attachment to specific environments.
Click OK/Done.
After EIB is created, you may need to update the transformation to name the fields according to agreed upon names with Lattice. The transformation can be configured by going to the Actions button from the integration system name, then Enterprise Interface-> Configure Transformation. If after creating the transformation, any updates to the fields in the custom report are made, the transformation will need to be deleted and created again.
Create Business Process Definition for Integration
Include a document delivery step if sending file via sftp
Click on Configure Document Delivery button to add the sftp information.
Please note to not have the "Use Temp File" option selected.