Pragmatic Works

LegiTest

5 / 5 3 reviews

Who Uses This Software?

BI Developers, Data Analysts or anyone looking to correct bad data.


Average Ratings

3 Reviews
  • 5 / 5
    Overall
  • 5 / 5
    Ease of Use
  • 5 / 5
    Customer Service

Product Details

  • Starting Price
    $895.00/user
  • Free Trial
    Yes
  • Deployment
    Cloud, SaaS, Web
    Installed - Windows
  • Training
    Documentation
    Webinars
  • Support
    Online
    Business Hours

Vendor Details

  • Pragmatic Works
  • pragmaticworks.com
  • Founded 2007
  • United States

About LegiTest

LegiTest is a comprehensive automated data testing framework that allows you to test all your data-centric applications, in an easy-to-use platform. Automated data testing helps stop bad data by validating your results from development to production giving you confidence in your reports.


LegiTest Features

  • Hierarchical View
  • Move & Copy
  • Parameterized Testing
  • Requirements-Based Testing
  • Security Testing
  • Supports Parallel Execution
  • Test Script Reviews
  • Unicode Compliance

LegiTest Reviews Recently Reviewed!


LegiTest has become an invaluable tool for end to end testing of our data warehouse

Jan 30, 2018
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: We have been using LegiTest as part of our end to end data warehouse load for over a year.
LegiTest works for non-coders
LegiTest gives our team confidence in the data going into production
In addition to having confidence in our data, we have saved time and money by catching errors in development and development rework is now at a minimum ¿ generally re-work now consists of bad data, not bad code.
Pragmatic works provides great customer support and the sales representative (Steve Schofield) ensured that the presentations to our company were for our company, not canned power point presentations. I can always count on Steve to be at the other end of the phone if I need information. Over all, Pragmatic Works is a great vendor and a joy to work with.

Cons: We have written hundreds of tests and I would like to be able to sort them alphabetically so that I can quickly find a failed test and determine if it is the data or my test that is at fault.

Overall: We have saved time and money by catching errors in development. We have confidence in our production data. All members of the team can contribute to writing tests.

Capterra-loader

Great tool for testing data systems. esp, SQL Server Reporting, Analysis & Integration Services

Jan 25, 2018
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: Low Technical Barrier to entry: Non-Coders & Subject Matter Experts can use a UI to generate strong tests for all sorts of data systems. Especially powerful for Microsoft SQL Server components like SSAS, SSIS, & SSRS, as there are wizards these systems.

Test capability: This is the only tool I've seen that can test SQL Reporting Services Reports. It also works with any data system you can connect to, OLEDB, ODBC, ADO Flat files etc.

Integration: It generates tests in MSTest or NUnit format. So works with our existing testing framework. It works well with CI/CD systems like VSTS & OctopusDeploy.

Support: These guys are actively enhancing it. Every 3 months its capability improves. They listen to your suggestions & deliver on them.

It has a well thought out hierarchy, with Tests Suites, Test Group actions as a container for Tests.

We've been using it on a very large enterprise data warehouse system.

Cons: Some UI actions need to be repeated for each test.
I like to automate everything, so I'd love the ability to use a custom templates or some API, Powershell where we have many instances of similar tests.
Ironically that may be counter productive, as it is the simplicity of the UI that makes it so easy for the less technical users to learn & be productive quickly.

Overall: None so far.
I'd prefer the ability to edit my Profile.
As consultant my customers change from massive to the Medium enterprise. I do not put that in my Linked in profile, especially as I may work on 2 or more simultaneously.
In each business, they may give me a different title, each relevant to the deliverable. ie: Chief Architect in one project, Security Auditor in another.

Those facts may be more relevant to the review than the size of my consulting company. Which is tiny.

Capterra-loader

Invaluable tool for true test driven development with SSIS

Jan 24, 2018
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Legitest is easy to learn and use by devs and has integrated nicely into our VSTS deployment pipeline.

Cons: A few quirks here and there. Would nice if it was compatible with Test Impact Analysis. Multiple people working on one test suite can be tricky as merges aren't really possible.

Overall: Allowed us to use test driven development for SSIS