Most plants have CMM output in one system, gauge readings in another, lab results in a LIMS and the part numbers that tie them together in the ERP. KensoBI queries those systems where they are, so there is no migration to get through before you can build a dashboard.
Connections are read-only by default
The blocker is rarely the statistics. The numbers sit on different machines, in different departments and at different companies, and gathering them into one place turns into a migration project that nobody planned for.
Your CMM software, your MES and your existing databases stay where they are and keep doing their job. KensoBI sits on top as a reporting layer and reads from them.
A single panel can query more than one database. That lets you put dimensional results alongside machine temperature, humidity or cycle time and look for a correlation.
A supplier can be given somewhere to upload their measurement data and a dashboard of their own. You then see a drifting process while the parts are still on their floor.
Grafana ships with connectors for most of the databases used in industry, and the community has built hundreds more. Between the two, anything with a query language is usually covered.
Measurement data has its own standards, and the SPC Characteristic data source understands them.
Most dashboard tools pull the raw rows across the network and calculate in the browser. That is workable at a hundred points. It gets slow once a model carries hundreds of characteristics with years of history behind each one.
The SPC Characteristic data source generates nested SQL and lets your database do the work. The mean, the control limits and the capability indices come back already calculated.
# What the panel asks for characteristic "Bore Ø 12.4" part "HSG-4471" range last 90 days # What comes back, already computed → mean 12.4021 → ucl 12.4610 → lcl 12.3432 → cp 1.42 → cpk 1.11 # Raw rows stay in the database.
Grafana evaluates alert rules on a schedule and sends a notification when one fires, so catching a control limit breach does not depend on somebody having the dashboard open at the time.
This is Grafana underneath, so the public plugin catalogue is available to you as well. Hundreds of community data sources and panels can go on the same dashboard as the SPC ones. For anything that does not exist yet, Grafana plugins are written in TypeScript.
Describe your measurement systems and we will tell you what connecting them would involve, and whether it is a sensible fit for what you are trying to do.
English
Polski