With Workday, the UW now has access to a rich array of human resources and payroll data not previously available — a significant institutional improvement for data-driven decision making. But the UW faced a major challenge in ensuring that data derived from Workday could integrate with less flexible, older University administrative systems that still must also consume data directly from the UW mainframe. That’s where UW-IT’s Enterprise Integration Platform (EIP) comes in.
Created by members of Enterprise Information, Integration & Analytics (EIIA), the EIP functions as a data hub able to consume data from newer source systems like Workday, apply business rules to make the data consistent, and deliver it efficiently to those existing “downstream” UW applications.
“In a nutshell, the EIP acts to insulate source systems and consuming systems from one another so that data changes or increases in load on one system won’t adversely affect the other,” said Paul Schurr, EIIA Integration Architect.
Besides Workday for HR and Payroll, other new systems with their own data sources will be adopted at the UW, such as for the UW Finance Transformation Program. “These future applications also will take advantage of the EIP in its role to ensure information for the University is timely, accurate, clear, secure and consistent so that applications and their users can make informed decisions,” said Schurr.
The EIP and the partnership between its team and the Integrated Service Center (ISC) have helped ensure a level of data quality that UW customers can rely on.
“Each night, more than 1,000 data quality tests run against Workday data, and alert the EIP team if there are issues,” said Schurr. “Sometimes, we discover data entry violates an existing business rule in an application — such as when users incorrectly enter foreign characters and hyphens into Workday that the older systems can’t accept.”
If a data issue or break occurs, the EIP and ISC teams quickly work together to resolve the problem.
“The collaboration with EIP has been invaluable, and we look forward to more of it as we continue to work toward Workday stabilization,” said Josh Levine, ISC Application Manager.
In addition, data experts from the EIP, ISC, UW Human Resources, Academic Human Resources, Payroll, Benefits, and others meet regularly to discuss data issues, impacts, rule definitions, data corrections and training improvements.
“Overall, the EIP is a central component of an enterprise data integration strategy and framework for the University,” said Anja Canfield-Budde, Associate Vice President for Information Management.