TrustRadius Insights
Upsert Component: Highly praised for its simplicity and ease of use, the Upsert component in Task Factory has been mentioned by several …
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…
Recent 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
- Complex transformations (35)9.696%
- Connect to traditional data sources (40)9.494%
- Simple transformations (39)8.787%
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
Features
Return to navigation
Product Details
- About
- Integrations
- Tech Details
- Downloadables
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
SolarWinds Task Factory Integrations
- Microsoft SQL Server
- Salesforce Sales Cloud
- Microsoft Dynamics 365
- Microsoft SharePoint
- Azure Machine Learning
- REST
SolarWinds Task Factory Technical Details
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows |
| Mobile Application | No |
SolarWinds Task Factory Downloadables
Comparisons
Compare with
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!
- Pros
- Cons
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
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.
September 08, 2021
Access High Performance SSIS with SolarWinds Task Factory
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.
September 06, 2021
SolarWinds Task Factory Review
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.
September 06, 2021
Speeds up ETL development but concerned about future direction
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.
April 28, 2021
Task Factory makes me look great!
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.
April 13, 2021
Task Factory and slowly changing dimensions
I use the tools mainly for the slowly changing dimensions as we load our warehouse.
April 13, 2021
Task Factory Speeds Development
We have been using Task Factory to better standardize our ETL and to reduce the number of script tasks leveraged. It is primarily used for data flow and control flow tasks, although some connections are used as well. This is used as a standard, centralized tool within IT, along with other 3rd party SSIS tools.
April 30, 2020
Upgrade to Upsert
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.
April 28, 2020
A Package for your Packages!
We use Task Factory within our team. We have a need to ensure efficient ETL design to drive our high-performing data-centric application. Task Factory helps us reduce development time spent programming custom SSIS tasks, gives us components and tasks that are optimized to perform well in production, and a broad array of connections to various data platforms.
April 28, 2020
Love Task Factory!
We are heavy SQL Server Integration Services shop. There are a number of instances where we were faced with hand-coding solutions that would take hours or days to implement, but with Task Factory we were able to do it in seconds. We have a large number of highly visible, customer-facing processes that depend on Task Factory, and it has been very reliable and easy to use.
April 28, 2020
Task Factory: great for saving time !
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).
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).
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).
March 25, 2020
Task Factory great for connecting to external sources
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.
March 22, 2020
Task Factory Review
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.
February 27, 2020
A tool every BI developer should have
Task Factory is being used by the IT BI department. It is part of our daily SSIS processes, for example, reads from XML or JSON sources, extracts from websites, compresses and decompresses zip files, handles data to be inserted or updated on tables, parses address information, sends email on different stages of the process.
Specifically, we can use it to download a zip file and decompress it and later use TF Upsert to update or insert zip code data into tables.
Specifically, we can use it to download a zip file and decompress it and later use TF Upsert to update or insert zip code data into tables.
November 23, 2019
I would use Task Factory even if it cost more!
Task Factory is used in the IT department only. It addresses the need for data connections and transformations that are not included in the base SQL Server Integrations Services system.
November 19, 2019
Task Factory's Integration with Salesforce
We use it for linking our SQL DB to the Salesforce cloud connection for data integration and a variety of other data processing components.
November 02, 2019
Good tool but needs to catch up to the competition
Used and implemented by my team , serving company needs . Connecting to REST API.
October 28, 2019
Salesforce just got easier due to Task Factory
Our Business and Application Reporting team is using this tool. We are using this to take the data from our Salesforce org into a data warehouse. Once the data is there we use it to create Microsoft Power BI reports. Also we use Task Factory to upsert data into Salesforce for any data migration projects. This has solved a numerous amount of issues regarding moving Salesforce data in and out of our data warehouse and other ETL.
October 25, 2019
Task Factory Review
It was initially used to upload and download data from Salesforce. It was then used as part of our ETL to load data for Analysis Services models, both MOLAP and Tabular.
October 09, 2019
Helpful supplement to our SQL Server's base offerings
Purchased for Salesforce connectivity from our SQL Server platform. We have since leveraged other features such as Upsert.
It is used in support of our organization-wide data warehouse.
It is used in support of our organization-wide data warehouse.
September 10, 2019
Task Factory saves vast amounts of time
The main reason we purchased Task Factory was to decrease the time to do Upserts into SQL Server and Oracle databases. Without it, developers would manually have to do lookups/inserts/updates in SSIS.
Although this was the main reason for the purchase, there are so many other components we use in SSIS like the termination task, the Sharepoint task, and the email task. Some of these tasks seem like "no brainers" that should be in SSIS by default!
Although this was the main reason for the purchase, there are so many other components we use in SSIS like the termination task, the Sharepoint task, and the email task. Some of these tasks seem like "no brainers" that should be in SSIS by default!
September 10, 2019
Task Factory Makes ETL Development Easier
My department's role is to support business intelligence reporting of ITIL process areas. We are currently using Task Factory to perform ETL processing and data warehouse processing. We utilize the email task to send our reports in pdf format, and we also rely on the data warehouse fact processing task and the dimension processing task as it makes processing much smoother and easier to manage.
August 26, 2019
Streamlined data processes
I am testing Task Factory features and functionality to determine if it's a good fit for our organization. It is currently not widely implemented across the business, but there is potential for it if the POC proves viable. I am primarily looking at Task Factory to replace cumbersome, manual API calls and to streamline data flow from 3rd parties into our internal data warehouses.
August 19, 2019
Task Factory made things possible
We are using Task Factory in our daily ETL processes. These processes are built and maintained by the Business Intelligence department