Case Study: ASM International streamlines SQL Server and Crystal Reporting with Advanced Systems Concepts, Inc.'s ActiveBatch

ASM International AutomatesSQL Server and Crystal Reporting

ASM International, a 36,000‑member materials science and engineering society, faced fragmented scheduling and reporting processes: about 20 SQL servers managed with Windows Task Scheduler/SQL Scheduler with no centralized visibility or logging, and brittle Crystal Reports automation that required one report to be run 120 times and left failures unnoticed. To address this, ASM implemented ActiveBatch Enterprise Job Scheduling and Workload Automation from Advanced Systems Concepts, Inc.

Advanced Systems Concepts, Inc. customized and deployed ActiveBatch workflows to centralize SQL/SSRS and Crystal Reports processing, automate ETL into a data warehouse, and keep CRM, portal and authentication systems in sync hourly 24/7. The solution replaced 120 hard‑coded report runs with a single parameterized job and cut a manual web‑analytics process from 26 hours per month to 25 minutes, while enabling daily distribution of drill‑down reports and providing better visibility, reliability and vendor support.

ASM International

Bill Raley

Director of IT