Task Factory Makes ETL Development Easier
September 10, 2019
Task Factory Makes ETL Development Easier
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Task Factory
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.
- Advanced Email task makes it easier for an end-user to configure.
- Fact Load task makes the data flow much easier to manage than the OOTB lookup function in SSIS.
- Dimension Load task makes it easier to track multiple dimension types when loading into the DB.
- Would really like to see an SSRS generate PDF output with parameter input.
- Load improvement for larger datasets in the Upsert function.
- Consistency with expressions for every task.
- Huge time saver when developing ETL processes.
- However, with larger datasets, we shy away from the upsert function as it takes to much time.
- REST source connections have significantly improved the ROI for us as we are moving towards API pulls.
When we were doing research on if Task Factory was a viable option for us, we found that the large array of tasks that it offers and the low cost of all of it was much better than the competition. We found that we would have to buy a culmination of tools just to pull together what Task Factory has under one roof.