Skip to main content
A
Anonymous
October 11, 2022

Workday Integration

  • October 11, 2022
  • 3 replies
  • 0 views

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

Migrated from ONECommunity

3 replies

A
Anonymous
October 11, 2022

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

K
Krishna
Expert
October 13, 2022

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 ?

 

 

J
JonKunert
Contributor
October 11, 2022

We are using Workday for our ERP,  we are currently exporting the data to an S3 bucket and OS is picking it from there.  Which works well, when we can get the data out of WD in a timely matter.  The exports from WD get longer as the year progresses.  

A
AlexLadd
Newcomer
January 27, 2023

Yes, we ran into an issue using the API where we had to parse the report output into sections so the API server wouldn't choke.  The Workday API servers have limitations set on them so the amount of data passing through can be a limiting factor.  Especially in their test environments.

B
Brooks
Contributor
October 17, 2023

Oops!  I meant to make this an original post.  Sorry to barge in. 

We are trying to pull WD HR data into OneStream.  At this point, we are just trying to prove we can do it.  I'm trying to setup a data adapter to pull the data using an SIC Direct Connection, but I don't know how to start with the data connector.  What type of data connector?  How do I tell the da to grab the data from the SIC?  Searching the OneStream documentation for these yields nothing and the Foundation Guidebook doesn't speak to the particulars either.

D
DanielWillis
Contributor
October 17, 2023

Hi Brooks,

There are also some training materials on SIC in OneStream Navigator. I believe they go through the process of setting it up and using it although its been a while since I went through it.

DanielWillis_0-1697584790930.png

- Daniel

Terms & ConditionsAccessibility statement