Corporate Lakehouse on Azure with medallion architecture

Problem

The company needed to consolidate data from multiple sources (notably ERP Protheus) into a single platform, with different criticality levels and refresh routines per business area.

Architecture

flowchart LR
  ERP[ERP Protheus] --> ADF[Azure Data Factory]
  SRC[Other sources] --> ADF
  ADF --> B[Bronze]
  B --> S[Silver]
  S --> G[Gold]
  G --> WS[Domain workspaces]
  WS --> BI[Power BI / Consumption]
  classDef a fill:#0d1525,stroke:#3b82f6,color:#e2e8f0
  classDef g fill:#0d1525,stroke:#10b981,color:#e2e8f0
  class ERP,SRC,ADF,B,S a
  class G,WS,BI g

Solution

• Medallion architecture (Bronze, Silver, Gold) for ingestion, processing and delivery.
• Business-domain workspaces integrated into a central Engineering workspace.
• Orchestration via Azure Data Factory with parameterized, SLA-controlled pipelines.
• Governance, isolation and process standardization across domains.

Results

• Robust, governable and scalable data platform.
• Flexible scheduling and logic reuse across pipelines.
• Aligned with the organization's operational and analytical needs.

Stack