Case Study: Sermo achieves near-real-time processing of half a billion records daily with Etlworks

Sermo processes half a billion records daily with Etlworks

Sermo, a global medical community platform, faced the challenge of aggregating massive volumes of data from diverse sources like SQL Server, Marketo, Salesforce, and Smartsheet into Amazon Redshift in near real-time. The high volume and variety of data, along with the complexity of managing hundreds of pipelines, made traditional tools insufficient, leading them to seek a new solution from vendor Etlworks.

Using the Etlworks platform, Sermo implemented a scalable data integration process that utilized wildcard transformations and high watermark replication. This solution enabled them to collect and process over half a billion records daily into Redshift with near-zero latency within just two weeks of subscribing, achieving a new level of performance and efficiency.

Sermo