LegiTest Demonstration

about 2 years agoJune 29, 2016
Can you please file an enhancement to unselect all SSIS packages by default? I have around a thousand packages, would be nice to opt in rather than opt 1000 packages out.  Thanks! and GRRRRR ;)
Liz Hamilton
about 2 years agoJune 30, 2016
Hi Jennifer! Thanks for reaching out. This is something our DEV team is currently working on. I don't have an ETA at this time but please feel free to contact support@pragmaticworks.com with any additional questions or concerns.
almost 2 years agoOctober 6, 2016
How to set environment configuration value for SSIS package to run on any server? PROD, QA, DEV etc...
Liz Hamilton
almost 2 years agoOctober 10, 2016
Here's a tutorial that we have in our help documentation: 


Through the use of parameters, customers can easily transition between multiple environments as the testing process flows through the various stages of development and deployment.

Please let me know if you have any other questions!
Gangasagar Kotha
over 1 year agoNovember 4, 2016
Hi, I have multiple SSAS cubes that i wanted to prepare regression suite against their data ware houses. Do we need to write SQL queries from data ware house to compare each measure or tool will write on its own?

Also can we compare the data in SQL database with Oracle database?
Liz Hamilton
over 1 year agoNovember 4, 2016
We have an SSAS Validation Testing Wizard, which will write most of the code for you. The only 'real code' that you would have to manually write is for correcting validation errors. You can learn more here: http://help.pragmaticworks.com/LegiTest/Index.html?SSASValidationTesting.html 

Also, you can compare data from a SQL DB to an Oracle DB. 

Please email support@pragmaticworks.com with additional questions. 

over 1 year agoFebruary 8, 2017
Hi , I have a SQL query which gives source and destination data. I want to get the difference between the columns ( if any ) and also can i send out an email to users from the tool, if there's any difference in the data( as mentioned above)?
Liz Hamilton
over 1 year agoFebruary 8, 2017
It sounds like you are looking for the Comparison Editor, which can be used with a SQL query for the source data, and another SQL query for the destination data, and compare the two using a compare grid test element. As far as sending out emails to people, that would include using our Notification Engine which is part of the LegiTest Server product and can be set up to send emails when tests are run.

Go to the “Using the Comparison Editor” video on http://www.legitest.com/resources/legitest-how-to/.

Please email support@pragmaticworks.com with further questions. Thanks!
12 months agoAugust 3, 2017
Do you have a demo for SSRS? I'm not to sure how to use the "Validate a value in the report XML" checkbox, what columns or items can I validate and what syntax is there a specific syntax on how to provide the values on the Path: field
Natasha Guenther
12 months agoAugust 7, 2017
Hi Jose! The XPath Extract is used to extract information from the report-here is a link to our help documentation on that: http://help.pragmaticworks.com/LegiTest/Index.html?XPathExtract.html. The syntax being used is specific to the XPath language, which there are many tutorials online that delve into XPath further(https://www.w3schools.com/xml/xpath_intro.asp). I hope this information is helpful! If you have further questions please let us know.
9 months agoNovember 8, 2017
Can you please explain how to setup the server to get results?
Liz Hamilton
8 months agoNovember 9, 2017
Hi Prasanna,

Please visit support.pragmaticworks.com where you can find many resources to get your question answered. Thanks so much!
Your comment