KeyPay Lite
KeyPay is a cloud-based payroll and workforce management platform.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | ESS_LEAVE_REQUEST , ESS_ROSTER_SHIFT , ESS_UNAVAILABILITY , and INVOICE tables. |
History mode | ||
Custom data | ||
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 |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step-by-step KeyPay setup guide to connect KeyPay with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
EMPLOYEE
ESS_LEAVE_REQUEST
ESS_ROSTER_SHIFT
ESS_UNAVAILABILITY
INVOICE
TIMESHEET
To capture updates and deletes, we also re-import the EMPLOYEE
and TIMESHEET
tables and their child tables once a week.
Schema information
This schema applies to all KeyPay connectors.
Explore KeyPay schema ERD