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…
Robust tool of working with data warehousing
Access High Performance SSIS with SolarWinds Task Factory
SolarWinds Task Factory Review
Speeds up ETL development but concerned about future direction
Task Factory makes me look great!
Task Factory and slowly changing dimensions
Task Factory Speeds Development
Upgrade to Upsert
A Package for your Packages!
Love Task Factory!
Task Factory: great for saving time !
Business …
Task Factory: a must if you are serious in ETL development!
Task Factory great for connecting to external sources
Task Factory Review
A tool every BI developer should have
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)
Task Factory Azure Data Factory
1,495 (annual subscription license)
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Features
Data Source Connection
Ability to connect to multiple data sources
- 9.4Connect to traditional data sources(40) Ratings
Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications
Data Transformations
Data transformations include calculations, search and replace, data normalization and data parsing
- 8.7Simple transformations(39) Ratings
Simple data transformations are calculations, data type conversions, aggregations and search and replace operations
- 9.6Complex transformations(35) Ratings
Complex data transformations are data normalization, advanced data parsing, etc.
Data Governance
Data governance is the practise of implementing policies defining effective use of an organization's data assets
- 9.2Integration with data quality tools(2) Ratings
Integration with tools for cleansing, parsing and normalizing data according to business rules
- 9.6Integration with MDM tools(3) Ratings
Integration with master data management tools to ensure data consistency across the organization
Product Details
- About
- Integrations
- Tech Details
- Downloadables
What is SolarWinds Task Factory?
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
- 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-5 of 5)Task Factory makes me look great!
- 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.
- 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.
- Connect to traditional data sources
- 100%10.0
- Simple transformations
- 90%9.0
- Complex transformations
- N/AN/A
- Having to only license production and not our development laptops makes it possible.
- Cost is always an impact, and Task Factory has kept the cost within reach for smaller environments like us.
- We use the Advanced email and SMS Task to alert us with package results, Pass or Fail
- Making great use of the Upsert Destination task, requiring far less development over previous methods used.
- Most recently find the SharePoint Destination to be a useful and simple task to use.
- Price
- Product Features
Task Factory Speeds Development
- Email notifications.
- File management.
- User defined settings for external package calls.
- Better software update methodology.
- Connect to traditional data sources
- 80%8.0
- Simple transformations
- 80%8.0
- Complex transformations
- 90%9.0
- Faster development has reduced the amount of time it takes for some tasks.
- Fewer script tasks make maintenance and administration easier.
- File transfers to facilitate EDI processes (SFTP)
- Salesforce integration with our data warehouse using Task Factory connectors
- Enhanced e-mail functionality, used for error handling and end-user delivery
- Performance using advanced lookup and caching
- Product Features
- Product Usability
- Prior Experience with the Product
We also reviewed Kingsway and Zappysys. Both also have complementary functionality. We may bring Zappysys into our ecosystem as well due primarily to their extensive web services and xml parsing capabilities.
A Package for your Packages!
- One-click Auditing Feature. Simply push a button, and all of your SSIS packages now have detailed auditing built-in, including the ability to watch it in real-time.
- Wide variety of connections. If you need to connect to a common data source, Task factory will have what you need. No need to roll your own anymore.
- The Upsert Component. Task Factory has a simple and FAST way to do an insert or update with new row data. It just works and works well.
- SCD component could be a little more intuitive.
- The help documents could be more detailed and current with what is actually released.
- Connect to traditional data sources
- 90%9.0
- Simple transformations
- 90%9.0
- Complex transformations
- 70%7.0
- The auditing part has been crucial to our team. We can realize errors and bugs so much faster. Which leads to a quicker resolution.
- Now that we don't have to create our own connections, we can create more packages instead!
- Needing to connect to various data sources, Task Factor has Custom Data source components
- Needing to quickly perform insert and update queries to our data set, Task Factory has a super fast upsert component.
- Needing to properly process a slowly changing dimension, Task Factory has an excellent SCD component that is feature rich and works fast.
- The upsert functionality was really surprising. We didn't think we would use it since we already have code that does it. However, their implementation was so much faster.
- The SCD component really makes it easier to load dimensional data over what you get out of the box. Every step is marked and all options are available to you that you can think of.
- There are many more components out there that we can use, specifically with loading from disparate data sources.
- Task Factory is always coming up with new improvements and custom components, so we know there will be some changes in the future!
Love Task Factory!
- 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.
- Connect to traditional data sources
- 100%10.0
- Simple transformations
- 90%9.0
- Complex transformations
- 90%9.0
- 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.
- 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
- Product Features
- Product Usability
- Vendor Reputation
- Implemented in-house
- A few user issues
- Licensing configuration
- Secure FTP
- Mail
- Compression Task
- have not ran into any that where overly difficult
Task Factory: great for saving time !
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).
- Read from APIs without code.
- Upset mechanism.
- Can be longer to debug.
- Need one license for dev servers.
- 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.
- 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).
- Connect to traditional data sources
- 70%7.0
- Simple transformations
- 80%8.0
- Complex transformations
- 70%7.0
- Can tackle data reads and writes without writing any code.
- Can be difficult to debug (especially the upsert component).
- Faster to develop features with SSIS
Task Factory was also easier to integrate with our actual code base and was cheaper than the alternative. We were very satisfied with our choice and we recommend Task Factory to anybody who wants to save code
- Integration Team (ex. building integrations between our separate systems)
- Business Intelligence Team (ex. building a data warehouse, reports and dashboards that use the data warehouse)
- Security Team (ex. building automation systems in our company for users )
- Create SSIS packages with less code
- Gather data from API
- Gather data from Sharepoint
- Gather data from sharepoint
- Gather data from Facebook
- Gather data from other sources
- Price
- Product Features