Thumbs Up for Task Factory!
April 20, 2019

Thumbs Up for Task Factory!

Steve Mayer | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Task Factory

Task Factory was selected for two primary reasons. First and foremost, because of the extensive library of functions it makes available in SSIS to ease the SSIS programmer's job of importing and cleansing data. Second, because of the logging and notification features that it makes available which allow us to easily track the record counts of data we imported and easily notify us if there are issues with the execution of an SSIS process. Task Factory is used by our IT department, but we import data from 15-20 State agencies, so it indirectly affects many of our processes.
  • Better data cleansing and validation functions than are available in basic SSIS.
  • Better database insert and update functions than in SSIS.
  • Ease of use of functions provided.
  • Re-introduce the prior feature to allow a user to copy or move SSIS variables from one package or scope to another.
  • Provide a better upgrade path from one version of the product to another higher version. Our upgrade from 2008 to 2016 was quite complex and it seemed as though we might have been the first such upgrade Pragmatic Works had encountered.
  • The product allows us to develop SSIS packages more quickly than standard SSIS.
  • Pragmatic Works (now SentryOne) offers training on SSIS, SSAS and other topics that have been very beneficial to our staff members and allowed us to train staff without sending them to classes, as the training is offered in an online format.
  • Pragmatic Works (SentryOne) has a great support team that provides help when you need it, and offers Mentoring Hours to allow you to get help from consultants when you hit issues on which you need assistance.
I would definitely recommend the product for any SSIS project. We saw its benefits from the very beginning, even when we had only a few SSIS packages. We are now up to over 120 SSIS packages and process files from over 20 sources on a regular basis, including weekly, monthly, quarterly and annually. We cleanse the data and use it to build data warehouses and SSAS cubes for consumption by numerous State agencies.

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
Simple transformations
Complex transformations