Odoo Lite Private Preview
Odoo is an open-source business application suite. The Odoo connector uses the External API to sync your data.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ||
| Custom data | ||
| Data blocking | ||
| Column hashing | ||
| Re-sync | ||
| Row filtering | ||
| API configurable | API configuration | |
| Priority-first sync | CUSTOMER, SALE_ORDER, PRODUCT, INVOICE, ACCOUNTING, EMPLOYEE, PAYMENT, SALE_REPORT, ACCOUNT_ANALYTIC_LINE, ACCOUNT_MOVE_LINE, SALE_ORDER_LINE, MAIL_TRACKING_VALUE, MAIL_MESSAGE, ACCOUNT_TAX, STOCK_PICKING, STOCK_MOVE, STOCK_LOCATION, STOCK_WAREHOUSE, and STOCK_QUANT tables. | |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
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 Odoo setup guide to sync data returned by the Odoo External API into your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables.
CUSTOMERSALE_ORDERPRODUCTINVOICEACCOUNTINGEMPLOYEEPAYMENTSALE_REPORTACCOUNT_ANALYTIC_LINEACCOUNT_MOVE_LINESALE_ORDER_LINEMAIL_TRACKING_VALUEMAIL_MESSAGEACCOUNT_TAXSTOCK_PICKINGSTOCK_MOVESTOCK_LOCATIONSTOCK_WAREHOUSESTOCK_QUANT
Schema information
This schema applies to all Odoo connections.
Explore Odoo schema ERD