Did you know We're The One

who helps Applegate streamline ETL processes?

CASE STUDY

applegate logo

 

For over 30 years, Applegate has been producing high-quality natural and organic hot dogs, bacon, sausages, deli meats, cheese, and frozen products. Applegate products are made without GMO ingredients and meat is sourced from farms, where animals are treated with care and respect and allowed to grow at their natural rate, all part of the Applegate mission - Changing The Meat We Eat®.

 

Problem

Multiple file types and data sources made ETL tasks an unappetizing experience for natural and organic meat producer Applegate.


Solution

The company found the recipe for successful data integration with SentryOne Task Factory's Email, REST, and SharePoint components for SQL Server Integration Services (SSIS).


Results

Now, Applegate's data integration process is seamless. Utilizing Task Factory's Email components, the team significantly reduced the time spent each day processing email attachments, which freed up time to optimize other ETL processes. For example, they streamlined the retrieval of JSON data from their help desk platform using Task Factory's REST Source. Leveraging the REST Source saved the team 20 hours of upfront programming time.

Applegate Case Study

To learn more about how Applegate used SentryOne Task Factory to significantly reduce the time spent on daily SSIS tasks, download the 6-page case study.

 

“I don't have to sit there and babysit the process. I know I can trust Task Factory.”

— Matt Cushing, Applegate Business Intelligence Developer
 

  

For Matt Cushing, a Business Intelligence (BI) Developer at natural and organic meat producer Applegate, the job responsibilities depend on the day. With more than 100 internal users—not to mention third-party vendors and shipping companies—across the country, Cushing must load data from multiple sources and in multiple formats. The data integration challenges are ever-changing.

“The things I do on a daily, weekly, or monthly basis tend to change based on what we need at the time—what we're working on or what's important,” Cushing explains. He spends much of each day focused on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), with a dash of PowerShell thrown in.

  

Find Out Why We're The One