Case Study: Applegate achieves seamless ETL automation with SentryOne Task Factory

Serving Up Seamless ETL Processes with Task Factory

Applegate, a natural and organic meat producer, needed to manage ETL processes across multiple file types and data sources, including email attachments, JSON, Excel, and SharePoint content. Its BI team was spending too much time handling unpredictable inputs and maintaining SSIS tasks, and it needed a more efficient way to integrate data into its warehouse, using SentryOne Task Factory.

SentryOne implemented Task Factory components including Email Source, REST Source, and SharePoint Connection Manager to automate data collection and loading in SSIS. The result was a seamless ETL workflow that reduced daily time spent processing email attachments and saved Applegate 20 hours of upfront programming time for one REST integration, while freeing the team to focus on improving other processes.

Applegate

Matt Cushing

Business Intelligence Developer