Task Factory Makes ETL Development Easier
September 10, 2019

Task Factory Makes ETL Development Easier

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Task Factory

My department's role is to support business intelligence reporting of ITIL process areas. We are currently using Task Factory to perform ETL processing and data warehouse processing. We utilize the email task to send our reports in pdf format, and we also rely on the data warehouse fact processing task and the dimension processing task as it makes processing much smoother and easier to manage.
  • Advanced Email task makes it easier for an end-user to configure.
  • Fact Load task makes the data flow much easier to manage than the OOTB lookup function in SSIS.
  • Dimension Load task makes it easier to track multiple dimension types when loading into the DB.
  • Would really like to see an SSRS generate PDF output with parameter input.
  • Load improvement for larger datasets in the Upsert function.
  • Consistency with expressions for every task.
  • Huge time saver when developing ETL processes.
  • However, with larger datasets, we shy away from the upsert function as it takes to much time.
  • REST source connections have significantly improved the ROI for us as we are moving towards API pulls.
When we were doing research on if Task Factory was a viable option for us, we found that the large array of tasks that it offers and the low cost of all of it was much better than the competition. We found that we would have to buy a culmination of tools just to pull together what Task Factory has under one roof.
The Nulls processing task has really improved the speed it takes to transform null data. Otherwise, scripting is involved or a very lengthy derived column tasks will need to be developed. This would make it really hard to manage, especially when you have over 100 ETL processes to manage.

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
Simple transformations
Complex transformations