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

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 ?