Supporting, operating, and optimizing your industrial business requires that you know about problems before they ruin your day, week, month, quarter, or dare we say career?
Since 1996, we've helped you get at the real time data in your operations, delivering it to HMI, SCADA, Historians, MES, in house custom applications and more.
Flow is a software application for decision support that unifies data from historians, databases, business systems and helps you aggregate, calculate, visualize and collaborate on a single version of the truth, without custom software and complex configuration.
Software Toolbox is an authorized Flow Software partner focusing on the US, Canada, & Mexico
Flow was born out of the frustration of users integrating data manually, with spreadsheets, and custom code and eventually running into the limitations of those systems.
We know that you have important data that you just can't get to through digital integration yet. Flow enables you to create measures that are sourced through a brower-based, spreadsheet like user interface, and later convert those measures to automated data collection.
Manual data entry is also be used for authenticated, commented, audit-logged update of automatically collected data, when things go wrong at the data source.
The Flow Calculations engine, the measures you create using it, the events and flexible production schedules/shifts that provide context, is where the power of Flow lives.
Aggregations, automatically performed at the levels you want as time passes - hourly, shiftly, daily, weekly, quarterly, and annually - ensure the right data is already there when someone needs it. No waiting to reach back to historians and databases when you want an answer!
Calculations using the same common functions found in a spreadsheet along with user defined functions, including calculations that combine measures, give your data meaning.
Flow is able to deliver fast value because as long as your historical data sources - historians, databases, etc - have the data for your time range of interest, Flow can backfill it's aggregated and calculated data at configuration time or any time in the future. And when you backfill, the system keeps on working while the backfill runs as the Flow Engine works in the background at a pace you control.
This means you could build a set of Flow measures, and quickly have data going back days, weeks, months, or more, which is helpful in validating your results, but also providing the instant ability to compare this week to last, this month to last, this month to same month a year ago, and more.
Flow also automatically backfills measures that depend on other measures when those measures change. Through Flow's data versioning you'll be able to know that the values were updated and why.
Lastly, if a historical data source is offline, and then comes back, Flow will automatically "catch up" on the collection measure and all dependent measures.
A big challenge with spreadsheet models is when users change something. You don't know who did it, when they did it, unless they remember to leave a comment. And if they break the model in the spreadsheet then what?
With Flow, through it's Active Directory Integration and user permissions, there is accountability on all configuration changes and manual data entry.
If a measure or event value is updated through backfilling, or configuration change, you'll be able to see past versions of the data, even revert back to those past versions if you have sufficient permissions.
If the person making a change leaves a comment you'll have that as well.
Flow supports a wide range of types of tables, charts, widgets, gauges, and more. When you build a visual report in Flow, you can then combine those into a dashboard page, and then combine dashboard pages into dashboard loops, keeping everyone informed.
To keep your team working together, all using the single version of the truth that you build, Flow offers these capabilities to deliver data, dashboards and more.
Once you've configured your Flow system, you'll have some great aggregated, meaningful data in your measures and reports. We're sure you will want to share that with other systems, so Flow has built in Data Consumers that automatically deliver calculated results to others without programming or integration middleware.
Many applications have multiple instances of the same type of metric, KPI, or other measure. To enforce standards and aid in rapid time to value deployment, Flow supports templates for measures, metrics, and folders, for use within a single Flow application and across multiple sites.
Templates can be locked to help enforce standards and roll out updates, even between sites. In multi-tiered applications you can designate a Flow system to be the "Template Server" to support your standards efforts.
Templates can be derived from other templates and thus linked so that derived templates can be synchronized with their parent template when there are changes.
Flow is ready for companies with multiple sites, the need for roll-up of information and the potential complexities that brings. Managed templates help enforce standards and provide configuration scalability.
Unlimited users, reports, charts, dashboards, data source types, data consumer integration types, and notification messages empower all to be "in the know" as required.
Flow's information portal supports http: and https: as well as TLS connections between the Flow Configuration app and Flow Application server.
Flow security integrates with Active Directory and enables you to limit usage at two levels and provides an audit trail of configuration changes.
Here are just a few of the ways Flow is used. The software is designed for applications where you need to bring together differing historical data sources and derive meaningful metrics to support industrial operation decision making.
A Measure in Flow Software is a KPI or metric you configure to collect and calculate information. Examples include volume produced, units produced, electricity used, production waste, production cost, efficiency, OEE, etc.
A Measure slices or aggregates your data into defined Calendar "time buckets" - hourly, shiftly, daily, etc.
An Event in Flow Software is a value you retrieve from one of your data sources that you use to detect start and end of event periods that don't fall on even time intervals like hours, shifts, days, etc.
Examples include batch running, machine state, downtime, production runs, product being produced, work order, shift team, etc.
Events provide added context to your time series data and are key to making the intersection between historian and business information.
To assist you in learning flow, in addition to the Training Manual, we have a series of videos that walk you through a Flow system configuration.
The Flow Training and Resource Manual provides 30 step-by-step hands on tutorials to guide you through installation, building a basic system, building basic reports, sending notifications and more. DOWNLOAD YOUR GUIDE
Please visit our full FAQ for how to properly size a system. In general, though, here are basic requirements
The demo software is fully functioning for 30 days for up to 100 measures and 10 events. Systems built with trial software can be put into production by purchasing a Flow license.