Lucca Lite
Lucca is a software solution to automate the HR and administrative processes.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | DEPARTMENT, LEAVE, LEAVE_ACCOUNT, LEAVE_PERIOD and LEAVE_REQUEST tables. |
| History mode | ||
| Custom data | check | |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | USERS table and their child tables. |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Lucca setup guide to connect Lucca with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the LEAVE, LEAVE_ACCOUNT, LEAVE_PERIOD, LEAVE_REQUEST, and USERS tables.
We also re-import the LEAVE and LEAVE_REQUEST table once a week to capture deletes.
To capture updates and deletes, we re-import the remaining tables during every sync.
Schema information
This schema applies to all Lucca connectors.
Explore Lucca schema ERD