We have an integration using Fusion with our Workday for pulling in PTO and LOA. In Workday, we expose a series of Reports-as-a-Service (RaaS) that are then imported into a Workfront Fusion data store, normalized, and pushed into Workfront as RESVT entries. It's a daily process that also handles updates and deletes.
I'll also just say that it isn't nearly as straightforward as I just made it sound. It took us over a month to get working properly. Some challenges we hit:
- User-vs-Fusion time zones
- User schedule differences (8 hours per day in the US vs 7.5 hours in EMEA)
- The Workday RaaS outputs PTO transactions, not a "final view", meaning we had to normalize things
- Workday allows overlapping PTO and LOA entries, which also had to be normalized
This is not an exhaustive list. 🙂
We're now working on importing this data automagically into timesheets, too, and are hitting other aspects that have to be worked through.
It is worth doing if you have a sufficiently large workforce that you're supporting. But it isn't for the feint of heart.