Workday RaaS link
Updated November 1, 2023
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.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | All tables and fields |
Custom data | check | All tables and fields |
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | check | |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step Workday RaaS setup guide to connect Workday with your destination using Fivetran connectors.
Schema informationlink
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.
Sync strategylink
The Workday RaaS 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 RaaS 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.
NOTE: Workday does not allow us to sync the reports whose size exceed 2 GB.