SolarWinds Task Factory Reviews and Ratings

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.

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.

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.

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.

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.

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.

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.

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.

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.

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>

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.

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.

Use Cases and Deployment Scope

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

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.

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

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.

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.

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.

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.

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.