# Azure Synapse by Bravas Technology
> Bravas Technology is an Implementation Partner and Managed Service Provider (MSP) of Mitti products. We were built by former employees who have 15+ years collective experience working with Mitti and its clients. We have successfully implemented Mitti across 100+ businesses and are experts in solving complex operational problems with technology. Bravas Technology is a Gold Mitti Partner.

Canonical page: https://integrations.mitti.com/partners/azure-synapse-by-bravas-technology
Marketplace: Mitti
Last updated: 2026-08-10
Logo: https://assets.partnerfleet.app/i8d46flwif0n60hggf0qkd6jc9a4

## At a glance
- Categories: [Data Warehouse and Analytics](https://integrations.mitti.com/t/categories/data-warehouse-and-analytics)
- Features: [Inspections](https://integrations.mitti.com/t/features/inspections), [Actions](https://integrations.mitti.com/t/features/actions), [Issues](https://integrations.mitti.com/t/features/issues), [Schedules](https://integrations.mitti.com/t/features/schedules), [Assets](https://integrations.mitti.com/t/features/assets), [Users](https://integrations.mitti.com/t/features/users), [Training](https://integrations.mitti.com/t/features/training)
- Pricing: Enterprise Pricing
- Website: [bravastech.com](https://bravastech.com)

## Call to actions
- **Contact Us** — submit the contact form on https://integrations.mitti.com/partners/azure-synapse-by-bravas-technology

## Features
- **Dedicated SQL Warehouse Modelling** — Mitti data is transformed into structured fact and dimension tables inside Synapse SQL pools. Stored procedures apply business rules, incremental merges, and KPI calculations. The resulting warehouse supports scalable enterprise reporting.
- **Synapse Pipeline Orchestration** — Synapse pipelines manage API ingestion, Bronze to Silver transformation, and Gold promotion workflows. Incremental and full-load logic is centrally controlled. Batch IDs ensure traceability and reconciliation.
- **ADLS Gen2 Storage Layer** — Raw and curated datasets are stored in Azure Data Lake using a Bronze, Silver, and Gold structure. This supports separation between raw ingestion and curated analytics layers. Partitioning improves performance and scalability.
- **Incremental Processing Framework** — Watermark-based updates reduce compute load while maintaining data freshness. Pipeline variables track batch IDs and timestamps for auditing. This ensures reliable enterprise refresh cycles.
- **BI Visualisations & Dashboards** — Power BI connects directly to Synapse SQL endpoints for analytics and reporting. Bravas designs and builds executive and operational dashboards on top of the curated Gold tables, including KPI definitions, report structures, and reusable semantic models. Dashboards are tailored to support both executive oversight and field-level operational reporting.

## Description
Bravas delivers a scalable, production-ready integration from Mitti into Azure Synapse.

Mitti data is extracted via REST API, landed into Azure Data Lake Bronze storage, transformed into curated Silver datasets, and loaded into structured Gold warehouse tables using Synapse SQL pools and stored procedures.

The solution supports:

• Full and incremental endpoint ingestion
 • Watermark-based updates
 • Batch-level traceability
 • Pipeline-driven orchestration
 • Structured SQL transformations
 • Relational modelling for inspections, actions, users, groups, sites, and activity logs
 • Business-ready marts for analytics and BI

Azure Synapse serves as the enterprise warehouse layer, optimised for secure, scalable, and governed reporting.

## Testimonials
- "The Bravas team delivered an excellent end-to-end data solution for El Jannah, integrating Mitti, Employment Hero, Deputy, and Sonder data into our Azure environment. Their structured approach and technical expertise gave us a reliable, scalable data foundation for reporting and operational insights. The implementation was professional, well-managed, and aligned to our broader data strategy." — Tyler Mason, CTO at El Jannah

## Pricing
- **Enterprise Pricing** — Contact Us

## FAQ
### What components are required?
An Azure Synapse Workspace, Dedicated SQL Pool or Serverless SQL Pool, and Azure Data Lake Storage Gen2 are required.

### Are additional Azure services required?
Azure Monitor is recommended for observability. Azure Key Vault may be used for secure credential management.

### How are transformations implemented?
Transformations are implemented using Synapse Pipelines and Synapse SQL (including stored procedures and incremental merge logic).

### How is pricing structured?
Costs include SQL compute (Dedicated or Serverless), ADLS storage, and pipeline execution costs.

### Can BI tools connect directly?
Yes - Power BI connects directly to Synapse SQL endpoints for reporting and dashboarding.