Data & AI

The reference architecture for data and AI on premises.

One architecture covers every Cloudtech data engagement. Data comes from any source and passes through one governed streaming backbone into stores, reports, applications and a local AI layer. All of it runs inside the on-prem private cloud: on hardware you own, in premises you control, under access rules you set. Your data stays in your hands, not on servers somewhere on the internet, in buildings you cannot inspect, run by people you did not choose. Cloud platforms are optional targets. They receive only the streams you choose to send, and the primary copy stays with you.

Reference architecture for data and AI on premises Sources such as transactional databases, brokers, time-series stores, APIs, devices, plant systems, logs and files enter through change data capture, connectors and gateways. A streaming backbone with a schema registry feeds stream processing, which writes to operational databases, warehouses, time-series stores and search indexes. Dashboards, reports, applications and exports serve the results, and an AI layer of open-weight models on local GPUs reads aggregates and permitted documents. Governance and observability cover every layer. Everything sits inside the on-prem private cloud; selected streams can go to cloud targets: Microsoft Fabric, AWS and Amazon S3, Google Cloud, Snowflake. ON-PREM PRIVATE CLOUD 01 SOURCES 02 INGESTION 03 STREAMING & PROCESSING 04 STORAGE 05 SERVING Transactional databases Oracle · PostgreSQL MySQL · SQL Server Brokers and queuesTime-series storesAPIs and SaaS Devices and sensorsPLC and plant systemsLogsFiles and exports Change data capture transaction logs source unchanged Connectors and bridges brokers · stores APIs · SaaS Gateways and shippers MQTT · OPC UA log shippers file loaders store-and-forward BACKBONE · SCHEMA REGISTRY Stream processing Validate Normalise Enrich and join Aggregate Project event time checkpoints upserts by key Operational databases serving · drill-down Warehouse, lakehouse analysis · history Time-series store sensor readings Search index documents · records Dashboards and KPIs live · drill-down Reports, data marts scheduled · on demand Applications, APIs operational screens Exports BI tools · partners 06 AI LAYER Open-weight models on local GPUs evidence or no answer 07 GOVERNANCE & OBSERVABILITY schemas and contracts · access control · audit · declared inventory · incidents selected streams CLOUD TARGETS optional Microsoft Fabric AWS · Amazon S3 Google Cloud Snowflake

On-prem private cloud

  1. 01 Sources

    • Transactional databases
    • Brokers and queues
    • Time-series stores
    • APIs and SaaS
    • Devices and sensors
    • PLC and plant systems
    • Logs
    • Files and exports
  2. 02 Ingestion

    • Change data capture
    • Connectors and bridges
    • Gateways and shippers
  3. 03 Streaming & processing

    • Backbone with schema registry
    • Validate · normalise · join · aggregate
    • Event time · upserts by key
  4. 04 Storage

    • Operational databases
    • Warehouse, lakehouse
    • Time-series store
    • Search index
  5. 05 Serving

    • Dashboards and KPIs
    • Reports, data marts
    • Applications, APIs
    • Exports
  6. 06 AI layer

    • Open-weight models on local GPUs
    • Aggregates and permitted documents
    • Evidence or no answer

07 Governance & observability Schemas and data contracts, access control, audit, monitoring against a declared inventory.

Cloud targets, optional

Microsoft Fabric · AWS and Amazon S3 · Google Cloud · Snowflake

The reference architecture. Layers 01–05 move data from any source to its consumers. The AI layer reads curated outputs, and governance and observability cover every layer. Cloud platforms are optional targets outside the boundary.

01 Layers

Seven layers, one boundary.

  1. 01

    Sources

    Relational and transactional databases, time-series stores, message brokers and queues, application and system logs, IoT devices and sensors, PLC and plant systems, files and exports, APIs and SaaS applications.

  2. 02

    Ingestion

    Log-based change data capture for databases, so source applications are not modified and production is not queried for reporting. Connectors for brokers and APIs, shippers for logs, gateways for devices, loaders for files.

  3. 03

    Streaming and processing

    A streaming backbone in which every record carries a registered schema. Stream-processing jobs validate, normalise, enrich, join and aggregate in event time. Results are written as upserts by key, so a replay overwrites rather than duplicates.

  4. 04

    Storage

    Operational databases for serving and drill-down, warehouses and lakehouse storage for analysis, time-series stores for sensor data, search indexes for documents. Each holds a documented layer, raw, validated or business, and can be rebuilt from the layer beneath.

  5. 05

    Serving

    KPI applications and dashboards pushed live to the screen, reports and data marts, APIs for applications, and exports to BI tools and to cloud platforms when a group needs them.

  6. 06

    AI layer

    Open-weight models on local GPUs, reading curated aggregates and permission-filtered documents. Statistics detect; the model explains. It refuses when evidence is missing.

  7. 07

    Governance and observability

    Schemas and data contracts, access control enforced by the server, audit logs, monitoring against a declared inventory, incidents with durations, alerts on state transitions. These cut across every layer.

One pattern, many sources

