Workday is a cloud ERP system for finance, HR, and planning.
Fivetran syncs Workday Report-as-a-Service (RaaS) reports to the destination on regular basis. In Workday RaaS, you can create as many Custom Reports as you need.
NOTE: To sync data from your Workday Human Capital Management (HCM) application, see our Workday HCM connector documentation.
|Capture deletes||check||All tables and fields|
|Custom data||check||All tables and fields|
|Data blocking||check||Column level|
|Fivetran data models|
Follow our step-by-step Workday setup guide to connect Workday with your destination using Fivetran connectors.
We support Workday reports in JSON format. We give you the option to select the primary keys because the reports are dynamically generated. After you select the primary keys, we sync the entire report.
The Workday connector doesn’t support incremental syncs. During each sync, we re-sync the connector to fetch the complete report. We overwrite the data in your destination table with the new report data.
We use the report URL that you specify to sync the report data to your destination table.
NOTE: If you want to sync multiple Workday reports, you must add a separate Workday connector in your Fivetran dashboard for each report.
Because Workday conducts scheduled maintenance every Friday night (PST), we reschedule your sync by 6 hours to ensure your connectors don’t fail repeatedly. After maintenance is over, syncs return to the normal schedule.