Pump, tank & tap: A framework for near real-time Infor M3 reporting

At Fortude, we’ve been exploring innovative ways to bring near real-time reporting to businesses using Infor M3 Cloud. One solution our team recently implemented is what we call the Pump, Tank & Tap framework — a simplified way to think about the complex journey of extracting, storing, and visualizing M3 data.

Getting data out of Infor’s multi-tenant cloud isn’t straightforward. For this, you need Infor OS Data Fabric Stream Pipelines — a separate license from your usual M3 Cloud bundle. Think of this as the “pump” that pushes your operational data outside the cloud boundary.

💡 Usage tiers start at around $13K/year excluding cloud egress limits (e.g., 3TB/year on Essentials tier).

Once out, where do you store the data? Your options include Postgres on Amazon Aurora or Azure, or Snowflake. For our pilot, we chose Azure SQL, which cost us around $3K/year for a basic setup.

💡 We used an “upsert” method instead of traditional inserts — it’s more efficient and ensures you’re always looking at the latest data snapshot.

Finally, it’s time to make the data useful. We tested tools like Power BI and Qlik Cloud, with Power BI outperforming in terms of refresh speed. By building SQL views in our database, we enabled real-time dashboards without needing to wait on pre-modeled data flows.