Automated sync of all 38 Zoho Books streams into your PostgreSQL. Multi-tenant, AES-256 encrypted, with full medallion audit history.
Capabilities
Built for production. Not a weekend script.
Set your interval, we handle the rest. Delta sync minimises Zoho API quota — only changed records are fetched each cycle.
Append-only Bronze layer captures every version of every record. Replay from any checkpoint, travel to any point in time.
One instance serves unlimited customers with complete data isolation — no shared state, no cross-tenant leakage, ever.
Connect with a single click. Credentials encrypted at rest with Fernet (AES-256). Token rotation handled automatically.
Per-tenant health dashboard with run logs, failure streak detection, and extract / transform / load counters per cycle.
We provision the PostgreSQL schema automatically on first connect. Point us at any database — no manual DDL required.
Architecture
Industry-standard Bronze / Silver / Gold pattern. Raw data preserved forever, typed data always available, aggregations ready.
Every API response stored verbatim as NDJSON. The immutable source of truth that can be replayed at any time without touching Zoho again.
Parsed, typed, and deduplicated records in DuckDB Silver tables. Schema-stable layer your application queries can rely on.
Canonical schema loaded directly into your PostgreSQL — ready for BI tools, dashboards, and production application queries.
Coverage
Every major Zoho Books entity covered out of the box. Incremental delta sync for all streams.
Workflow
Authenticate via Zoho OAuth with one click, or paste your refresh token. Credentials are AES-256 encrypted and stored securely in the control plane.
The connector fetches delta changes from all 38 streams, lands raw data in Bronze, parses it into typed Silver tables with full provenance audit trail.
Canonical schema appears in your PostgreSQL. Connect any BI tool, run your SQL queries, build dashboards — data is always fresh and consistent.
Self-hosted, open-source, no vendor lock-in. Deploy with Docker in five minutes.
Deploy your own →