Case Study: US Defense Commissary Agency achieves near-real-time data updates and 24-hour faster restocking with Informatica PowerCenter

Groceries provider to 12 million US military customers shortens restocking time by 24 hours and creates on-demand view of business activities

The U.S. Defense Commissary Agency (DeCA) operates 263 commissaries serving more than 12 million military customers and needed to replace an aging point-of-sale system to keep costs low and customer satisfaction high. Key challenges included a worldwide rollout, improving forecasting and inventory management, and adapting data integration to handle both new transactional data and legacy file formats.

Using Informatica PowerCenter, DeCA seamlessly integrated legacy and new systems to support a more real-time model without disrupting core operations or deploying a new platform. Data update frequency rose from once a day to every 10–60 minutes, restocking time was reduced by 24 hours, and on-demand views of core business activities improved inventory visibility and service.

US Defense Commissary Agency

Stan Ferguson

Chief, Data Management Division