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-1 of 1)Companies can't remove reviews or game the system. Here's why
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.
- Our first use case was integrating with our Partners' Secure FTP Sites. Task Factory did this seamlessly.
- Our second use case involved Excel. We have multiple groups that use Excel to monitor their processes, and using the Excel refresh task made this very quick and simple.
- Our third use case was for SMTP. The basic SMTP did not give us enough control out of the box that we needed. We send out E-mails on behalf of our partners using their SMTP servers, so being able to change those connections effortlessly using this task was a huge time saver.
- Not sure. I have not run into an instance where their transform didn't provide what I needed more easily than other solutions.
100%
10.0
90%
9.0
N/A
N/A
N/A
N/A
- Huge ROI. With the SFTP and Advanced SMTP it saved us weeks in changes and hard coding that we would have had to do and maintain. The cost of the license was recovered the first day we installed Task Factory.
Honestly, I had seen Task Factory being used in a previous shop, and when the need came up I went straight to them.
1
The only current users we have is the Data Engineers / DBA's which, currently is only 1 person. In the past we have had as many as 4 people using the product on the team but with Automation and due to the current climate we are down to just 1 person.
1
In the past we have had as many as 5 people that would support processes using TaskFactory but at the current time we are down to only 1 person to provide that ongoing maintenance and support. The good thing is that these components really don't need any maintenance or support.
- Data Warehouse ETL
- Report Automation
- Simplify SSIS Automation for DB maintenance jobs
- SSIS process for report delivery via thei Secure FTP and more robust Mail components
- Unknown at this time. When we are looking at automation this is a tool we tend to explore first to see if they can accomplish what we need
No
- Product Features
- Product Usability
- Vendor Reputation
For us, the most important factor in going with Task Factory was the amount of transformations it provides and the amount of time it has saved us from having to code that functionality in a Script object.
We would not change a thing. Task Factory has not only provided us with the functionality we initially purchased it for but has exceeded those initial needs with other benefits that we had no intention or thoughts that it may.
- Implemented in-house
No
Change management was minimal
We where actually implementing new reports and a new data warehouse so we were lucky in a sense that there where no old habits to break, retro fitting, etc. It was simple to get up and running. We were able to get new processes up and running quickly and it just worked.
- A few user issues
- Licensing configuration
Yes
For the few times we have had to reach out to them, they respond very quickly. There really has not been any extended downtime. They are great to work with. Compared to other vendors we have these guys are by far the best.
Yes
It was a long time ago but not only was it taken care of very quickly there was even very good followup from them to insure it was still taken care of. Great group.
Honestly there is nothing that stands out. They have been great every time we had to work with them.
- Secure FTP
- Mail
- Compression Task
- have not ran into any that where overly difficult