# Convenia + ClickHouse

> Integrate employee data, performance reviews, and headcount from Convenia to Clickhouse with Erathos. Get started for free.

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

Convenia is a human resources management platform that offers an effective approach to automating and simplifying HR processes, such as payroll administration, benefits management, time tracking, and recruitment. ClickHouse, in turn, is a serverless Big Data solution developed by Google, providing robust storage and analysis capabilities for large-scale data.

With Erathos, you can integrate data from Convenia into ClickHouse in just a few minutes. Our platform handles the entire process of moving data to your analytics environment, allowing you to join this data with other sources in your Data Warehouse. This way, your time is focused on what actually drives value — extracting valuable insights and making more data-driven decisions.

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

The integration automatically syncs key Convenia objects:

- **Employees** — profile data, job title, department, and manager
- **Performance Reviews** — scores, competencies, and feedback per cycle
- **Feedback Cycles** — history of 1:1 conversations and IDPs
- **Headcount** — hires, terminations, and current headcount by department
- **Employee Engagement** — survey results and eNPS
- **Goals and OKRs** — objectives, key results, and progress

### Why sync Convenia with ClickHouse?

In ClickHouse, you run OLAP queries on Convenia data in milliseconds, ideal for high-concurrency dashboards and high-volume time series.

### How it works

Erathos connects to Convenia via 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: runtime, processed rows, 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 Convenia connector

Connect Convenia to Clickhouse and automatically export data on employees, performance reviews, headcount, and organizational climate. No intermediary spreadsheets, no scripts.

### Complete control over your Convenia pipelines

Configure frequency and sync mode on a per-table basis. Data lands in ClickHouse optimized for OLAP queries, delivering millisecond-level analytics even across millions of rows.

### End-to-end observability

Stop finding out about Convenia failures only after the business team complains. Every run is logged with runtime, processed rows, and error context. Automated alerts via Slack, Discord, or email the moment something deviates from expected behavior — so HR data is always available for your employee engagement and performance analysis.

## Centralizing Convenia data in ClickHouse has never been easier

Erathos is a data ingestion platform for HR and data teams. With the Convenia connector, you can automatically export employee, performance review, and organizational climate data to ClickHouse — with no intermediate spreadsheets, no 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 Convenia to their data warehouse — with complete observability for every run, zero maintenance, and none of the opacity of traditional tools on the market.

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

Erathos syncs Employee, Performance Review, Feedback Cycle, Headcount, and Organizational Climate data from Convenia to Clickhouse. Goals, OKRs, and review history are also exported.

### How often does Erathos sync data from Convenia to Clickhouse?

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

### What happens if a Convenia 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, rows processed, and error context so your team can debug in minutes, not hours.

### Is there a free trial available for the Convenia connector?

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