7shifts Lite
7shifts is a team management software for restaurants.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | AVAILABILITY_REASON, COMPANY, COMPANY_INACTIVE_REASON, COMPANY_LABOUR_SETTING, DAY_PART_SETTING, DEPARTMENT, LOCATION, LOG_BOOK_CATEGORY, SHIFT, TASK_LIST_TEMPLATE, TASK_MANAGEMENT_SETTING, TIME_PUNCH, and USERS 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 7shifts setup guide to connect 7shifts with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
AVAILABILITYDAILY_SALES_LABORDAILY_STATSDEPARTMENTENGAGE_OVERVIEWEVENTLOG_BOOK_COMMENTLOG_BOOK_POSTRECEIPTROLESHIFTSHIFT_FEEDBACKTASK_LISTTASK_LIST_DAILY_SUMMARYTIME_OFFTIME_PUNCHUSERSUSER_WAGE
We re-import the remaining tables in every sync to capture updates and deletes.
Schema information
This schema applies to all 7shifts connections.
Explore 7shifts schema ERD