Pragmatic Workbench (discontinued) vs. SolarWinds Task Factory

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Pragmatic Workbench (discontinued)
Score 8.5 out of 10
Enterprise companies (1,001+ employees)
Pragmatic Workbench Enterprise was a suite that combined four Pragmatic Works products: BI xPress, DBA xPress, DOC xPress and LegiTest. It was acquired by SentryOne in April 2018, and has reached its EOL phase. After the summer of 2022 it will likely no longer be available, and unsupported.
$2,490
per seat
SolarWinds Task Factory
Score 8.2 out of 10
N/A
According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been optimized to ensure fast performance of data-centric applications, and the user can run Task Factory…N/A
Pricing
Pragmatic Workbench (discontinued)SolarWinds Task Factory
Editions & Modules
Workbench Client Edition
2,490
per seat
Workbench Server Edition
8,995
per server
Workbench Enterprise Edition (Client + Server)
9,995
1 user / 1 server
Task Factory
1,245 (annual subscription license)
per server
Task Factory Azure Data Factory
1,495 (annual subscription license)
per ADF node
Offerings
Pricing Offerings
Pragmatic Workbench (discontinued)SolarWinds Task Factory
Free Trial
YesYes
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsWorkbench Enterprise combines all of the functionality within Workbench Client (local install) and Workbench Server (server install).
More Pricing Information
Community Pulse
Pragmatic Workbench (discontinued)SolarWinds Task Factory
Top Pros
Top Cons
Features
Pragmatic Workbench (discontinued)SolarWinds Task Factory
Database Development
Comparison of Database Development features of Product A and Product B
Pragmatic Workbench (discontinued)
9.0
1 Ratings
4% above category average
SolarWinds Task Factory
-
Ratings
Test data generation9.01 Ratings00 Ratings
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Pragmatic Workbench (discontinued)
-
Ratings
SolarWinds Task Factory
9.4
40 Ratings
12% above category average
Connect to traditional data sources00 Ratings9.440 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Pragmatic Workbench (discontinued)
-
Ratings
SolarWinds Task Factory
9.1
39 Ratings
10% above category average
Simple transformations00 Ratings8.739 Ratings
Complex transformations00 Ratings9.635 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Pragmatic Workbench (discontinued)
-
Ratings
SolarWinds Task Factory
9.4
3 Ratings
12% above category average
Integration with data quality tools00 Ratings9.22 Ratings
Integration with MDM tools00 Ratings9.63 Ratings
Best Alternatives
Pragmatic Workbench (discontinued)SolarWinds Task Factory
Small Businesses
DBeaver
DBeaver
Score 8.4 out of 10
Skyvia
Skyvia
Score 9.7 out of 10
Medium-sized Companies
DBeaver
DBeaver
Score 8.4 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
Enterprises
DBeaver
DBeaver
Score 8.4 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Pragmatic Workbench (discontinued)SolarWinds Task Factory
Likelihood to Recommend
8.0
(1 ratings)
8.1
(40 ratings)
Likelihood to Renew
-
(0 ratings)
8.2
(3 ratings)
Usability
-
(0 ratings)
9.1
(1 ratings)
Support Rating
6.0
(1 ratings)
9.1
(1 ratings)
Implementation Rating
-
(0 ratings)
8.2
(1 ratings)
User Testimonials
Pragmatic Workbench (discontinued)SolarWinds Task Factory
Likelihood to Recommend
Discontinued Products
Workbench Enterprise is consistent across devices and users so far. It works the same, and access is easy. I have a problem with its security. If you use an enterprise password to access databases, it's very easy to click the show password on the connection page and expose the enterprise password. You shouldn't allow users to use the same accounts to access the database because that means all users are sharing the same password.
Read full review
SolarWinds
Since I started working with this great tool all data analysis programs have been running effectively. Implementation of projects and tasks have been effective and reliable. Data collected from each department gives us working plan on better management of various programs. The Dimension Merge SCD Transform helps us to load large volumes of data within a short period of time.
Read full review
Pros
Discontinued Products
  • Querying is easy and quick.
  • Updating tables is very easy.
  • It gives us very accurate error messages.
Read full review
SolarWinds
  • The single most beneficial component to Task Factory is the Upsert component. If you're familiar with writing MERGE statements in T-SQL, you'll appreciate the Upsert component. Drag the component into your Data Flow and a few clicks later you have a MERGE without the code complexities.
  • Where some native SSIS components leave you wanting more, Task Factory extends on many of these components as well as support for data sources not native to SSIS components.
  • The number of extra components that come in the Task Factory tool kit will expand your tool belt to do just about anything you need or want to accomplish in SSIS.
Read full review
Cons
Discontinued Products
  • It has autocompleted, but I find it difficult to use or get to use.
  • It doesn't automatically complete table names or field names.
Read full review
SolarWinds
  • It was built by Pragmatic Works who sold it to SentryOne and now Solar Winds, concerned about future support. SolarWinds is discontinuing support for related products such as BiXpress.
  • Had issues with connecting to certain versions of SQL Server - would fail when deploying one package - had to deploy the entire solutions.
  • Occasional random failures observed with the Filter tranform.
Read full review
Likelihood to Renew
Discontinued Products
No answers on this topic
SolarWinds
Task Factory has become a key product for our use of doing ETL work in SSIS. Their custom SSIS components allow us to work simply on the data engineering side of things. We can ignore the lower level work needed to connect to disparate data sources. This allows us to work faster and provide more value to the business
Read full review
Usability
Discontinued Products
No answers on this topic
SolarWinds
Compared to some of the other transformations I have worked with, it really is pretty simple for the type of functionality you get
Read full review
Support Rating
Discontinued Products
Our team does the support for us. Sometimes we see download related issues that can easily be fixed by our team. Most issues you will see with one user in your org will probably happen to others, so keep a log and track those issues. Then have a fix for them somewhere that everyone has access to. This will save you a lot of time troubleshooting.
Read full review
SolarWinds
Overall, the best vendor we currently have on the data side of the house. No issues, issues are resolved very quickly and upgrades go without any issues.
Read full review
Implementation Rating
Discontinued Products
No answers on this topic
SolarWinds
Overall it went smoothly. Had a couple of gotchas with licensing and upgrading but nothing that really stopped us.
Read full review
Alternatives Considered
Discontinued Products
No answers on this topic
SolarWinds
ZappySys is an alternative provider that we tested. However, we found the ease of use, set up and installation to be much simplier and quicker using Task Factory. ZappySys has a number of the same connectors but are more difficult to setup and the GUI is not as intuitive and simple to use.
Read full review
Return on Investment
Discontinued Products
  • I personally like Workbench Enterprise, and I can do everything I need to do using it.
Read full review
SolarWinds
  • We were able to support our developers with Task Factory features and reduce the development time by 40%.
  • Recently Task Factory has changed their pricing module and it seems to be pretty costly for our process. Our business team has started to evaluate whether this is worth it going forward.
Read full review
ScreenShots

Pragmatic Workbench (discontinued) Screenshots

Screenshot of Real-Time SSIS Execution DiagramScreenshot of Visual Object LineageScreenshot of Data Validation Testing DesignerScreenshot of Data Validation Testing -  Performance DashboardScreenshot of Workbench Launch Dashboard

SolarWinds Task Factory Screenshots

Screenshot of Salesforce.com SourceScreenshot of Dimension Merge SCD TransformScreenshot of Upsert DestinationScreenshot of REST Source