Better quality outcomes with less code cutting
July 17, 2019

Better quality outcomes with less code cutting

Mickeal Davis | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Task Factory

Task Factory is used within our Business Systems team for the development of SSIS packages for ETLs into our data warehouse and other applications.
It speeds up development time by adding very useful transforms that are easier to use than the standard Microsoft transforms as well. It makes debugging and development faster.

Pros

  • Expression editor is by far better than that in standard SSRS.
  • The SharePoint destination and source is much easier to use than standard SSRS.
  • The slowly changing dimension transform is very easy to use and adds a level of capability that gives a better outcome.

Cons

  • More worked examples in the help.
  • It actually simplifies the SSIS packages and means there are less steps within a package.
  • We have high staff turnover so using TaskFactory gets new employees able to understand and maintain existing packages faster.
We've only compared it to standard Microsoft, and we selected Task Factory after the 30-day trial.
Managing slowly changing type 2 dimensions along with auditing information is best done with the SCD Transform.

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
10
Simple transformations
10
Complex transformations
9

Comments

More Reviews of SolarWinds Task Factory