Speeds up ETL development but concerned about future direction
September 06, 2021
Speeds up ETL development but concerned about future direction
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with SolarWinds Task Factory
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.
- Merge (Insert/update) loads.
- SharePoint connectors.
- Row filters.
- It was built by Pragmatic Works who sold it to SentryOne and now Solar Winds, concerned about future support. SolarWinds is discontinuing support for related products such as BiXpress.
- Had issues with connecting to certain versions of SQL Server - would fail when deploying one package - had to deploy the entire solutions.
- Occasional random failures observed with the Filter tranform.
- Quick turnaround on ETL development.
- Junior programmers can be assigned complex tasks.
- Occasional failures can lead to unexpected support issues.
We really did not look at any other products. We had already heard of SolarWinds Task Factory previously. We hired Pragmatic Works for a consulting project and they owned the product at that time and implemented it in-house.