Workday Reference
Supported objects
Collection Name | Read | Write |
---|---|---|
Absence Management | ✅ | ✅ |
Accounts Payable | ✅ | ✅ |
Benefit Partner | ✅ | ✅ |
Budgets | ✅ | ✅ |
Business Process | ✅ | ✅ |
Common | ✅ | ✅ |
Compensation | ✅ | ✅ |
Connect | ✅ | ✅ |
Contract Compliance | ✅ | ✅ |
Core Accounting | ✅ | ✅ |
Custom Object Data (multi-instance) | ✅ | ✅ |
Custom Object Data (single-instance) | ✅ | ✅ |
Customer Accounts | ✅ | ✅ |
Expense | ✅ | ✅ |
Fin Tax Public | ✅ | ✅ |
Global Payroll | ✅ | ✅ |
Help Case | ✅ | ✅ |
Holiday | ✅ | ✅ |
O Auth Client | ✅ | ✅ |
Payroll | ✅ | ✅ |
Performance Enablement | ✅ | ✅ |
Person | ✅ | ✅ |
Prism Analytics | ✅ | ✅ |
Privacy | ✅ | ✅ |
Procurement | ✅ | ✅ |
Projects | ✅ | ✅ |
Recruiting | ✅ | ✅ |
Request | ✅ | ✅ |
Revenue | ✅ | ✅ |
Staffing | ✅ | ✅ |
Student Academic Foundation | ✅ | ✅ |
Student Core | ✅ | ✅ |
Student Curriculum | ✅ | ✅ |
Student Engagement | ✅ | ✅ |
Student Finance | ✅ | ✅ |
System Metrics | ✅ | ✅ |
Talent Management | ✅ | ✅ |
Time Tracking | ✅ | ✅ |
Worktag | ✅ | ✅ |
Wql | ✅ | ✅ |
Setup & installation
In Sequin, click Add sync and select Workday. You can then authenticate Sequin to Workday by entering the following required fields into Sequin:
- Hostname
- Tenant ID
- Username
- Password
https://
nor particular endpoint URL.For example, if you want to use this SOAP endpoint: https://wd2-impl-services1.workday.com/ccx/service/your_company/Human_Resources/v40.1
, enter wd2-impl-services1.workday.com
. If you don’t have a hostname, enter wd2-impl-services1.workday.com
.
You can find your tenant ID from your URL when you are logged into Workday. For example, if the URL is https://impl.workday.com/your_company/d/home.html, then your tenant ID is your_company.
The syncing process
We first backfill your database with all your Workday data. The time for the backfill depends on the size of your Workday account. Unless your Workday account has over a million records, the backfill should complete in under an hour. Smaller accounts complete in just a few minutes. We’ll email you when your backfill is complete and Sequin has loaded all your data into your database.
After the initial backfill, we’ll rely on Workday webhooks to monitor changes. We backstop webhooks with an occasional polling process to ensure we don’t miss any events. This means changes on Workday should propagate to your database in just a few seconds.
Learn more about our syncing process.
Read and write Workday data using SQL
You’ll connect to your database via Sequin’s Postgres Proxy, which lets you read from your synced tables as well as write to them. You can use any SQL client that works with Postgres.
Here’s an example of what your Workday tables might look like in your database:
You’ll see all the Workday objects you selected when setting up your sync are now tables in your database. You’ll also see a _sync_cdc
table which Sequin uses to manage your sync.
Here’s what it looks like to query the worker
table:
Which returns a row that looks like:
Writing back to Workday is as simple as writing a SQL query. For example, you can mark a user’s email as verified like this:
Sequin will write this change to both Workday and your database at the same time.
If a write to Workday fails, Sequin will roll back the write to your database. For example, if you try to update a user’s email to an invalid email address, you’ll receive a Postgres error:
Next steps
Your Workday tables are now available as fully readable and writeable tables in your database. You can query for all your data using SQL, and mutate data thanks to Sequin’s Postgres Proxy. To build on this foundation, here are some next steps:
- Setup your ORM to work with your synced tables.
- Edit the Workday objects and properties you’re syncing at any time.
- Create views on your Workday data to tailor your schema to your needs.
- Invite your team to your Sequin account and start building!
If you need assistance setting up your sync, just send us a note. We’re around and eager to help.