# Agendor + ClickHouse

> Automatically transfer contacts, deals, and activities from Agendor to ClickHouse with Erathos. Incremental pipeline, zero maintenance, and complete observability. Get started for free.

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

Agendor is a CRM platform for sales management and customer relationships that allows tracking sales funnels and organizing contacts. ClickHouse is an open-source columnar analytical database designed for fast queries and real-time processing of large volumes of data.

With Erathos, Agendor data lands in ClickHouse optimized for OLAP, ready for high-concurrency dashboards and sub-second analytics, even on massive volumes of data.

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

The integration automatically syncs key Agendor objects:

- **Contacts**: emails, lifecycle stages, and custom properties
- **Companies**: firmographic data, industry, and activity history
- **Deals**: pipeline stages, values, and close dates
- **Activities**: calls, meetings, tasks, and sales team notes
- **Interaction history**: emails, calls, and engagement logs
- **Custom fields**: properties created by your team are automatically included

### Why sync Agendor to ClickHouse?

With ClickHouse, you can run OLAP queries on Agendor data in milliseconds, making it ideal for high-concurrency dashboards and large-volume time-series analysis.

### How it works

Erathos connects to Agendor 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 (from 5 minutes to daily), the objects to sync, and the destination dataset. Every run is logged with full observability: execution time, rows processed, error context, and instant alerts via Slack or email if anything goes wrong.

## Data in your data warehouse in minutes

### Agendor Connector Ready to Use

Connect Agendor to ClickHouse in minutes with our native connector. Contacts, deals, companies, and activities are synced automatically—without a single line of code and with support for custom properties.

### Complete control over your Agendor pipelines

Configure frequency and insertion mode per table. Data arrives in ClickHouse in a format optimized for OLAP queries — analyze millions of rows in milliseconds.

### End-to-end observability

No more learning about Agendor failures when the business team complains. Every run is logged with runtime, rows processed, and error context. Get automatic alerts via Slack, Discord, or email as soon as something deviates from expected behavior — so your data team doesn’t have to rely on the business team to catch issues.

## Centralizing Agendor data in ClickHouse has never been so simple

Erathos is a data ingestion platform built for teams that need reliability, visibility, and control. With the Agendor connector, you automatically move contacts, deals, companies, and sales activities to ClickHouse—with complete observability for every run and zero maintenance.

## 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 Agendor to their data warehouse—with complete observability into every run, zero maintenance, and without the opacity of traditional market tools.

### What Agendor data does Erathos synchronize to ClickHouse?

Erathos syncs Agendor’s main objects: Contacts, Companies, Opportunities/Deals, Activities, Tasks, and Interaction History. Custom fields created by your team are also supported and become automatically available in ClickHouse.

### How often does Erathos synchronize data from Agendor to ClickHouse?

You can configure the synchronization frequency from every 5 minutes up to daily, at the table level. Erathos uses incremental synchronization—only new or updated records are processed in each run, keeping the Agendor pipeline efficient and ClickHouse costs predictable.

### What happens if an Agendor synchronization 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 execution is logged with run time, processed rows, and error context so your team can debug in minutes, not hours.

### Is there a free trial period for the Agendor connector?

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