Case Study: Largest Personal and Commercial Insurance Provider in Canada achieves accelerated, cost-saving data integration with erwin

Metadata-driven automation to accelerate project delivery

The Largest Personal and Commercial Insurance Provider, Canada’s largest insurer for personal and commercial lines, was struggling to manage enterprise data warehouse mappings in Microsoft Excel as mapping rules shifted across releases. To automate mappings and govern each phase of data integration and reduce time and resources, they evaluated tools and selected erwin, deploying erwin Mapping Manager and the erwin Automation Framework.

erwin implemented a central repository for enterprise mappings, drag-and-drop mapping acceleration, version mapping and Excel import, and custom code automation templates that cut code-generation costs by hundreds of thousands of dollars. erwin’s solution delivered ROI within the first 12 months, enabled more work in less time with fewer development resources, and provided enterprise data lineage and impact analysis for better governance.