Case Study: Subway reduces datacenter automation time with ActiveBatch from Advanced Systems Concepts

Subway cuts workflow build time by 75% with ActiveBatch

Subway, a global restaurant franchise, faced significant challenges in managing its complex datacenter automation. The database team relied on a collection of disparate, script-dependent tools that lacked essential capabilities, forcing them to manage dependencies manually and restart entire workflows for a single failure. To address this, they turned to Advanced Systems Concepts, Inc. and implemented their ActiveBatch Workload Automation solution.

Advanced Systems Concepts provided Subway with the ActiveBatch platform, which featured an Integrated Jobs Library and a Teradata Extension. This solution enabled the team to centralize and automate workflows, manage dependencies from a single console, and use event-based triggers. The measurable impact was substantial: time spent building and updating workflows was reduced by 75%, and the weekly time spent managing data loads and environments was cut by over 60%, from 10 hours to less than 4. Report deliverability also improved to 99.5%.

Subway