Skip to main content
TrustRadius
SolarWinds Task Factory

SolarWinds Task Factory

Overview

What is SolarWinds Task Factory?

According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components…

Read more
Recent Reviews

TrustRadius Insights

Upsert Component: Highly praised for its simplicity and ease of use, the Upsert component in Task Factory has been mentioned by several …
Continue reading
TrustRadius Insights
TrustRadius Insights

Upgrade to Upsert

10 out of 10
April 30, 2020
Incentivized
Our prima facie need was to increase the speed for loading our data warehouses. We used SSIS, and needed an easy way to convert to bulk …
Continue reading

Task Factory Review

8 out of 10
March 22, 2020
Incentivized
Our Data Integration team uses Task Factory as a 3rd-party plugin tool to support Microsoft SSIS packages. Task Factory makes our job …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 5 features
  • Complex transformations (35)
    9.6
    96%
  • Connect to traditional data sources (40)
    9.4
    94%
  • Simple transformations (39)
    8.7
    87%
Return to navigation

Pricing

View all pricing

Task Factory

1,245 (annual subscription license)

On Premise
per server

Task Factory Azure Data Factory

1,495 (annual subscription license)

On Premise
per ADF node

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.sentryone.com/products/task…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

9.4
Avg 8.2

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

9.1
Avg 8.4

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

9.4
Avg 8.2
Return to navigation

Product Details

What is SolarWinds Task Factory?

According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been optimized to ensure fast performance of data-centric applications, and the user can run Task Factory on an Azure-SSIS Integration Runtime (IR) with Task Factory Azure Data Factory edition.

SolarWinds Task Factory Features

Data Source Connection Features

  • Supported: Connect to traditional data sources

Data Transformations Features

  • Supported: Simple transformations
  • Supported: Complex transformations

Data Governance Features

  • Supported: Integration with data quality tools
  • Supported: Integration with MDM tools

SolarWinds Task Factory Screenshots

Screenshot of Salesforce.com SourceScreenshot of Dimension Merge SCD TransformScreenshot of Upsert DestinationScreenshot of REST Source

SolarWinds Task Factory Integrations

SolarWinds Task Factory Technical Details

Deployment TypesOn-premise
Operating SystemsWindows
Mobile ApplicationNo

SolarWinds Task Factory Downloadables

Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(64)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Upsert Component: Highly praised for its simplicity and ease of use, the Upsert component in Task Factory has been mentioned by several users as a valuable feature. Users appreciate that with just a few clicks, they can perform merge operations without the complexities of writing code.

Extended Functionality: Many users find Task Factory to be highly beneficial due to its ability to extend the functionality of native SSIS components. This aspect allows them to work with a wider range of data sources and perform tasks that would otherwise be challenging with only native components.

Seamless Integration: The seamless integration capabilities of Task Factory have been highlighted by users. They mention specific use cases such as integrating with partners' Secure FTP sites, working with Excel, and sending out emails using partners' SMTP servers. Users appreciate how Task Factory simplifies these tasks and saves them significant time.

Challenging execution against non-licensed servers: Some users have found it challenging to execute packages against servers that do not have proper licenses, which has required them to search for alternative solutions or workarounds.

Lack of detailed logging for errors: Users have expressed a strong desire for more comprehensive and detailed logging capabilities when components encounter errors. This would enable better troubleshooting and analysis of issues during package execution.

Lack of notifications for software updates: Several users have mentioned that they were not notified or alerted when new versions of the software became available. This lack of notification caused them to miss out on important updates and improvements to the product.

Attribute Ratings

Reviews

(1-25 of 40)
Companies can't remove reviews or game the system. Here's why
December 23, 2021

Robust tool of working with data warehousing

