Task Factory: a must if you are serious in ETL development!
April 14, 2020

Task Factory: a must if you are serious in ETL development!

Karl Blacquière | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Task Factory

Task Factory is used by the BI and the Integration Department. It helps us to standardize the way we are extracting and transforming data into our data warehouse and also the way we are connecting different applications (CRM and ERP).
  • The Slowly Changing Dimension Component saves us a huge amount if time compared to the native SSIS component.
  • JSON Transform is really useful to convert record and send it to rest API.
  • The advanced derived columns allow us to use really cool functions that are not available in the regular transforms.
  • We were disappointed that the Marketto Connector has been retired from the components.
  • We had a problem integrating Task Factory with LegiTest (license problem). It took a lot of time for Sentry to find and fix this problem
  • Cut our development time by at least 2 times, maybe 3 in some scenarios.
  • Help us in debugging scenarios (with the Error Extraction component).
I think Task Factory is really helpful when building regular ETL in SSIS. IT helped us save time by replacing the native SSIS component with a more advanced one. However, there are some cases where TF was not performing well when the keys are GUID. We had to remove some TF components in that case.

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
Simple transformations
Complex transformations