The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
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
Icon for OneStream Employee rankOneStream Employee
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

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
    3 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
      3 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.

      • Sridhar_M's avatar
        Sridhar_M
        Contributor
        3 years ago

        No problem, thanks for your reply Alex. The stored procedure is in the external database we are bringing data from workday to external tables, running the stored procedure for data transformations and pushing to Register table. 

        If we use direct connector, I assume we have an option to pull data from Workday to Register table directly and where can we perform those transformations ?