Centra Lite
Centra is an ecommerce platform.
Features
| Feature Name | Supported | Notes | 
|---|---|---|
| Capture deletes | check | AFFILIATE,BRAND,BRICK_AND_MORTAR,CAMPAIGN,CATEGORY,COUNTRY,INVOICE,INVOICE_PAYMENT,LOWEST_PRICE,MAPPED_ATTRIBUTE,MARKET,MARKET_CAMPAIGN,NEWSLETTER_SUBSCRIPTION,ORDERS,PRICELIST,PRODUCT_VARIANT,RETURN,STORE, andWAREHOUSEtables and their child 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 Centra setup guide to connect Centra with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables.
- ACCOUNT
- CUSTOMER
- INVOICE
- INVOICE_PAYMENT
- ORDERS
- PRODUCT
- PRODUCT_SIZE
- PRODUCT_VARIANT
- RETURN
- VOUCHER
We also re-import the PRODUCT and PRODUCT_VARIANT tables daily to capture updates and deletes.
We also re-import the following tables once a week to capture updates and deletes:
- INVOICE
- INVOICE_PAYMENT
- ORDERS
- RETURN
We also re-import the following tables and their child tables in every sync to capture updates and deletes:
- AFFILIATE
- BRAND
- BRICK_AND_MORTAR
- CAMPAIGN
- CATEGORY
- COUNTRY
- LOWEST_PRICE
- MAPPED_ATTRIBUTE
- MARKET
- MARKET_CAMPAIGN
- NEWSLETTER_SUBSCRIPTION
- ORDER_LINE
- PRICELIST
- STORE
- WAREHOUSE
Schema information
This schema applies to all Centra connections.
Explore Centra schema ERD