Item: SolarWinds Task Factory
Rating: 8
Author: Peter Berrens

Use Cases and Deployment Scope

We are using Task Factory in our daily ETL processes. These processes are built and maintained by the Business Intelligence department

Pros and Cons

The task to call another package in a different solution
Advanced lookup and other tasks

Improvement can be achieved when new releases are tested better. We had a few times that our ETL stopped when implementing a new release.

Return on Investment

We are able to run our ETL without manual intervention, so we spent fewer hours on this.

Alternatives Considered

Microsoft SQL Server

Task Factory just has more options and tasks needed to run a fully automatic ETL.

Other Software Used

Microsoft SQL Server, Microsoft 365 Business

Likelihood to Recommend

When having a complex ETL environment and calling packages in different solutions, it's the only software we found that works according to expectations.

Task Factory made things possible

Overall Satisfaction with Task Factory