Case Study: McDougall Energy achieves real-time, scalable data replication with BackOffice Associates' DBMoto

McDougall Energy Inc. prides itself on its use of DBMoto software from BackOffice Associates for its data replication needs

McDougall Energy Inc., a fueling-industry company with 300+ employees supporting a 30,000+ customer portal user base, needed a faster, more reliable way to replicate ERP data in real time. Their existing MSSQL Replication solution required custom in-house code, offered limited filtering/mapping, and strained an eight-person IT team facing a strict go-live deadline.

They selected BackOffice Associates’ DBMoto for its easy replication setup, simple field mapping, and support for VB/C# scripting; most of the solution was implemented within an hour and the Management Center streamlined configuration. After rollout, the portal provides accurate real-time reporting, MEI handles about 350,000 records daily, replicated tables grew from 10 to over 300, and ongoing resource and management needs were significantly reduced.

McDougall Energy

Eugene Boateng

Programmer Analyst