Nancy Petrey | TrustRadius Reviewer
Nancy Petrey
Business Analyst
Link Group (LNK) (Financial Services, 5001-10,000 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Since I started working with this great tool all data analysis programs have been running effectively. Implementation of projects and tasks have been effective and reliable. Data collected from each department gives us working plan on better management of various programs. The Dimension Merge SCD Transform helps us to load large volumes of data within a short period of time.
September 08, 2021

Access High Performance SSIS with SolarWinds Task Factory

Holly Couch | TrustRadius Reviewer
Holly Couch
Executive Administrator
Alliance Data Card Services (Financial Services, 5001-10,000 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
If you are an MS Dynamics CRM User, you should consider SolarWinds Task Factory because it integrates data in real-time. Also, if it is hectic to encrypt and decrypt data, it is advisable to implement SolarWinds Task Factory for incoming and out-coming data.
September 06, 2021

Speeds up ETL development but concerned about future direction

Verified User
Professional in Information Technology
Oil & Energy Company, 501-1000 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
April 28, 2021

Task Factory makes me look great!

Verified User
Administrator in Information Technology
Education Management Company, 1001-5000 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
One task we use with every package is the Advanced Email task, although simple and used primarily for our monitoring of package success, it is helpful and simple to use. Only downside as with any product is it does require some maintenance and has had the occasional blip of an update breaking an existing functionality.
April 13, 2021

Task Factory Speeds Development

JS
John Stuchly
Data Developer
HKS Inc (Architecture & Planning, 1001-5000 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Being able to easily call packages from other projects is the biggest win. Having a single process to handle all child calls is a big win over using the standard component for calls within a project, and some other mechanism (via SQL stored procedure calls and/or SQL agent calls) for packages not within the same project.
April 30, 2020

Upgrade to Upsert

Bob Amy | TrustRadius Reviewer
Bob Amy
Sr. Architect - Data warehousing & BI
Molina Health Care (Insurance, 5001-10,000 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend

I bought Task Factory for the Upsert, Bulk update, and Bulk delete tools. It was WELL worth it to not have to develop bulk loading techniques ourselves.

I never got the chance to use the nuggets tool for generic code patterning.

April 28, 2020

Love Task Factory!

Steven Gockley, MBA, MCSA | TrustRadius Reviewer
Steven Gockley, MBA, MCSA
DBA / Sr. Data Analyst
Boostability (Marketing and Advertising, 201-500 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
We use Task Factory a lot for our report automation. We have several use cases where we send out thousands of reports on a schedule to certain groups of customers, and Task Factory allows us to easily get files and move them via SFTP, FTP, or Email very easily. We have used it in our data warehouse as well, but not as heavily.
April 28, 2020

Task Factory: great for saving time !

Verified User
Team Lead in Information Technology
Telecommunications Company, 1001-5000 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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).
April 14, 2020

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

Karl Blacquière | TrustRadius Reviewer
Karl Blacquière
Bi Architect
Genetec (Computer Software, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
March 25, 2020

Task Factory great for connecting to external sources

Verified User
Manager in Information Technology
Financial Services Company, 51-200 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Task Factory is well suited for integration with Salesforce, REST APIs and other offline sources.
Rather than programme your own connectors, the Task Factory connectors will make it simple and easy to download and parse data from JSON/XML into a database or table.

Task Factory is less suited for custom/very secure API connections especially if they require hashing the connection string each time.
March 22, 2020

Task Factory Review

Verified User
Engineer in Information Technology
Information Technology & Services Company, 10,001+ employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Task Factory works well if we need to connect to any 3rd-party website/tool like CRM / web services / WebAPI, where we can easily download/upload files without writing any code.

Task Factory is less effective in a SharePoint connection feature task where they don't have a variable option to overwrite the existing file in SharePoint site.
November 23, 2019

I would use Task Factory even if it cost more!

JH
John C Hill
Business Intelligence Manager
McIntire School of Commerce (Information Technology & Services, 51-200 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
For the tasks available in Task Factory, it does them very well. The upsert task is ideal for my uses. I do wish that there was some sort of delete or mark as delete feature when loading data into a data warehouse. We don't run Enterprise Edition of SQL Server so we don't have the change data capture feature.
October 28, 2019

Salesforce just got easier due to Task Factory

Verified User
Professional in Information Technology
Computer Software Company, 201-500 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Works great for Salesforce. I can take any flat file or other source and upsert to Salesforce. I think the other way around is also well done. I would like to see a better way to create the relationship between records, but otherwise well done. It has always finished the tasks we need it to.
October 09, 2019

Helpful supplement to our SQL Server's base offerings

Verified User
Director in Information Technology
Financial Services Company, 201-500 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Utilities such as Upsert have provided us with significant improvements in the reduction of repetitive code.

Because of bugs/complications with data type conversions (eg. Decimal to Numeric), care must be taken when converting numeric types.
September 10, 2019

Task Factory saves vast amounts of time

BA
Brett Archer
Programmer Analyst
Idaho Department of Health and Welfare (Government Administration, 1001-5000 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Well suited for upserts. However, there are some limitations based upon primary keys, column names, etc. Sometimes if you package crashes or fails, Task Factory doesn't clean the temporary objects in the database.
September 10, 2019

Task Factory Makes ETL Development Easier

Verified User
Manager in Information Technology
Information Technology and Services Company, 501-1000 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
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.
August 26, 2019

Streamlined data processes

JL
Jason Loy
Sr. Data Analyst
Southern New Hampshire University (Higher Education, 1001-5000 employees)
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Task Factory seems like it would be great for moving data out of our third-party systems and into our own data warehouse where it can be combined with our other mission-critical data. We are really seeking a way in which we can merge our users' front-end behavior and actions with back-end outcomes. Task Factory seems suited to the task.
Return to navigation