ADP Workforce Now
ADP Workforce Now is a payroll and HR platform.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | check | WORK_ASSIGNMENT_HISTORY table |
| Custom data | check | |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
* 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 guide
Follow our step-by-step ADP Workforce Now setup guide to connect ADP Workforce Now with your destination using Fivetran connectors.
Schema information
This schema applies to all ADP Workforce Now connectors.
To zoom, open the ERD in a new window.Sync note
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.