Item: SolarWinds Task Factory
Rating: 9
Author: Karl Blacquière

Use Cases and Deployment Scope

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).

Pros and Cons

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

Return on Investment

Cut our development time by at least 2 times, maybe 3 in some scenarios.
Help us in debugging scenarios (with the Error Extraction component).

Likelihood to Recommend

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.

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

Overall Satisfaction with Task Factory

Use Cases and Deployment Scope

Pros and Cons

Return on Investment

Likelihood to Recommend

SolarWinds Task Factory Feature Ratings