ClickHouse — the columnar analytics engine for real-time ERP reporting
Financial reports in 4softerp — trial balance, cash flow, profit and loss, cost center analysis — run on ClickHouse. A columnar engine designed for aggregations across tens of millions of rows in milliseconds, not minutes.
Why ClickHouse for ERP analytics
OLAP queries on millions of transactions in < 1 second
ClickHouse compresses and reads only the columns needed by a report — a sum on account 4111 over 3 years of transactions runs in under 200 ms regardless of total volume.
Real-time cash flow dashboards
Payment, collection and bank statement events are streamed into ClickHouse via Kafka. The cash flow dashboard reflects today's state, without nightly batch jobs.
Multi-company aggregations without ETL
Group reports — consolidated balance sheet, consolidated P&L, intercompany — run directly on ClickHouse tables partitioned by company_id, without moving data to a separate data warehouse.
LZ4 + Zstd compression on financial data
Accounting data compressed with Zstd achieves 15–20× ratios, reducing storage cost on 10-year fiscal archives.
Materialized Views for pre-computed KPIs
Critical KPIs (stock rotation, DSO, DPO, cash days) are incrementally pre-computed via Materialized Views — displayed instantly without complex queries on every refresh.
Native PostgreSQL integration via PeerDB
Changes from PostgreSQL (OLTP source) are replicated into ClickHouse via PeerDB CDC without discernible latency — one source of truth, two specialized engines.
FAQ about ClickHouse in 4softerp
Does ClickHouse replace PostgreSQL in 4softerp?
No. PostgreSQL is the OLTP source of truth (writes, transactions). ClickHouse is the OLAP layer (analytical reads, reports). The two are automatically synchronized.
Can I export ClickHouse reports to Excel?
Yes — all dashboard reports have a CSV/XLSX export button. The REST API also allows direct queries with JWT authentication.
How long does it take to generate a 5-year balance sheet?
Under 2 seconds for a single company, under 10 seconds for a group of 20 companies — thanks to pre-computed Materialized Views.
Is ClickHouse available in a self-hosted version?
Yes. 4softerp Enterprise includes a dedicated ClickHouse deployment on the client's infrastructure, with assisted migration.
Instant financial reports with ClickHouse
Try 4softerp free for 6 months and see how your company's balance, cash flow and P&L are generated in seconds.