Case study

ERP automation PMs actually use

Programme teams at a Swiss motor manufacturer were burning hours on the same ERP exports every week. We delivered one internal Streamlit application on their stack: structured pulls, clean handoffs to Excel, and no shadow IT.

  • Streamlit
  • Client-hosted
  • IAM / SSO
  • ERP integration

Context

The data was already right. The workflow was not.

BOM logic, lists, and trackers already lived in the ERP. The friction was repetition: export, massage, re-export, pray nobody edited the wrong column.

Project managers needed repeatable artefacts for delivery reviews, supplier loops, and internal sign-off. Each run had to look like the last one, without someone acting as human middleware.

The mandate was clear: stay inside the corporate trust boundary, use familiar identities, and give PMs a tool they would open on Monday morning, not file away.

Build

What we shipped

A Streamlit front end talking to the company’s ERP through controlled integration, hosted on the client’s infrastructure next to the systems that already matter.

PM-shaped flows

Tasks mirror how delivery teams already work: pull structured data, reshape it for the meeting or partner, move on.

Authoritative reads

No competing “shadow database.” The ERP remains the source of truth; the app is the disciplined path out.

Presentation that saves time

Layout and formatting land where they help: ready for Excel, ready for humans scanning a grid under pressure.

Room to grow

Python and Streamlit keep iteration honest when the next export pattern shows up in the backlog.

Trust

Security without drama

Authentication runs through corporate IAM / SSO with existing identities. If you are not supposed to see operational data, you do not reach the app.

Operational data stays in the same trust perimeter as the rest of the estate. The goal is fewer ad hoc exports, not more mystery attachments.

Scope

What the first wave automated

Typical jobs included generating and formatting bill of materials (BOMs), transfer lists, process lists, and related ERP-derived artefacts PMs touch every sprint.

  • BOMs
  • Transfer lists
  • Process lists
  • Part trackers
  • Excel-ready outputs

Walkthrough

See the platform in motion

Short tour: how structured ERP data becomes dependable exports for project managers.