A large group uses Workbench Enterprise, from super users to end-users. It makes it very easy for our teams across functions to access the database directly and view changes when tableau refreshes could be delayed or scheduled at a later time. It makes it easy for super users to make changes and updates, as well. It is a lot faster than most software we used in the past.

Pros and Cons

Querying is easy and quick.
Updating tables is very easy.
It gives us very accurate error messages.

It has autocompleted, but I find it difficult to use or get to use.
It doesn't automatically complete table names or field names.

Likelihood to Recommend

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.

Support Rating

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.

SentryOne Pragmatic Workbench Scorecard Summary

Likelihood to Recommend (1): 80%
8.0
Support Rating (2): 60%
6.0

Feature Scorecard Summary

Database Development (1): 90%
9.0

What is SentryOne Pragmatic Workbench?

Pragmatic Workbench Enterprise is a suite that combines four Pragmatic Works products: BI xPress, DBA xPress, DOC xPress and LegiTest. It was acquired by SentryOne in April 2018.

According to the vendor, key Features Include:

Validate Data Results

Continuously validate data results across all systems including databases, applications and web services.

Auditing, Monitoring, and Notifications for SSIS

Apply enterprise auditing frameworks to SSIS for real-time monitoring and historical performance trend analysis.

Document & Identify Object Lineage and Impact

Instantly document SQL Server, SSIS, SSAS, SSRS, Excel and Oracle and discover object lineage dependencies to understand how changes may impact the rest of the environment.

SentryOne Pragmatic Workbench Features

Show Unsupported Features

Database Development Features

Supported: Test data generation

Additional Features

Supported: Continuously Validate Data Through Automated Testing
Supported: Apply Enterprise Auditing Frameworks to SSIS for Real-Time Monitoring & Notifications
Supported: Document SQL Server, SSIS, SSAS, SSRS, Excel, Oracle, and Tableau Server
Supported: View Object Lineage Dependencies
Supported: Setup & Deploy an Enterprise Data Dictionary

SentryOne Pragmatic Workbench Screenshots

Data Validation Testing - Performance Dashboard

SentryOne Pragmatic Workbench Downloadables

Workbench Enterprise Data Sheet

SentryOne Pragmatic Workbench Integrations

Microsoft SQL Server
Tableau Server
Oracle Database (legacy)

SentryOne Pragmatic Workbench Competitors

Microsoft SQL Server
SQL Power Doc
ApexSQL Doc

SentryOne Pragmatic Workbench Pricing

More Pricing Information

On-premise Editions Pricing
	Pricing Details	Terms
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

SentryOne Pragmatic Workbench Customer Size Distribution

Consumers	0%
Small Businesses (1-50 employees)	0%
Mid-Size Companies (51-500 employees)	25%
Enterprises (more than 500 employees)	75%

SentryOne Pragmatic Workbench Technical Details

Deployment Types	On-premise
Operating Systems	Windows
Mobile Application	No
Supported Languages	English