Task Factory: great for saving time !
Updated April 28, 2020

Task Factory: great for saving time !

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

Overall Satisfaction with Task Factory

Usage: We are using Task Factory inside the IT department to enhance the capabilities of SSIS (SQL Server Integration services).

Business problem: Your team can keep using SSIS and tackle data problems they could not resolve before (read from different sources without any code and do data upsert in one component).

Pros

  • Read from APIs without code.
  • Upset mechanism.

Cons

  • Can be longer to debug.
  • Need one license for dev servers.
  • Can tackle data reads and writes without writing any code.
  • Can be difficult to debug (especially the upsert component).
  • Faster to develop features with SSIS
We wanted more ways to connect with other sources and Task Factory offer the best suited solution.

Task Factory was also easier to integrate with our actual code base and was cheaper than the alternative. We were very satisfied with our choice and we recommend Task Factory to anybody who wants to save code
Well suited:
  • When the capabilities of SQL Server Integration Services (SSIS) are not enough for you.
  • When you want to extract data from web sources without writing some code.
Not Well suited:
  • If you have separate servers for all your environments (that will cost you more money).
  • If your team does not know SSIS enough (the tool can be difficult to debug).

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
7
Simple transformations
8
Complex transformations
7

Using Task Factory

8 - They represent the IT department in our organization more specifically the following teams in the department:
- Integration Team (ex. building integrations between our separate systems)
- Business Intelligence Team (ex. building a data warehouse, reports and dashboards that use the data warehouse)
- Security Team (ex. building automation systems in our company for users )
3 - To support Task Factory you need a good understanding of SQL Server Integration Services (SSIS). You need to be able to debug transformations. We also have the help of our system administrators to install the software on our virtual machines and to perform updates of the software on a regular basis
  • Create SSIS packages with less code
  • Gather data from API
  • Gather data from Sharepoint
  • Gather data from sharepoint
  • Gather data from Facebook
  • Gather data from other sources
We still have a lot of actual integrations that still use components from Task Factory and we continue to create transformations that use it. Also, we found new ways to use the components (ex. Facebook, Sharepoint)

Evaluating Task Factory and Competitors

  • Price
  • Product Features
One of our previous business intelligence architect were using the product in the past and warmly recommend the product to us. We validate the price against our budget and it was fitting!
Had more other options, at the time, our experience with SQL Server Integration Services (SSIS) was not as deep as now. So we found ways to create transformations without using the product. Also, our analysis contained only 1 product.

Comments

More Reviews of SolarWinds Task Factory