A Package for your Packages!
Updated April 28, 2020
A Package for your Packages!
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Task Factory
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.
- 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.
- 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!
Task Factory is more than just components. It is more than just monitoring. It is an entire suite of tools for SSIS package development. And this is not a case of someone going wide but not going deep. Task Factory by Sentry One (formerly of Pragmatic Works) goes wide and deep. You are getting a complete package here for your packages.
SolarWinds Task Factory Feature Ratings
Using Task Factory
10 - The people in our organization who use Task Factory are Extract, Transform, and Load (ETL) developers who use SQL Server Integration Services (SSIS) as their ETL tool. They represent all areas of our business. This is because the developers are not assigned to any one business function. Instead, they support the entire organization's business needs.
1 - We only have one person in-house to support Task Factory on an on-going basis. In addition, this person does not spend more than a few hours a month in support of the product. We have a Database Administrator (DBA) who sets up and maintains the product. You will need a DBA to get Task Factory up and running on any of your servers. It is possible for a developer to install the SSIS components themselves but they will not be able to deploy the solution to a server until they are properly installed on the server.
- 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!