Cuts Development Time to Half for Large-Scale Data Migration to the Cloud

• 应用基础设施与中间件 - 数据交换与集成
• 基础设施即服务 (IaaS) - 云计算
• 平台即服务 (PaaS) - 数据管理平台

• 离散制造
• 物流运输

• 云规划/设计/实施服务
• 数据科学服务

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.

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).

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.

• Smooth data movement between legacy system and Azure cloud
• Clean, accurate data for reporting
• Streamlined integration with Microsoft Azure and D3FO

• 40 percent time savings in designing and executing data transfers from legacy system to Azure