Exact OnlineLite
Exact Online is an accounting and CRM software.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | DIVISION, GL_ACCOUNT_CLASSIFICATION_MAPPING, LEAD_PURPOSE, PROFIT_LOSS_OVERVIEW, REPORTING_BALANCE, RETURN, REVENUE_LIST, SALES_INVOICE, SALES_INVOICE_LINE, SUBSCRIPTION, and SUBSCRIPTION_LINE tables. | |
| History mode | ||
| Custom data | ||
| Data blocking | ||
| Column hashing | ||
| Re-sync | ||
| Row filtering | ||
| API configurable | API configuration | |
| Priority-first sync | ||
| 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 Exact Online setup guide to connect Exact Online with your destination using Fivetran connectors.
Sync overview
To capture updates, we incrementally sync the following tables and their child tables:
ACCOUNTACCOUNT_CLASSIFICATIONBANKBANK_ACCOUNTCONTACTGL_ACCOUNTGL_CLASSIFICATIONSUBSCRIPTIONSUBSCRIPTION_LINESYSTEM_DIVISIONTRANSACTION_LINEUSERS
To capture updates and deletes, we also re-import the SUBSCRIPTION and SUBSCRIPTION_LINE tables once a week.
We re-import the remaining tables in every sync to capture updates and deletes.
Schema information
This schema applies to all Exact Online connections.
Explore Exact Online schema ERD