Brightpearl Lite
Brightpearl by Sage is the industry-leading operating system for retailers.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | COMPANY, CONTACT_GROUP, CONTACT_GROUP_DETAIL, GOODS_IN_NOTE, GOODS_OUT_NOTE_DETAIL, GOOD_IN_NOTE_DETAIL, and WAREHOUSE tables. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | CONTACT, ORDER_DETAIL, and PRODUCT tables and their child tables. |
| 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 Brightpearl setup guide to connect Brightpearl with your destination using Fivetran connectors.
Sync overview
To capture new records and updates, we incrementally sync the following tables and their child tables:
CONTACTCONTACT_DETAILGOODS_IN_NOTEGOOD_IN_NOTE_DETAILGOODS_OUT_NOTE_DETAILORDER_DETAILPRODUCTPRODUCT_DETAIL
To capture deletes, we re-import the following tables and their child tables once a week:
GOODS_IN_NOTEGOOD_IN_NOTE_DETAILGOODS_OUT_NOTE_DETAIL
To capture new records, updates, and deletes, we perform a full re-sync for the following tables and their child tables:
COMPANYCONTACT_GROUPCONTACT_GROUP_DETAILWAREHOUSE
Schema information
This schema applies to all Brightpearl connections.
Explore Brightpearl schema ERD