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.
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.
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.
The cloud data migration and integration project delivered:
By leveraging Azure Data Factory, the manufacturer gained an agile platform to integrate complex data and unlock faster unified insights across global subsidiaries.