CSV to Workday Tenant
Submitted by @stodoroska from Interworks This pipeline reads a CSV file, parses the content, then the Workday Write Snap is used to call the web service operation Put_Applicant to write the data into a Workday tenant. Configuration If there is no lookup match in the SQL Server lookup table, we are using MKD as a default code for country code. Sources: CSV file on the File share system Targets: Workday tenant Snaps used: File Reader, CSV Parser, SQL Server - Lookup, Mapper, Union, Workday Write Downloads CSV2Workday.slp (17.3 KB)
Workday to Oracle and BambooHR of Employee Information
Created by @asharifian This pattern provides an HRIS integration from Workday to Oracle and BambooHR. Oracle will store employee information in a database table for analytics purposes. BambooHR is an HRIS system that will store employee information for human resources and onboarding. The source is the Human_Resources service, Get_Workers object in Workday. Configuration You can get a free trial of BambooHR and test out their API’s. API is relatively easy to configure. Sources: Workday Get_Workers Targets: Database Table for Oracle, Employees for BambooHR Snaps used: Workday Read, Mapper, Copy, Oracle - Insert, JSON Splitter, REST Post Downloads Workday to Oracle-BambooHR.slp (13.2 KB)Employee Journey: Employee Data Management: Box Folder Management
This pattern is part of the Employee Data Management solution of the Employee Journey. Created by SnapLogic in conjunction with partner Eljun, LLC This pattern looks for active users within Workday that were updated within the last two hours and pulls employee files into their corresponding sub-folders, using the file structure created from the Box Folder Management pipeline. In this solution, the parent directory for employee files is divided into “Active” and “Terminated” folders. Under each of these subfolders is a series of sub-folders A-Z (representing the first letter of each employee last name). The actual Employee File Folder is then found within the appropriate alphabetical subfolder with a naming convention “EmployeeID_LastName_FirstName”. Additional sub folders are created within each employee folder, each representing a functional category of documents that the HR unit may want to capture such as performance, expenses, and training. Pipelines Get Employee Files With this pipeline, for active users updated in Workday within the last 2 hours, determine what information from the Workday Get_Workers object to include, then: kick off the Box_Folder_Management pipeline get the user’s active status, employee name, and ID from Workday get the user’s Jobvite candidate information get the user’s 7Geese information and write it to the user’s Performance sub folder. get the user’s Skilljar information and write it to the user’s Training sub folder. get the user’s Docusign information get the user’s Expensify information and write it to the user’s Expenses sub folder. Applications in use: Workday, Box, Jobvite, 7Geese, Skilljar, Docusign, Expensify Box_Folder_Management This pipeline creates a folder structure within Box to store relevant data for a new hire, moves it to a separate location when an employee leaves, or archives the termination folders if the employee is rehired. In the case where an employee leaves the company, their folders are moved to the Terminated folder. If a person is re-hired, their Terminated folders are archived. Applications in use: Box Snaps used: Mapper, Pipeline Execute, Router, Union, JSON Splitter, Box File Operations, Exit, Filter, Copy, Join, JSON Formatter, File Writer, Box Directory Browser, Tail Check_and_Create_Folder This pipeline checks to see if the requested folder already exists, and if not, creates it. Applications in use: Box Snaps used: Box Directory Browser, Group by N, Mapper, Join, Sequence, Router, Box Add Folder, Union Push_File_to_Box Use this pipeline to read a file from the SnapLogic Platform and write it to a users Box folder. Applications in use: Box Snaps used: Directory Browser, Filter, File Reader, Box Write Downloads Get Employee Files.slp (127.1 KB) Box_Folder_Management.slp (71.9 KB) Check_and_Create_Folder.slp (19.6 KB) Push_File_to_Box.slp (7.7 KB) See Also SnapLogic Human Resources Automate employee workflows from talent management to employee on and offboarding, all in one platform.
Workday Action Based Write
Submitted by @stodoroska from Interworks This pipeline determines which Workday objects to populate based on the action flags. Configuration Based on the action flags, the pipeline determines which Workday objects to populate. You can choose the flags or the conditions by which you will decide the flag values and Workday objects. Sources: CSV file on the file sharing system Targets: Workday Snaps used: Workday Write, PGP Decrypt, File Write, File Read, Router, Mapper, Union Downloads Workday Action Based Write.slp (89.4 KB)Employee Journey: Insert new employee into Workday
Created by @rdill This pipeline pattern allows users to respond to a REST Post event triggered by a third party HR solution (e.g. Jobvite, Glassdoor, LinkedIn, etc.) and insert new employee(s) data into Workday. Configuration This pipeline requires the proper structure to insert a new employee in Workday. There are two kinds of data needed to create a new employee, “static” data, such as country reference, organization reference, etc. The second is the dynamic data, user name, hire date, etc. The pipeline is configured to provide the static data and all the user needs to do is provide the dynamic data. Sources: Any application that can invoke a REST Post to create an employee in Workday and contains the necessary attributes to create a new employee in Workday. (In this case, a JSON document is used.) Targets: Workday: Service, Staffing, Object, Hire Employee Snaps used: File Reader, JSON Parser, Mapper, Workday Write Downloads POST Hire Employee.slp (9.4 KB)
Salesforce Accounts to Workday Organization
Created by @ckonduru In this pipeline, a new or updated account in Salesforce will trigger a create or update in a Workday organization. Configuration Sources: Salesforce Account Targets: Workday Organization Snaps used: Salesforce Read, Mapper, Filter, Head, Workday Write Downloads Salesforce_Accounts_To_Workday_Organizations_Company.slp (9.5 KB)Create request ticket in ServiceNow when employee in Workday joins
Created by @ckonduru SnapLogic gets triggered off a new hire in Workday, then SnapLogic will create a request in ServiceNow. SnapLogic creates an empty request in ServiceNow, then SnapLogic/ServiceNow sends email with link to ticket to manager. Manager then fills in the details for the ticket and submits it. Configuration Sources: Workday Targets: ServiceNow Snaps used: JSON Generator, XML Parser, JSON Formatter, JSON Parser, JSON Splitter, Group By N, Mapper, Workday Read, ServiceNow Insert, Email Sender Downloads Workday_To_ServiceNow_NewHire_CreateRequest_Link_To_Manager.slp (24.8 KB)
Creation of Users in ServiceNow through Approval Process in Workday
Created by @skatpally When there is a new/updated employee in Workday, create employee in ServiceNow if admin approves his application via People’s Task. Configuration Sources: XML File, Workday Targets: ServiceNow Snaps used: File Reader, XML Parser, JSON Splitter, Mapper, Filter, Workday Read, ServiceNow Insert Downloads New-Hire-WKDY-to-SNOW.slp (16.4 KB)
Sync data from Workday to Anaplan
Created by @vish This pipeline pattern syncs journals from Workday financials to Anaplan. Configuration Sources: Workday Financial_Management/Get_Journals Targets: Anaplan any model Snaps used: Mapper, Workday Read, Head, Conditional, CSV Formatter, Anaplan Upload, Anaplan Import Downloads Workday to Anaplan.slp (14.8 KB)
