Cuts Development Time to Half for Large-Scale Data Migration to the Cloud
Customer Company Size
Large Corporate
Region
- America
- Africa
- Asia
- Europe
- Pacific
Country
- United States
- Australia
- China
- South Africa
Product
- Astera Centerprise
- Astera EDIConnect
- Microsoft Dynamics 365 for Finance and Operations (D3FO)
- Microsoft Azure
Tech Stack
- SQL
- ODBC
- AS/400
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Productivity Improvements
- Cost Savings
Technology Category
- Infrastructure as a Service (IaaS) - Cloud Computing
- Application Infrastructure & Middleware - Data Exchange & Integration
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Functions
- Discrete Manufacturing
- Logistics & Transportation
Services
- Cloud Planning, Design & Implementation Services
- Data Science Services
About The Customer
CRC Industries is a global provider of over 1,300 chemical specialty products to customers in a wide range of industries including automotive, aviation, electrical & utility, healthcare, oil & gas, general manufacturing, and several others. The company has an extensive range of products and specially formulized products, catering to customers and affiliates in Europe, USA, Australia, China, South Africa, and other regions. CRC manufactures over 80 million cans of aerosol products in its 26 production facilities every year. All the data from each production facility, distribution center, and division across the world ties into Microsoft Dynamics 365 for Finance and Operations (D3FO).
The Challenge
CRC Industries, a global provider of over 1,300 chemical specialty products, was facing challenges in moving its internal and external data assets from legacy systems to the cloud. The company lacked the resources and technical infrastructure to handle large amounts of data and speed up the entire process without compromising on data security and integrity. The company's IT team had performed data migration for companies CRC has acquired in the past, but it was always a complex, time-consuming process. The global manufacturer exchanged data between its different business units via Excel or text files, used a legacy system to analyze them, and performed data quality checks via SQL statements. However, the only way to load data in D3FO was through its built-in templates, which mainly supported the Excel format. This made it difficult to handle, import, and export data to and from D3FO.
The Solution
CRC Industries chose Astera Centerprise because of its robust data integration and migration capabilities, scalability, and user-friendly environment. Astera enables businesses to perform complex data movement without relying heavily on IT. This means business users can carry out operations, like data migration, using Astera's automated solutions, eliminating hand coding completely. The industrial-strength ETL engine empowers enterprises, like CRC Industries, to perform sophisticated migrations to and from virtually any target. CRC moved the Astera server to Microsoft Azure, using it as a gateway for all of its other systems hosted on the cloud. This made data movement smoother and more flexible for CRC. CRC also utilized Centerprise's data profiling and validation features to ensure consistency in incoming data from legacy systems.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
