Field, GIS and operations data layers flowing into one warehouse

Bring water utility data into one shared warehouse

Collect and standardise data from business systems and measuring devices to reconcile volumes, review operations and prepare reports.

From software and devices to shared data

The warehouse receives and processes copies of data for reporting, analysis and sharing under defined access rights.

Business software

  • CRM & Billing
  • GIS
  • SCADA
  • Asset management
  • Laboratory
  • Other systems

Devices & sensors

  • Data loggers
  • Water meters
  • Quality sensors

Central data warehouse

  1. Connect
  2. Clean
  3. Standardise
  4. Store
  • Historical data
  • Updated data
  • Aggregated data

Applications & analysis

  • Dashboards & BIOperating indicators
  • Analysis & AIData for models
  • Alerts & monitoringConfigured rules
  • Reports & statisticsBy period and area
  • Sharing via APIsAuthorised access
  • Security & access
  • Backup & recovery
  • Data governance

Where scattered data slows work down

Slow reporting
Staff export files, merge spreadsheets and check figures again for every reporting period.
Hard-to-reconcile figures
Different identifiers, recording periods or calculation rules produce different results across systems.
Harder to track sharing
Files copied to several locations make recipients and data versions harder to track.
Missing data
Missing history and links between datasets limit trend comparisons and forecasting experiments.
Repeated data preparation
Each report or application builds its own connections and aggregation rules.

Connect the right sources for the reports you need

Bringing data together

  • Connect each source appropriately

    Use APIs, databases or files; connect IoT devices through a collection platform or MQTT where supported.

  • Set an appropriate update schedule

    Periodic, scheduled or near-real-time updates depend on source capabilities and user needs. Track the last update to identify stale data.

  • Match reference data and units

    Map customer, asset, measurement point and DMA identifiers; align units, timestamps and rules for missing or duplicate records.

Putting data to work

  • Reconcile supply and billing volumes

    Compare inflow, consumption and billed volumes by area using aligned reporting periods and calculation boundaries.

  • Review operating history

    Review flow, pressure and water quality trends by measurement point; prepare reports using agreed indicators.

  • Provide data for analysis

    Data owners are responsible for ensuring quality. Data is shared through APIs with strict access controls.

Ministry of Construction · 69/2026/TT-BXD

Support compliance with water supply data requirements

The circular regulates information systems and databases for clean water supply and urban drainage. The warehouse helps utilities prepare, manage and provide the required data.

Effective fromIssued on 15 September 2026

Build governance into integration

Centralised data needs access rules, backups and clear responsibility for quality checks.

  • Security and access rights

    Define who may view, use and share each dataset; record access logs according to the utility’s requirements.

  • Backup and recovery

    Agree backup schedules, retention periods and recovery objectives; test restoration before operational handover.

  • Monitor data quality

    Check missing records, duplicates, incorrect units and failed updates; assign source owners to resolve issues.

Connect source by source, verify against actual records

  1. 1

    Assess sources

    Inventory systems, access rights, historical data and reporting needs; select priority sources.

  2. 2

    Agree data rules

    Define reference data, indicator calculations, update schedules and responsibility for data errors.

  3. 3

    Connect and reconcile

    Integrate priority sources, compare with original records and validate reports with the responsible staff.

  4. 4

    Hand over operations

    Check permissions, backups and restoration; train staff to monitor updates.

Start with the data your utility already has

Discuss your software, devices and reporting needs with WETEC to define the integration scope and see a relevant demonstration.

Book a demo