# Sienge + Azure SQL Server

> Centralize Sienge data into Azure SQL Server with Erathos. No-code, incremental pipelines with full observability. Start your 14-day free trial.

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

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

With Erathos, Sienge data arrives in Azure SQL Server already normalized into relational tables, ready to power Power BI reports or internal applications already running in the Microsoft ecosystem.

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

The integration automatically syncs Sienge's core objects:

- **Projects:** daily construction logs, schedules, cost estimates, and physical progress
- **Finance:** accounts receivable, invoices, ledger entries, and cash flow
- **Contracts:** customer data, units, status, and change history
- **Purchasing:** purchase orders, suppliers, quotes, and orders
- **Inventory:** material movements, balances, and requisitions
- **Units:** properties, developments, delivery status, and after-sales

### Why sync Sienge with Azure SQL Server?

In Azure SQL Server, you integrate Sienge data into the Microsoft ecosystem, using Power BI for executive dashboards and Azure Data Factory to orchestrate broader pipelines.

### How it works

Erathos connects to Sienge via its official API and syncs your data incrementally: only new or updated records are processed in each run, keeping pipelines fast and Azure SQL Server costs predictable. You choose the sync frequency (from every 5 minutes to daily), the objects to sync, and the destination dataset. Each execution is logged with complete observability: runtime, rows processed, error context, and instant alerts via Slack or email if anything goes wrong.

## Data in your data warehouse in minutes

### Production-ready Sienge connector

Connect Sienge directly to Azure SQL Server and automatically export your construction, financial, contract, and inventory data. Integrate with Power BI and Azure Synapse without writing a single line of code.

### Complete control over your Sienge pipelines

Configure sync frequency and sync mode per table. Incremental sync for Azure SQL Server — only new records are processed in each run, with predictable costs within the Azure ecosystem.

### End-to-end observability

Stop finding out about pipeline failures only when the business team complains. Every run is logged with its duration, rows processed, and error context. Get automatic alerts via Slack, Discord, or email the moment something goes wrong.

## Centralizing Sienge data into Azure SQL Server has never been easier

Erathos is a data ingestion platform built for operations and data teams. With the Sienge connector, you can automatically export construction, financial, contract, and inventory data into Azure SQL Server — fully integrated into the Microsoft ecosystem.

## 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 Sienge historical data to Azure SQL Server?

Yes. During the first sync, Erathos performs a complete historical load of your Sienge data. From then on, subsequent syncs are incremental — only new or updated records are processed, keeping the pipeline efficient and Azure costs predictable.

### How often does Erathos sync Sienge data to Azure SQL Server?

You can configure sync frequencies 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 your Sienge pipeline efficient and costs predictable.

### What happens if a Sienge sync fails?

Erathos automatically detects failures and sends alerts to your email, Slack, or Discord with full context — not just 'job failed.' 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 comes with a 14-day free trial. Connect Sienge to Azure SQL Server and start syncing immediately—no credit card required.