# Teamwork + Azure Synapse

> Integrate Teamwork tasks, sprints, and projects with Azure Synapse using Erathos. Centralized, up-to-date productivity data ready for analysis.

Source: https://www.erathos.com/en/pipelines/teamwork-azure-synapse
Em português: https://www.erathos.com/pipelines/teamwork-azure-synapse

Teamwork is a project management and collaboration platform that offers a variety of tools for teams to work efficiently. Azure Synapse, on the other hand, is a serverless Big Data solution developed by Microsoft, providing robust storage and data analysis capabilities at scale.

With Erathos, you can integrate Teamwork data into Azure Synapse in a few minutes. Our platform handles the entire data movement process to your analytical environment, allowing you to blend 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 Teamwork data does Erathos sync with Azure Synapse?

The integration automatically syncs key Teamwork objects:

- **Projects** — status, assignees, dates, and configurations
- **Tasks and subtasks** — priority, status, estimates, and assignees
- **Sprints** — dates, velocity, and planning data
- **Members** — users, roles, and workload
- **Comments** — discussion history and decisions
- **Custom fields** — team-defined properties and tags

### Why sync Teamwork with Azure Synapse?

In Azure Synapse, you integrate Teamwork data into the Microsoft ecosystem: Power BI for executive dashboards, Azure Data Factory for orchestration, and distributed analytics at enterprise scale.

### How it works

Erathos connects to Teamwork via its official API and syncs your data incrementally — only new or updated records are processed in each run, keeping your pipelines fast and Azure Synapse 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 anything goes wrong.

## Data in your data warehouse in minutes

### Out-of-the-box Teamwork connector

Connect Teamwork to Azure Synapse and automatically export tasks, projects, sprints, and members. Centralized productivity data for analysis — zero CSVs, zero scripting.

### Complete control over your Teamwork pipelines

Configure sync frequency and type per table. Data arrives in Azure Synapse integrated with the Microsoft ecosystem, Power BI, Azure Data Factory, and ML pipelines ready for use.

### End-to-end observability

Stop finding out about Teamwork failures only after the business team complains. Every run is logged with runtime, rows processed, and error context. Get automatic alerts via Slack, Discord, or email the moment something goes off track — with always-fresh productivity data for your sprint reports.

## Centralizing Teamwork data in Azure Synapse has never been easier

Erathos is a data ingestion platform built for operations and data teams. With the Teamwork connector, you can automatically export tasks, projects, sprints, and productivity metrics to Azure Synapse — keeping your productivity data centralized and ready for analytics.

## 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 Teamwork to their data warehouse — with full observability of every run, zero maintenance, and without the opacity of traditional market tools.

### Which Teamwork data does Erathos sync to Azure Synapse?

Erathos syncs Projects, Tasks, Subtasks, Members, Sprints, Statuses, and Comments from Teamwork to Azure Synapse. Custom fields, tags, and task dependencies created by the team are also exported.

### How often does Erathos sync data from Teamwork to Azure Synapse?

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 Teamwork pipeline efficient and Azure Synapse costs predictable.

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

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