Edit on GitHub
ADP Workforce Now link
ADP Workforce Now is a payroll and HR platform.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| Custom data | check | |
| Data blocking | check | Column level |
| Column hashing | check | |
| Re-sync | check | Table level |
| History | ||
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking |
* NOTE: We also capture history for the
PERSON_HISTORYtable, but not in the usual way. This table does not contain history columns. Instead, we infer the active records based on the_fivetran_synccolumn.
Setup guidelink
Follow our step-by-step ADP Workforce Now setup guide to connect ADP Workforce Now with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all ADP Workforce Now connectors.
To zoom, open the ERD in a new window.Sync notelink
We perform a daily historical sync to avoid data integrity issues caused by unreliable event queues from ADP. We have observed the following issues regarding ADP event queues:
- Multiple applications can simultaneously use the ADP event queue. Once we consume an event from the queue, we delete it as per the ADP guidelines. However, we have observed that the application which reads the event from the queue first gets the event, and other applications miss the event in the queue.
- We have observed multiple instances where events were not sent from ADP, even if there was only one consumer for the event queue.