Case Study: Wheeler Machinery Company achieves real-time BI reporting and continuous availability with Vision Solutions

Wheeler Machinery Company - Customer Case Study

Wheeler Machinery Co., a Caterpillar equipment dealer headquartered in Salt Lake City with 600 employees across 13 locations, faced a BI challenge: analytic queries were disk‑ and CPU‑intensive, slowing production systems, and nightly ETL snapshots left managers with as much as 24‑hour‑old data. Wheeler also needed reliable high‑availability protection for its systems because its primary data center is in an earthquake zone.

Vision Solutions deployed Double‑Take Share to replicate production updates in near real‑time to a dedicated Microsoft SQL Server data warehouse for BI, and iTERA Availability to maintain a real‑time replica 300 miles away for disaster protection. The outcome: managers get up‑to‑the‑minute reports without taxing production systems, nightly extracts are eliminated, BI‑specific indexes improve performance, ERP migration and data cleansing are easier, user complaints have dropped, and both solutions require no daily management.

Wheeler Machinery Company