Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
3 years ago

Workday Integration

Hi there. I am new to the community but am wondering if any of the users are using Workday as the general ledger / ERP and Onestream for Reporting, etc. Posted by Andrea at Ensign Services Migrat...
Reports
OSAdmin's avatar
OSAdmin
Valued Contributor
3 years ago

You can bring in data from Workday HCM ( HR data) or Workday Financials( GL Balance etc) using REST APIs. we have used Mulesoft for HR data integration from Workday to Onestream. you can use Onestream transformation if any mapping needed. Once data landed in Onestream Stage or Custom table or Application , you can use Onestream dashboard or Analytics blend for reporting. Although Workday PRISM has similar reporting capabilities but less flexibility as Analytic Blend.

Posted by Khirod Palai

  • Krishna's avatar
    Krishna
    Valued Contributor
    3 years ago

    Great. I know the process of extracting from HR through Mulesoft but how are you inserting into OS stage table using mulesoft ? or it is kind of 2 step process, 1. Extract & load into Database & 2. Use OS Direct Connect ?

     

     

  • AlexLadd's avatar
    AlexLadd
    New Contributor II
    3 years ago

    We've built an integration to Workday financials. The business Rule Connector uses the Workday API to run and retrieve a workday report. That way, if you ever need to update the data integration you can just tweak the workday report and it'll flow into OneStream. We built it for a client, but, they don't seem to be answering this post so I'd be happy to talk through it with you.

    • Sridhar_M's avatar
      Sridhar_M
      Contributor
      2 years ago

      Hi Alex, 

      Thanks for your insight. We are doing lot of transformations using stored procedure on the data we are receiving from workday before loading to People Planning register table. Is it possible to apply those mappings if we want to do a direct connect from OneStream to Workday using API ?

      • AlexLadd's avatar
        AlexLadd
        New Contributor II
        2 years ago

        Sorry, for some reason I missed this reply!  sridharm92, yes, you could definitely do that.  I'm assuming the stored procedures are in the OneStream staging area or at least in the OneStream database?  The API connection basically just ingests the data from Workday into OneStream.  The client I was talking about has both Workday financials and HCM so we have two different destinations and two different calls but the front end of the process, the API call, is essentially the exact same.  The only difference is that it calls two different reports.