Workday RaaS

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.

Features

Supported deployment models

We support the SaaS and Hybrid deployment models for the connector.

Setup guide

Follow our step-by-step Workday RaaS setup guide to connect Workday with your destination using Fivetran connectors.

Schema information

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 strategy

By default, we do complete re-syncs of reports to sync their data. We also allow you to use the following two dynamic sync strategies to sync the report data from each report to your destination table:

• Sync updates from last sync: This strategy syncs the report incrementally. First, we sync the data from given start date till current date then subsequent syncs are from the last synced date till current date.

• Sync updates from report start: This strategy will sync the report from the given start date to current date during each sync.

Workday conducts scheduled maintenance every Friday night (PST). To avoid sync failures, we reschedule your sync by 6 hours during this time. After maintenance is over, syncs return to the normal schedule.

Dynamic query parameters

The connection cannot incrementally sync a report if you specify both the query parameters as static values. For example, we cannot incrementally sync the report for which, the URL is https://hostname/custom_report?Start_Date=2001-10-10-07%3A00&End_Date=2024-01-01, and the query parameters, Start_Date and End_Date. are static values. In this case, we re-sync the connection during each sync to fetch the complete report and overwrite the data in your destination table with the new report data.

To incrementally sync your reports, specify the following in the connection setup form:

1. Enable Dynamic Parameters: Set this toggle to ON to use dynamic parameters in the report URL.
2. Enter Report Start Date Field: This field determines which date we start the sync from. Enter the query parameter field from your report which will be either set to the value of Select report start date or last synced date based on the selected sync strategy.
3. Enter Dynamic Parameter Field: Enter the query parameter field from your report which will be updated dynamically to the current date.
4. Select report start date: The date from which you want to sync the report data.
5. Choose sync strategy for your connector: The sync strategy you want to use for the connection.
   • Sync updates from last sync: This strategy syncs the report incrementally. In the first sync, we sync the report from the Select report start date to the current date. Then for subsequent syncs, the Enter Report Start Date Field value is set to the last synced date and Enter Dynamic Parameter Field value is set to the current date.
   • Sync updates from report start: This strategy will sync the report from you selected report start date to the current date during each sync. Enter Report Start Date Field value is set to Select report start date and Enter Dynamic Parameter Field value will be set to current date.

Example 1:

Let's assume you want to incrementally sync your report and capture all the changes made to the report between January 1, 2015 and the current date in each incremental sync.

You can achieve this by specifying the following parameters for report in the setup form:

1. Enter Report Start Date Field: Start_Date
2. Enter Dynamic Parameter Field: End_Date
3. Select report start date: 2015-01-01
4. Choose sync strategy for your connector: Sync updates from report start

In this scenario, we do the following:

• During the initial sync, we sync all the records that were created on or after January 1, 2015.
• During every incremental sync, we sync all the changes made to the report data between January 1, 2015 and the current date on which we perform the incremental sync.

Example 2:

Let's assume you want:

• the initial sync to capture all the records created on or after January 1, 2015, and
• the subsequent incremental syncs to capture only the changes made to the report between the last sync date and the current date

You can achieve this by specifying the following parameters for report in the setup form:

1. Enter Report Start Date Field: Start_Date
2. Enter Dynamic Parameter Field: End_Date
3. Select report start date: 2015-01-01
4. Choose sync strategy for your connector: Sync updates from last sync

In this scenario, we do the following:

• During the initial sync, we sync all the records that were created on or after January 1, 2015.
• During every incremental sync, we sync all the changes made to the report between the date on which we performed the last sync and the current date on which we perform the incremental sync.

Example 3:

Let's assume you want the incremental syncs to capture only the changes made to the report between the last sync date and the current date.

You can achieve this by specifying the following parameters for report in the setup form:

1. Enter Report Start Date Field: Start_Date
2. Enter Dynamic Parameter Field: End_Date
3. Select report start date: ( Select the date when the report was created or any earlier date )
4. Choose sync strategy for your connector: Sync updates from last sync

In this scenario, we do the following:

• During the initial sync, we sync all the records that were created since the report creation date.
• During every incremental sync, we sync all the changes made to the report between the date on which we performed the last sync and the current date on which we perform the incremental sync.

UTC conversion

We don't convert source timestamps to Universal Time Coordinated (UTC) but use Pacific Standard Time (PST) to store the data in your destination.