Landing IFS
ADF Pipeline
Staging
DataMart
Landing IFS
We manage ERP data ingestion by receiving CSV files pushed to a dedicated storage container in Azure Blob Storage.
Landing IFS
We manage ERP data ingestion by receiving CSV files pushed to a dedicated storage container in Azure Blob Storage.
ADF Pipeline
These files are processed through Azure Data Factory (ADF) pipelines, which validate, clean, and transform the data.
Staging
bmt_dwh_stg_uk The Staging/Silver layer aligns the data to our schema, applying necessary transformations.
DataMart
The Gold layer structures the data into DataMarts, optimised for reporting and analytics.