Centralising distributed brands through cloud data integration

Centralising distributed brands through cloud data integration

Key Technologies
  • Azure
  • Azure Data Factory

Client

The 2M Group of Companies focuses on delivering high-quality chemistry-based solutions that make lives healthier today and better tomorrow. The group maintains a portfolio of material & life science companies, which includes CE-02, Banner Chemicals, Ingretech, MP Storage & Blending, Packed Chlorine, SampleRite, Stowlin & Surfachem.     

Background

2M aimed to rebrand and update critical certification of authenticity applications for two of its subsidiaries. A key challenge was consolidating and managing large data transfers from the subsidiaries' unique ERP and CRM systems.

To centralise and streamline this complex data integration, the organisation leveraged Azure Data Factory - a cloud-based integration platform-as-a-service (iPaaS) solution. With Data Factory’s flexible and scalable architecture, they could pull subsidiary data into a unified view to empower the updated applications.

Solution

The intuitive graphical interface of Azure Data Factory made it easy for developers to visualise and orchestrate complex extract, transform, and load processes between data stores. This enabled seamless data movement from the subsidiaries into the rebranded applications.

Secure cloud data integration proved essential for the successful rollout of the refreshed certification platforms. Data Factory provided the data pipelines to validate orders against the manufacturer’s databases and generate branded PDF certificates of authenticity. Despite differing backend systems between subsidiaries, it enabled consistent application experiences.

Azure Data Factory allowed the organisation to handle and validate the data that was being transferred from the subsidiaries’ individual databases. This meant large volumes of information pertaining to various chemical product data could be successfully standardised and accessed by users across regions. The tool was especially useful given the substantial amounts of diverse data the company and its subsidiaries deal with globally.

Results

The cloud data migration and integration project delivered:

  • Centralised view of subsidiary data in rebranded apps
  • Flexible and scalable iPaaS architecture
  • Accelerated development cycles and data processing
  • Consistent application experiences across units
  • Foundations to continue advancing insights

By leveraging Azure Data Factory, the manufacturer gained an agile platform to integrate complex data and unlock faster unified insights across global subsidiaries.