SolarWinds Task Factory Reviews and Ratings

Rating: 8.2 out of 10

Score

8.2 out of 10

Community insights

TrustRadius Insights for SolarWinds Task Factory are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

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.

Reviews

40 Reviews

Robust tool of working with data warehousing

Rating: 10 out of 10

Incentivized

December 23, 2021

Use Cases and Deployment Scope

It gives us best platform for connecting all data sources. Collection of data from our partners and clients gives us insights on how to manage our company better. When publishing our marketing campaigns it gets information and feedback from our clients comments. Our web designing team has been able to program most platforms without coding.

Pros

Managing data warehousing.
Integrating our servers to accelerate components.

Cons

I have not experienced any challenge from the operation of this great tool.
All the data tools function excellently.

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.

Nancy Petrey

Business Analyst in Finance and Accounting at Link Group (LNK) (5001-10,000 employees)

Vetted Review

2 years of experience

View profile

Access High Performance SSIS with SolarWinds Task Factory

Rating: 10 out of 10

Incentivized

September 8, 2021

Use Cases and Deployment Scope

We use SolarWinds Task Factory across our team to manage data by connecting all sources in one integrated solution, including REST sources. Managing ETL and ELT tasks is less tedious with SolarWinds Task Factory.

Pros

With Task Factory, it is easy to connect data from multiple sources such as SharePoint, Microsoft Excel, Facebook, etc.
Extension of SSISS with zero coding has enabled us to save time while managing the data warehouse.
Also, SolarWinds Task Factory makes it easy to automate metadata tasks in real-time.

Cons

Pricing is way too expensive compared to other alternatives.
Unavailability of existing mobile application.

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.

Holly Couch

Executive Administrator in Corporate at Alliance Data Card Services (5001-10,000 employees)

Vetted Review

1 year of experience

View profile

SolarWinds Task Factory Review

Rating: 7 out of 10

Incentivized

September 6, 2021

Use Cases and Deployment Scope

It is used by our organization to optimize our data warehouse and streamline many tedious data warehouse management tasks. It also helped us to become cloud-ready and increase our productivity. Task Factory also helped to improve the performance of our data-centric applications and speed up our batch processing.

Pros

Improve performance.
Increase productivity.

Likelihood to Recommend

It is affordable and easy to use for our system. It also reduces the amount of effort required for our data warehouse tasks and now we do not need to do the tasks manually.

Verified User

Manager in Information Technology (11-50 employees)

Vetted Review

2 years of experience

Speeds up ETL development but concerned about future direction

Rating: 8 out of 10

Incentivized

September 6, 2021

Use Cases and Deployment Scope

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.

Pros

Merge (Insert/update) loads.
SharePoint connectors.
Row filters.

Cons

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.

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.

Verified User

Professional in Information Technology (501-1000 employees)

Vetted Review

4 years of experience

Upgrade to Upsert

Rating: 10 out of 10

Incentivized

April 30, 2020

Use Cases and Deployment Scope

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 updates and deletes. Task Factory offers several tools that reduce our load time by about 60 times. These are Upsert, Bulk Update and Bulk delete. We were already using the SSIS fast load, but had we had Task Factory earlier, it would have saved a huge amount of development. We have used a few of the other tools as well, but unfortunately, our addition of Task Factory was retrofit and not new development.

Pros

Fast, large updates and deletes.
Simple Upsert logic.
Very nice integrated help, including video.
Easy to install, well documented, and easy to use.
Support was excellent under Pragmatic Works. I cannot attest to Sentry One.

Cons

We had one case of an upgrade that would not work with existing code. They did release a next version very quickly.

Likelihood to Recommend

<p>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.</p><p>I never got the chance to use the nuggets tool for generic code patterning.</p>

Bob Amy

Sr. Architect - Data warehousing & BI in Information Technology at Molina Health Care (5001-10,000 employees)

Vetted Review

6 years of experience

View profile

Task Factory makes me look great!

Rating: 10 out of 10

Incentivized

April 23, 2020

Use Cases and Deployment Scope

Task Factory is used to support our SQL Server Integration Services (SSIS) needs. SSIS has many tasks built in but we have found they fall short of our needs and Task Factory fills that gap for us. The components provided are well designed and easy to configure for the package to use and allow parameters to be configured for ease of use across environments.

Pros

The SFTP task is particularly helpful with proxy capabilities and setup with environment variables.
The RestAPI task is something new that we have found helpful now.
The latest UpSert task has also been a great addition.

Cons

I thought it needed to improve the UpSert task to include delete capabilities but was informed it is present. Just might be useful to be more apparent to an infrequent user.

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.

Verified User

Administrator in Information Technology (1001-5000 employees)

Vetted Review

3 years of experience

Task Factory and slowly changing dimensions

Rating: 7 out of 10

Incentivized

April 22, 2020

Use Cases and Deployment Scope

I use the tools mainly for the slowly changing dimensions as we load our warehouse.

Pros

Slowly changing dimensions.
Error logging during the process.
Ease of setup.
The ability to move records to different tables based on the data.

Cons

None

Likelihood to Recommend

I only use the tool for our slowly changing dimensions in our data warehouse. The error hanging is great and the ability to move records around to other tables based on the data is a nice feature.

Verified User

Director in Information Technology (10,001+ employees)

Vetted Review

7 years of experience

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

Rating: 9 out of 10

Incentivized

April 14, 2020

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

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.

Cons

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

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.

Karl Blacquière

Bi Architect in Information Technology at Genetec (1001-5000 employees)

Vetted Review

5 years of experience

View profile

Task Factory great for connecting to external sources

Rating: 9 out of 10

Incentivized

March 25, 2020

Use Cases and Deployment Scope

Task Factory is being used to integrate to a number of external organisations and data sources so it can be loaded into our organisations data warehouse. It helps make the integrations through SSIS very easy and simple using Task Factory's connectors. The main connector we are using it for is the Salesforce ones which are simple and effective.

Pros

Easy to install.
Easy to use.
Great support if stuck.

Cons

New connectors are not released very often.
Updating the connectors is not an easy task.
Troubleshooting a problem can be difficult.

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.

Verified User

Manager in Information Technology (51-200 employees)

Vetted Review

4 years of experience

Task Factory Review

Rating: 8 out of 10

Incentivized

March 22, 2020

Use Cases and Deployment Scope

Our Data Integration team uses Task Factory as a 3rd-party plugin tool to support Microsoft SSIS packages. Task Factory makes our job simple in terms of connecting to "CRM", "SharePoint" or to pull data/files from a web service where we don't need to write a C# code to get this done. Also, it seems very effective when doing encryption and decryption techniques.

Pros

Task Factory does a pretty good job in terms of connecting to any 3rd-party website/Web API/CRM and downloading/uploading files into them without using any program code.
Task Factory makes it easier to encrypt/decrypt incoming/outgoing files.

Cons

I believe they should improve the "address parser" feature where it simply parses the incoming address but didn't check/verify whether the incoming address is valid (or) checks whether the address has USPS address standard format.

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.

Verified User

Engineer in Information Technology (10,001+ employees)

Vetted Review

4 years of experience

Loading Reviews List....