PeopleSoft to Workday Data Migration

A number of our team here at ETLcloud started their Workday careers by migrating their existing PeopleSoft client onto Workday. Having been through this data migration process we have learnt what works and what does not. Why create a dozen SQR reports to extract your data when you can use a single configurable Application Engine program that will both extract and transform your data into either EIB or Iload script format.

We have used our experience to design and build a tool that leverages existing PeopleSoft technology (application Engine) to manage all your Workday Data migration needs.

GBPSHWD is a data extraction, comparison and transformational tool built in the native languages/toolset within PeopleSoft. Highly configurable it can be used for small and large scale data conversions alike offering a concise and performant way to specify, output and manage your data conversion needs. Often it is necessary to extract an initial dataset and then follow up at a later date with any changes. This is easy with GBPSHWD since a delta process is built in.

Benefits

• Data Capture
• Modular approach
• Data can be selected and aggregated using one or more SQL steps.
• Snapshot build ensures quick consistent data capture.
• Dataset configuration allows modules to be run for the entire population or to apply specific processing for targeted populations.
• Set based engine for performant comparison and data step processing.
• Automatic deltas, categorised as deletes, updates, corrections or time-boxed removed.
• Meta translation layer
• Transform the selected data.
• Applying old to new world codes translation.
• Layered calculations for specific processing such as 'to be' pay-calcs
• File output layer
• Configurable options ensures output data conforms to required format.
• Output files supported, CSV, XML, txt, (JSON?)