Upgrade to Upsert
April 30, 2020

Upgrade to Upsert

Bob Amy | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Task Factory

Our prima facie need was to increase the speed for loading our data warehouses. We used SSIS, and needed an easy way to convert to bulk updates and deletes. Task Factory offers several tools that reduce our load time by about 60 times. These are Upsert, Bulk Update and Bulk delete. We were already using the SSIS fast load, but had we had Task Factory earlier, it would have saved a huge amount of development. We have used a few of the other tools as well, but unfortunately, our addition of Task Factory was retrofit and not new development.
  • Fast, large updates and deletes.
  • Simple Upsert logic.
  • Very nice integrated help, including video.
  • Easy to install, well documented, and easy to use.
  • Support was excellent under Pragmatic Works. I cannot attest to Sentry One.
  • We had one case of an upgrade that would not work with existing code. They did release a next version very quickly.
  • Task Factory allowed us to quadruple our data volume without scaling out our systems. Just implementing the fast update tools improved SSIS performance enough to maintain SLAs.

I bought Task Factory for the Upsert, Bulk update, and Bulk delete tools. It was WELL worth it to not have to develop bulk loading techniques ourselves.

I never got the chance to use the nuggets tool for generic code patterning.

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
Simple transformations
Complex transformations