SQL query to a database
Can iTest do a SQL query to a database? I am thinking how to maximally use the response analysis tool to process all kinds of test results formats
We already have a working prototype of a new iTest plug-in application for performing SQL queries to databases. This would let you easily integrate database select/insert/update/etc. queries into the middle of your test case. It provides "blue box" analysis on the corresponding results. And it supports prepared statements so that you can easily integrate it with iTest variables and other substitutions in the queries. This could support data-driven test automation. And it could help with publishing extracted performance data, for example, directly into a database. It might also be helpful for testing EMS/NMS-type applications that have a database back-end.
We're not sure how much value this has for our customers. I encourage anyone who may be interested in this capability to post and let us know that you are interested. This will help us decide how to prioritize this for inclusion in the product.
This is an excellent feature I am looking for. iTest Response Analysis is a powerful tool. I want to maximally use the tool. One of use cases is to use the feature to analyze test results if the test results are stored in database such as results from Spirent TestCenter. As you said, other use cases could be to test database directly using iTest.
