# Convenia + BigQuery

> Integrate employee data, performance reviews, and headcount from Convenia into BigQuery with Erathos. An automated, observable, maintenance-free pipeline. Start free.

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

Convenia is a human resources management platform that provides an effective way to automate and streamline HR processes such as payroll administration, benefits management, time tracking, and recruiting. BigQuery, in turn, is a serverless Big Data solution developed by Google that delivers robust capabilities for storing and analyzing data at scale.

With Erathos, you can integrate Convenia data into BigQuery in just a few minutes. Our platform handles the entire data movement process into your analytics environment and makes it possible to combine that data with other sources in your Data Warehouse. That means your time is spent on what truly creates value — extracting actionable insights and making more data-driven decisions.

### Which Convenia data does Erathos sync with BigQuery?

The integration automatically syncs Convenia's core objects:

- **Employees** — profile data, role, team, and manager
- **Performance reviews** — ratings, competencies, and cycle feedback
- **Feedback cycles** — conversation history and development plans
- **Headcount** — hires, terminations, and current headcount by team
- **Organizational climate** — survey results and eNPS
- **Goals and OKRs** — objectives, key results, and progress

### Why sync Convenia with BigQuery?

Convenia data stays siloed inside the HR platform, which makes it harder to run cross-analysis against business performance. In BigQuery, you can combine headcount, performance reviews, and engagement data with product and revenue metrics — understanding the real impact people have on outcomes and identifying talent retention patterns early.

### How it works

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

## Data in your data warehouse in minutes

### Ready-to-use Convenia connector

Connect Convenia to BigQuery and automatically export employee, performance review, headcount, and organizational climate data. No intermediary spreadsheets, no scripts.

### Complete control over your Convenia pipelines

Configure schedule, frequency, and sync type at the table level. Incremental synchronization processes only new or modified records—keeping BigQuery costs low and your analyses always up to date.

### 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 BigQuery has never been easier

Erathos is a data ingestion platform for HR and data teams. With the Convenia connector, you can automatically export employee data, performance reviews, and organizational climate insights to BigQuery—without intermediary spreadsheets, without scripts, and with 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 full observability into every run, zero maintenance, and none of the opacity of traditional market tools.

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

Erathos syncs Employee data, Performance Reviews, Feedback Cycles, Headcount, and Organizational Climate from Convenia to BigQuery. Goal information, OKRs, and review history are also exported.

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

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

### What happens if a Convenia 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 Convenia connector?

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