Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

New Connector: Workday Finance & Ops SOAP API Connector

Answered
Jeff Skoldberg User
  • Edited

The existing Workday Finance and Ops connector only connects to a RaaS report, not workday directly.

This causes many limitations.

1) Some business objects in Workday RaaS require report prompts, such as fiscal year, period, etc.  We cannot create a URL that pulls all the data.  Instead, we need to update the URL every month due to the required prompts.

2) raas cannot export more than 2gb of xml.  We have an example of a only 500K rows producing more than 2gb xml because of how space inefficient xml is. 

The above limitations are causing us to not use fivetran and instead build custom python code to loop through all of the fiscal years, periods for the prompt issue... or pull the data in even smaller chunks for the size issue.

Having a connector that hits the workday api directly (not the report api) would fix all of this.

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Erin Fivetranner

    Hi Jeff - 

    We now support a Workday API based connector that uses Workday's SOAP API. We currently support the  core HCM module, which is included in the Human Resources Web Service. We plan to expand to more Workday modules overtime. 

    This connector was released into GA earlier this month! 
    You can set up this connector here: https://fivetran.com/dashboard/add-connector?serviceId=workday_hcm

     

  • Jeff Skoldberg User
    • Edited

    Hi Erin

    I meant to specify we need this for Workday Finance & Ops.  I will change the title of my post to specify this.

    Can you please undo the "Completed" status on this?

    Thank you!

    Jeff

  • Erin Fivetranner

    Yup! Changed the status. 

    This is a connector we are interested in supporting however we have not planned it as of yet. I would like to chat more with you. I will reach out directly.