Automated Data Pipelines for Your Modern Data Needs

Background

CRC Industries is a global name in chemical specialty products, providing top-of-the-line solutions to business customers in automotive, aviation, electrical & utility, healthcare, oil & gas, general manufacturing, and several other industries. The company caters 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.

Use Case

CRC Industries wanted to move enterprise-wide data related to customers, internal systems, and affiliates, stored in the legacy system, to Azure cloud. CRC required a solution that could filter customer and affiliate data, which was in disparate formats and layouts, and perform quality checks for consistency and reliability. The platform also had to be able to retrieve, compare, and profile data to create an accurate, complete report.

Additionally, CRC Industries wanted to streamline data handling and migration without extensive coding. They needed a solution which could automate transcribing PDFs into Excel and CSV formats.

“It is a good thing to have Astera Data Pipeline Builder, and while we bought it mainly for data migration, I see a lot more opportunities to use it. And that’s, of course, a winning situation.”

— Patrick Van Vlierberghe, IT Manager

Enter Astera Data Pipeline Builder

After reviewing several solutions in the market, the chemical products manufacturer chose Astera Data Pipeline Builder because of its robust data integration and migration capabilities, scalability, and user-friendly environment.

As Astera Data Pipeline Builder offers a high-performance, scalable data integration platform, it allowed CRC to keep up with advanced data needs. Powered by an enterprise-grade, parallel processing engine, Astera Data Pipeline Builder offered the global supplier data syncing, mapping, transformation, parsing, and extraction capabilities, all through a single platform.

Astera Data Pipeline Builder’s industrial-strength ETL engine empowers CRC Industries to perform sophisticated migrations to and from virtually any target. For meeting customer data requirements, 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 Astera Data Pipeline Builder’s data profiling and validation features to ensure consistency in its incoming data from legacy systems.

Aside from superior performance, flexibility, and affordability, the CRC team found Astera Data Pipeline Builder easy-to-learn and fast at executing complex jobs such as sending files in formats that the customers desired. Astera Data Pipeline Builder has proved to be the perfect match for CRC Industries’ unique data migration and integration needs and exceeded expectations. CRC now enjoys 40 % time savings in programming and performing translations for data transfers, thanks to Astera Data Pipeline Builder’s powerful functionality, flexibility, and intuitive interface.