# Sienge + ClickHouse

> Integrate construction, financial, contract, and inventory data from Sienge to Clickhouse with Erathos. Start your 14-day free trial.

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

Sienge is the leading technology ecosystem in the construction and real estate development industry in Brazil. Used by more than 9,000 customers — including 77 of the country's top 100 construction companies —, Sienge centralizes project management, finance, purchasing, contracts, inventory, and after-sales in a single integrated platform. ClickHouse is the fully managed and serverless data warehouse designed for large-scale analytics. Together, they form a powerful combination for teams that need to transform operational construction data into business intelligence.

With Erathos, you can integrate Sienge data into ClickHouse in just a few minutes. Our platform handles the entire data movement process to your analytical environment, allowing this data to be joined with other sources in your Data Warehouse. This way, your time is focused on what truly drives value — extracting valuable insights and making more data-driven decisions.

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

The integration automatically syncs the main Sienge objects:

- **Projects (Obras)** — daily logs, schedules, cost estimates, and physical progress
- **Finance** — accounts receivable, bank slips, ledger entries, and cash flow
- **Contracts** — customer data, units, status, and amendment history
- **Purchasing** — orders, suppliers, quotes, and purchase orders
- **Inventory** — material movements, balances, and requisitions
- **Units** — real estate properties, developments, delivery status, and after-sales

### Why sync Sienge with ClickHouse?

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

### How it works

Erathos connects to Sienge 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 every 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 something goes wrong. No black box. No surprises. Full control.

## Data in your data warehouse in minutes

### Production-ready Sienge connector

Connect Sienge to Clickhouse in minutes with our native connector. Construction, Finance, Contracts, Purchasing, and Inventory synchronized automatically, without writing a single line of code.

### Complete control over your Sienge 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 pipeline failures only when the business team complains. Every run is logged with its run time, rows processed, and error context. Get automatic alerts via Slack, Discord, or email the moment something goes wrong.

## Centralizing Sienge data into ClickHouse has never been easier

Erathos is a data ingestion platform built for teams that demand reliability, visibility, and control. With the Sienge connector, you can automatically move construction, financial, contract, and inventory data into 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 their tools—like Sienge—to their data warehouse, without the maintenance overhead of in-house pipelines or the opacity of traditional ETL tools. Our customers reduce pipeline maintenance by up to 80%.

### Does Erathos sync historical data from Sienge to Clickhouse?

Yes. During the first sync, Erathos performs a full historical load of your Sienge data. From then on, subsequent syncs are incremental—processing only new or updated records to keep your pipeline efficient and your Clickhouse costs predictable.

### How often does Erathos sync Sienge data to Clickhouse?

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

### What happens if a Sienge sync fails?

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

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

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