ADP Workforce Now is a payroll and HR platform.
|Data blocking||check||Column level|
|API configurable||check||API configuration|
|Fivetran data models|
* 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
Follow our step-by-step ADP Workforce Now setup guide to connect ADP Workforce Now with your destination using Fivetran connectors.
This schema applies to all ADP Workforce Now connectors.To zoom, open the ERD in a new window.
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.