Follow our setup guide to connect Workday to Fivetran.
To connect Workday to Fivetran, you need:
- An active Workday report URL
- The username and password to access that Workday report URL
- To configure the reports as Advanced type reports to enable web service access
Note: You must add a separate Workday connector in your Fivetran dashboard for each report. Each Workday connector will sync its report data to its own table in your destination.
Create a new userlink
In your Workday account, create a new user with sufficient permissions to download reports.
Create custom reportslink
In the same Workday account, create one or more custom reports.
Finish custom report configurationlink
In each custom report’s Advanced tab, share each report to Report-as-a-WebService.
For each report, go to Actions --> Web Service --> View URLs. Make a note of the REST URL. You will need it to fill in your Fivetran connector setup form.
Test each report by pasting it into a new browser session, and log in using the Fivetran ELT web service user. If the Report XML does not display, check your user security settings.
Select the primary key(s). To track history of the report data, make a timestamp column part of the composite primary key.
Finish Fivetran configuration link
In your connector setup form, enter your chosen destination schema name.
Enter your chosen destination table name.
Enter the username and password for the Fivetran ELT user you created in Step 1.
Enter the report URL you found in Step 3.
Click Save & Test. Fivetran will take it from here and sync your data from your Workday account.