A tool every BI developer should have
February 27, 2020

A tool every BI developer should have

Francisco Murillo | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Task Factory

Task Factory is being used by the IT BI department. It is part of our daily SSIS processes, for example, reads from XML or JSON sources, extracts from websites, compresses and decompresses zip files, handles data to be inserted or updated on tables, parses address information, sends email on different stages of the process.
Specifically, we can use it to download a zip file and decompress it and later use TF Upsert to update or insert zip code data into tables.
  • Upsert data on dimensions
  • Read XML and JSON information from website
  • Allow Upsert to just load bulk data
  • Simplify daily developments
Task Factory is well suited to update and insert data on EDW database.

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
9
Simple transformations
9
Complex transformations
9