Helpful supplement to our SQL Server's base offerings
October 09, 2019

Helpful supplement to our SQL Server's base offerings

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Task Factory

Purchased for Salesforce connectivity from our SQL Server platform. We have since leveraged other features such as Upsert.
It is used in support of our organization-wide data warehouse.

Pros

  • Upsert - simplifies coding.
  • Facilitates an odbc connection to the Sales Force world without the complication of using APIs.
  • Various other utilities to simplify ETL development.

Cons

  • We have run into compatibility issues or low level problems between SQL server and Task Factory. Working with both SentryOne and Microsoft, they both ended up blaming each other and not offering a fix.
  • Reduced development time due to utilities.
  • Avoid adding .NET developers to code to API's by exposing simpler ODBC paradigm.
Haven't performed a competitor analysis in 6 years.
Utilities such as Upsert have provided us with significant improvements in the reduction of repetitive code.

Because of bugs/complications with data type conversions (eg. Decimal to Numeric), care must be taken when converting numeric types.

SolarWinds Task Factory Feature Ratings

Connect to traditional data sources
10
Simple transformations
7
Complex transformations
Not Rated

Comments

More Reviews of SolarWinds Task Factory