• December 20, 2022
  • Case Studies

Mölnlycke Increases Data Visibility With Replication to Snowflake

Download Case Study

Mölnlycke — A medical supplier with Customers in Over 100 Countries

Mölnlycke, a leader in medical solutions needed a way to integrate and manage its Salesforce data within Snowflake to gain a comprehensive view of customer interactions and operational data.

Graphic of a cog in the CapStorm blue color.

Industry

  • Manufacturing
Icon of a person's silhouette in CapStorm blue.

Company Size

  • 1,001-5,000 employees
Puzzle piece icon in the CapStorm blue color.

Specialities

Icon representing tech stacks in the CapStorm blue color.

Tech Stack

  • Snowflake
  • Salesforce
  • Azure
Blue, black and white cubes floating and falling.

Problem

Despite its strong IT infrastructure, Mölnlycke encountered significant challenges in integrating Salesforce data into Snowflake. These challenges included:

  • Data Integration Limitations: The existing data integration tools could not meet Mölnlycke’s demand for real-time, high-frequency data updates. The tools struggled with maintaining seamless data flow as the Salesforce and Veeva data structures evolved.
  • Scalability and Flexibility Issues: As Mölnlycke’s data landscape grew in complexity, adapting to frequent schema changes in Salesforce became increasingly cumbersome. The legacy solutions required extensive manual reconfigurations, slowing down data access and impacting productivity.
  • Operational Inefficiencies: The reliance on manual processes to handle schema evolutions and data updates meant increased workload for IT teams, diverting focus from more strategic initiatives and innovation projects.

Given the need for a comprehensive solution to support ongoing business growth

Solution

CapStorm’s CS:Enable solution helped address Mölnlycke’s data integration needs. The deployment was executed with precision to minimize disruption and ensure seamless integration. Components of the solution included:

    1. Automated Schema Mirroring: CopyStorm’s automated schema detection feature ensured that any updates to Salesforce and Veeva structures were reflected in Snowflake in real time. This feature eliminated the need for manual adjustments, allowing Mölnlycke to scale effortlessly.

       

    2. Near Real-Time Data Replication: CapStorm’s solution provided high-frequency data extraction, ensuring that new and modified records were captured and replicated in Snowflake almost instantaneously. This enabled Mölnlycke to work with the most current data available.
    3. Multi-Destination Replication: CopyStorm supported replication to both Snowflake and SQL Server databases hosted on Azure, providing Mölnlycke with flexible data storage and enhanced accessibility across its platforms.

       

    4. Enhanced Data Security: The solution included data security protocols to align with Mölnlycke’s compliance requirements, adding another layer of protection to the organization’s critical information.
Graphic of white, black and CapStorm blue colored cubes stacked on each other.

Outcome

Checkmark inside of a white circle.

Increased Data Visibility and Insights

With all critical business data integrated into Snowflake, Mölnlycke gained a holistic view of its operations and customer interactions. This integration unlocked new insights, improving strategic decision-making and fostering proactive customer engagement.

Checkmark inside of a white circle.

Reduction in Data Lag by Over 80%

Mölnlycke reduced the delay in data availability from up to 24 hours to under 5 minutes, ensuring near real-time data access for better responsiveness.

Checkmark inside of a white circle.

Operational Efficiency Gains

Automation of schema mirroring and data updates saved Mölnlycke’s IT team an estimated 25 hours per week. This allowed IT staff to allocate more time to value-adding projects and innovation efforts.

Want results like this?

Schedule a Demo
Contact Us
Become a CapStorm Insider

Subscribe to the CapStorm Forecast

Name
This field is for validation purposes and should be left unchanged.