Skip to main content

Community

Connector Improvement: Workday history mode

Not planned

Please sign in to leave a comment.

Comments

3 comments

  • Official comment

    Hi James - 

    Erin here, PM for Operations Connectors! Thanks for submitting this request! We don't have this planned at this time. We will continue to collect customer demand to justify the commitment to support & maintain a high-quality Fivetran connector. Every upvote on this request increases the case to build it.
    Best, 

    Erin

    This feature would have amazing analytical benefit to our organisation!

    Since the workday connector uses raas reports instead of connecting to workday directly, we have a lot of limitations.

    1) Some business objects 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.

    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.