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®.
Multiple file types and data sources made ETL tasks an unappetizing experience for natural and organic meat producer Applegate.
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).
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.
“I don't have to sit there and babysit the process. I know I can trust Task Factory.”
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.