Most organisations do not have a data problem. They have many separate data problems: a database nobody may query during the day, machines that report in their own formats, a warehouse fed by exports nobody owns, a cloud platform the group has chosen. Each gets its own interface, its own schedule and its own way of failing. The reference architecture replaces that with a single path. Data is captured where it originates, moved once through a governed backbone, and delivered to every consumer from there.

The diagram at the top of this page shows the layers. Each is described below with the terms the industry uses for it, and with what Cloudtech does in it.

How data moves

Capture without touching the source. For databases, change data capture reads the transaction log the database already writes. The application is not modified, no polling queries load the system, and every insert, update and delete arrives in order, including deletes, which nightly extracts miss. Initial loads and backfills are taken as snapshots, with the live stream started first so that nothing falls into the gap.

One backbone, with contracts. Every message on the backbone has a registered schema. Producers and consumers agree on that schema, and the registry checks every change for compatibility. This is how data contracts are enforced technically: a change that would break a consumer is caught before it is deployed.

Processing in event time. Stream-processing jobs compute what the business works with: periodic KPIs, daily reports, master-data projections, enriched event streams. They use the time an event happened, not the time it arrived, so late data lands in the right period. Jobs keep their state in checkpoints and stop with savepoints, so an upgrade or a restart resumes where it left off.

Layers that can be rebuilt. Raw change streams, validated and joined streams, and business aggregates are kept as separate layers. Lakehouses call this the medallion architecture: bronze, silver and gold. Any consumer can read the layer it needs, and any layer can be recomputed from the one beneath it.

Serving from stores, never from production. Reports, dashboards and applications read from serving stores. Live figures are pushed to the screen as they change, and every figure links to the records behind it.

Where AI fits

The AI layer sits on top of the serving layer, not beside the sources. It reads what the pipeline has already made trustworthy: aggregates with known definitions, documents with known permissions. That placement is deliberate. A model that reads raw production tables inherits every ambiguity in them. A model that reads curated outputs inherits their definitions, their access rules and their audit trail.

The IoT and sensor-data variant

Device and sensor data follows the same pattern with a different front end:

  • Devices, sensors, PLCs and machines publish over MQTT, OPC UA, AMQP or vendor protocols, or deliver files.
  • Edge gateways collect, translate and buffer. Store-and-forward keeps readings while the link to the site is down, within the gateway’s buffer limits.
  • A message broker, such as RabbitMQ or an MQTT broker, takes device traffic in. A time-series database such as QuestDB stores readings, while a relational database holds devices, configuration and master data.
  • A bridge to the streaming backbone carries the device data that has to meet business data: machine states joined to production orders, sensor readings joined to quality results. From there it uses the same schemas, jobs and stores as everything else.

The second diagram shows the variant. In manufacturing, the same layout can carry a Unified Namespace, the broker-based, ISA-95-structured hub for current state, with the streaming backbone holding history and joins.

Inside the boundary, with doors to the cloud

Everything above runs inside the on-prem private cloud: capacity the customer owns, run with cloud-style automation and service levels. Cloud platforms are targets, not the centre. Selected streams can be delivered to:

  • Microsoft Fabric and Azure Event Hubs;
  • AWS, including Amazon S3;
  • Google Cloud;
  • Snowflake.

That covers group reporting, data science workspaces and partner exchange. The primary copy and its history stay on premises.

Under the EU Data Act, providers of data processing services must make it possible for customers to switch to another provider or back to on-premises infrastructure. An architecture with open interfaces and on-premises primaries keeps that option open by design.

What runs it

The architecture is only as good as its operation. Every component, from connectors and brokers to jobs, stores and models, is listed in a declared inventory and monitored against it. Incidents are measured from start to end. The whole stack falls under the same 24/7 service level as the databases it reads from, with a P1 reaction of one hour or less.

IoT and sensor-data variant of the reference architecture At the site, sensors, controllers, machines and meters publish over MQTT, OPC UA, AMQP or files to an edge gateway that collects, translates and buffers with store-and-forward. Inside the on-prem private cloud, a message broker feeds a time-series database for readings and a relational database for devices and master data, and a bridge carries readings that must meet business data onto the streaming backbone. Dashboards, reports, alerts and the AI layer read from there. SITE AND EDGE ON-PREM PRIVATE CLOUD Sensors PLCs and controllers Machines and benches Meters and devices MQTT · OPC UA · AMQP · files Edge gateway collect translate buffer store-and-forward Message broker RabbitMQ or MQTT broker queues · topics Time-series database QuestDB · readings Relational database PostgreSQL · devices Bridge to backbone readings that meet business data Streaming backbone and processing joins · windows aggregates business data via CDC Dashboards and alerts live · thresholds Reports and KPIs fleets · sites AI layer explains anomalies
The IoT and sensor-data variant. Devices publish at the site through an edge gateway with store-and-forward. Inside the private cloud, a broker feeds a time-series database for readings and a relational database for devices and master data. A bridge carries readings that must meet business data onto the streaming backbone.

Map your sources and targets.

An engineer walks through the systems you have, the numbers they produce and where the data has to go.