# Kommo + ClickHouse

> Integrate contacts, deals, and conversations data from Kommo into ClickHouse with Erathos. Automated, observable, and maintenance-free pipelines. Get started for free.

Source: https://www.erathos.com/en/pipelines/kommo-clickhouse
Em português: https://www.erathos.com/pipelines/kommo-clickhouse

Kommo is a conversational CRM, formerly known as amoCRM, built around messaging channels like WhatsApp, featuring a visual sales funnel and automations.

With Erathos, your Kommo data is delivered to ClickHouse in an OLAP-optimized format, ready for high-concurrency dashboards and millisecond-level analytics, even over massive data volumes.

### What Kommo data does Erathos sync with ClickHouse?

The integration automatically syncs the main Kommo objects:

- **Contacts**: profile data and history for each lead
- **Deals**: stage, value, and owner for each opportunity
- **Sales funnels**: stage structures configured in Kommo
- **Chats**: message history by channel
- **Tasks**: activities and follow-ups logged by the team

### Why sync Kommo to ClickHouse?

In ClickHouse, you can run OLAP queries on your Kommo data in milliseconds—ideal for high-concurrency dashboards and high-volume time-series analysis.

### How it works

Erathos connects to Kommo via the official API and syncs your data incrementally: only new or updated records are processed in each run, keeping pipelines fast and ClickHouse costs predictable. You choose the sync frequency (ranging from 5 minutes to daily), the objects to sync, and the destination dataset. Every run is logged with full observability: execution time, rows processed, errors with context, and instant alerts via Slack or email if anything goes wrong.

## Data in your data warehouse in minutes

### Out-of-the-box Kommo connector

Connect Kommo to ClickHouse and automatically export contacts, leads, and conversations. No intermediate spreadsheets, no scripts.

### Complete control over your Kommo pipelines

Configure the schedule, frequency, and sync mode at the table level. Incremental sync processes only new or updated records, keeping your ClickHouse costs predictable and your data always up to date.

### End-to-end observability

Stop finding out about Kommo pipeline failures only when the business team complains. Every execution is logged with run times, rows processed, and error context. Get automated alerts via Slack, Discord, or email the moment something goes wrong.

## Centralizing Kommo data into ClickHouse has never been this simple

Erathos is a data ingestion platform built for commercial and data teams. With the Kommo connector, you can automatically export contacts, deals, and conversations directly to Clickhouse—with zero intermediary spreadsheets, no custom scripts, and full observability.

## FAQ

### What is Erathos and how can it help my company?

Erathos is a data ingestion platform built for reliability, transparency, and control. We help data teams connect tools like Kommo to their data warehouse, with complete observability of every run, zero maintenance, and none of the opacity of traditional market tools.

### What Kommo data does Erathos sync to ClickHouse?

Erathos syncs Kommo contacts, deals, sales pipelines, conversations, and tasks directly to Clickhouse.

### How often does Erathos sync data from Kommo to ClickHouse?

You can configure the sync frequency from every 5 minutes to daily, at the table level. Erathos uses incremental sync, meaning only new or updated records are processed in each run, keeping your Kommo pipeline efficient and Clickhouse costs predictable.

### What happens if a Kommo sync fails?

Erathos automatically detects failures and sends alerts to your email, Slack, or Discord with full context—not just "job failed." Smart retries handle transient errors, and every run is logged with runtime, processed rows, and error context so your team can debug in minutes, not hours.

### Is there a free trial for the Kommo connector?

Yes. Every Erathos connector includes a 14-day free trial. Connect Kommo to ClickHouse and start syncing immediately, no credit card required.