Skip to content

Industry · Manufacturing & IoT

Manufacturing & IoT Software Development

Shop-floor terminals, ERP data migrations and stock systems for manufacturers and warehouses.

We build software for the parts of manufacturing that run on PCs and databases: shop-floor terminals, legacy ERP data, inventory and reporting. We have not yet shipped a manufacturing client project or an IoT system.

Where manufacturing software actually hurts

Industry 4.0 brochures start with sensors and AI. Most plants we hear from have more basic problems, and those come first:

  • Terminals die on the shop floor. Dust, heat, vibration and gloves destroy ordinary PCs. A dead terminal stops a line or a pick-face until someone who knows the setup can image a replacement.
  • The ERP sits on a database nobody wants to touch. Production, inventory and costing data has lived on SQL Server, Oracle or Db2 for years. Moving it means a shutdown window that production will not give you.
  • Stock and purchasing live in spreadsheets. Raw materials, work-in-progress and finished goods are counted in one place and ordered from another, so purchasing works from numbers that are already out of date.
  • Reports are assembled by hand. Each morning someone exports data from three systems to build the dashboard management actually reads.
  • Supplier security requirements arrive in contracts. US defence suppliers face NIST SP 800-171 and CMMC requirements, regulated manufacturers face FDA rules on electronic records, and plant networks increasingly need to meet the ISA/IEC 62443 standard.

Work of ours that applies

Disposable shop-floor terminals. ThinClient OS boots any PC straight into a locked Windows session that runs in the cloud, with no local state. The manufacturing and warehouse solution page explains why that suits a plant. Any hardware works, including second-hand machines. A supervisor can re-provision a terminal with a USB stick and an enrolment key. The replacement is identical to the one that failed, and it can be locked to one job, such as an ERP, warehouse or quality-control screen. ThinClient OS is a shipped product. It has not yet been deployed in a factory, and it is not suitable for terminals that need CAD, GPU work or specialised local peripherals.

Moving ERP data without stopping production. Our database migration platform, in early access, uses change data capture so the source keeps taking writes while data moves to a new engine. In September 2026 it loaded about 780 million rows across 405 tables from a live SQL Server estate into PostgreSQL, and it keeps them in sync ahead of cutover. A sampled key check across 401 tables found no missing keys. It supports SQL Server, PostgreSQL, MySQL, Oracle and Db2. The Oracle and Db2 connectors are implemented but not yet verified against live databases, which matters if your ERP runs on either.

Stock, purchases and sales in one system. Esparks Biz, our live app for trading businesses, records purchases that update stock automatically, tracks stock across shops and godowns, and turns each sale into a tax invoice, with an audit log whose rows cannot be edited. It was built for trading, not production, so it has no bills of materials, routings or work orders. It does show how we model inventory.

Dashboards from data you already have. Our data analytics service builds pipelines and Grafana dashboards. The migration platform itself reports live replication lag through Prometheus and Grafana.

What we have and haven't built in manufacturing

We have not shipped a manufacturing client project. We have not built an MES, connected to PLCs or SCADA, worked with OPC UA or MQTT, deployed IoT sensors, or built predictive-maintenance models. If your project depends on machine connectivity, you need a partner with control-systems experience, and we will tell you that rather than learn on your line. Where we can help is the IT side: terminals, ERP data, inventory, integrations and reporting.

Compliance: what we design for

We design for NIST SP 800-171 controls where your contracts require CMMC, for FDA 21 CFR Part 11 electronic-record and audit-trail requirements, and for ISA/IEC 62443 principles on anything that touches a plant network. We also design for PIPEDA and the UAE PDPL for the employee and customer data your systems hold. Esparks IT Solutions is not certified against any of these. We are not CMMC-assessed, our ISO/IEC 27001:2022 and ISO 9001 certifications are in progress, and we hold no SOC 2 report. Our team is in India, so export-controlled technical data, such as data covered by ITAR, generally cannot be shared with us.

How we would approach a plant project

We would start with one line or one warehouse, not the whole site: replace its terminals, move or connect the data it depends on, and put one dashboard in front of the supervisor. If that pilot works, it gives you a pattern to repeat. If it doesn't, you have lost a few weeks rather than a shutdown window.

How to start

Manufacturing projects usually start with data analytics, backend and integration work, or a cloud migration. We work remotely with manufacturers in the United States, Canada and the UAE.

Constraints

Industry challenges

  • Shop-floor PCs that fail in dust, heat and vibration
  • ERP data locked in ageing SQL Server, Oracle or Db2 databases
  • Stock and purchasing tracked in spreadsheets
  • Daily reports assembled by hand from several systems
  • Supplier security requirements such as CMMC

Response

What we build

  • Locked-down, quickly replaceable shop-floor terminals
  • Zero-downtime ERP database migrations with reconciliation
  • Inventory and purchasing systems with an audit trail
  • Integrations between ERP, warehouse and finance systems
  • Operational dashboards from your existing data

Standards

Compliance & standards

  • NIST SP 800-171 / CMMC 2.0 (US)
  • FDA 21 CFR Part 11 (US)
  • ISA/IEC 62443
  • PIPEDA (Canada)
  • UAE PDPL

Frequently asked questions

Can you connect to our machines, PLCs or SCADA?

Not on our own. We have not built PLC, SCADA, OPC UA or MQTT integrations, and we would rather say so than learn on your line. We can build the IT-side systems that consume that data alongside a control-systems partner.

How quickly can a failed shop-floor terminal be replaced?

With ThinClient OS, any spare PC becomes the same terminal after booting from a USB stick and entering an enrolment key, and a supervisor can do it. It has not yet been deployed in a factory, so we would start with a pilot on one line.

Can you move our ERP database without stopping production?

Our database migration platform uses change data capture so the source keeps running during the move. It loaded about 780 million rows from a live SQL Server estate into PostgreSQL and keeps them in sync, with row counts matching exactly on 384 of 387 measured tables. It is in early access, and its Oracle and Db2 connectors are not yet live-verified.

Can you work on CMMC or export-controlled projects?

We can design software for NIST SP 800-171 controls, but we are not CMMC-assessed. Our team is in India, so export-controlled technical data, such as ITAR data, generally cannot be shared with us. Those parts of a project have to stay with a US team.

Can you replace our inventory spreadsheets?

Yes, for stock, purchasing and sales. Esparks Biz shows our approach, with purchases updating stock automatically and an audit trail. Bills of materials and work orders would be new work for us.

Next step

Building for Manufacturing & IoT?

Talk to an engineer about your project — free quote, no obligation.

Get in touch