Speeds up ETL development but concerned about future direction
September 06, 2021

Speeds up ETL development but concerned about future direction

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

Overall Satisfaction with SolarWinds Task Factory

It is being used across the organization. Task Factory makes it easy to achieve functionality that is not available within native SSIS. It saves a lot of coding time by making available out-of-the-box connectors and tasks that SSIS does not offer or has poor performance issues with. Speeds up time to market on ETL jobs.
  • Merge (Insert/update) loads.
  • SharePoint connectors.
  • Row filters.
  • It was built by Pragmatic Works who sold it to SentryOne and now Solar Winds, concerned about future support. SolarWinds is discontinuing support for related products such as BiXpress.
  • Had issues with connecting to certain versions of SQL Server - would fail when deploying one package - had to deploy the entire solutions.
  • Occasional random failures observed with the Filter tranform.
  • Quick turnaround on ETL development.
  • Junior programmers can be assigned complex tasks.
  • Occasional failures can lead to unexpected support issues.
We really did not look at any other products. We had already heard of SolarWinds Task Factory previously. We hired Pragmatic Works for a consulting project and they owned the product at that time and implemented it in-house.
Speeds up ETL development - so good for small shops and not very expensive. Not required where there is a big team of programmers and resistance to using 3rd party products. Also, the fact that SolarWinds is dropping some related products makes me nervous and want to build my own products.

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
Simple transformations
Complex transformations
Integration with MDM tools