# Confluence + ClickHouse

> Integrate tasks, sprints, and projects from Confluence into ClickHouse with Erathos. Centralized, up-to-date productivity data ready for analysis.

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

Erathos connects Confluence to ClickHouse so your Atlassian wiki becomes analyzable data. The native connector authenticates with your site subdomain and an Atlassian API token, then syncs spaces, pages, blogposts, attachments, footer and inline comments, labels, and tasks into tables, preserving how spaces, pages, and nested content relate to each other.

ClickHouse is built for fast analytical queries over large volumes. Confluence spaces, pages, comments, and tasks arrive ready for interactive analytics, so your team can explore wiki activity and content trends at the speed ClickHouse is known for.

## Data in your analytics database in minutes

### Confluence connector ready to use

Connect Confluence to ClickHouse in minutes with our native connector. Authenticate with your site subdomain and an Atlassian API token, then sync spaces, pages, blogposts, attachments, comments, labels, and tasks automatically, with no code required.

### Total control over your Confluence pipelines

Configure schedule, frequency, and sync type at the table level. Most Confluence streams run as full refresh, while streams like tasks sync incrementally with a createdAt cursor, so analytical tables stay current for fast, interactive queries.

### End-to-end observability

Stop finding out about failures only when the business team complains. Every run is logged with runtime, processed rows, and error context. Automatic alerts via Slack, Discord, or email as soon as anything goes off track.

## Consolidating Confluence data in ClickHouse has never been easier

Erathos is a data ingestion platform built for teams that need reliability, visibility, and control. With the Confluence connector, you can automatically move spaces, pages, blogposts, comments, labels, and tasks into ClickHouse, with full observability into every run and zero maintenance.

## FAQ

### How do I connect Confluence to ClickHouse with Erathos?

Erathos is a data ingestion platform built for reliability, transparency, and control. We help data teams connect their SaaS tools, such as Confluence, to their analytics destinations, without the maintenance cost of in-house pipelines or the opacity of traditional ETL tools. Setup takes minutes: name the connection, enter your Confluence site subdomain, and paste an Atlassian API token generated in your Atlassian account. Our customers reduce pipeline maintenance by up to 80%.

### Which Confluence data does Erathos sync to ClickHouse?

Spaces, pages, blogposts, attachments, footer and inline comments, labels, and tasks, plus nested structures like page versions, likes, properties, space permissions, space roles, and classification levels. That is over 60 streams, delivered with their relationships preserved so the data is ready for joins on arrival.

### How often does Erathos synchronize Confluence data to ClickHouse?

You can configure sync frequency at the table level, from every 5 minutes up to once per day. Most Confluence streams run as full refresh, while streams that support it, such as tasks, sync incrementally with a createdAt cursor, so each run processes only what changed.

### What happens if a synchronization fails?

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

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

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