Case Study: Prymat achieves faster high-volume data integration with Etlworks

Prymat cuts ETL execution time by over 80% with Etlworks

Prymat, a leading food manufacturer in Europe, faced challenges in moving high volumes of data between its on-premise SQL Server and Google BigQuery. Their legacy tools were too slow for large tables and could not handle their need for bidirectional data flows. They selected Etlworks for its data integration service to automate and scale this process.

The solution from Etlworks used automatic partitioning to process data in parallel, drastically speeding up extraction. It also implemented reverse ETL to sync data back to operational systems. This resulted in an over 80% reduction in ETL execution time, provided a scalable architecture for growing data, and improved data availability across Prymat's systems.

Prymat