Save Results of Tests Into a SQL Server
Users of CAT frequently requested possibility to save results of tests in a MS SQL server table. Though it was possible with some post-processing steps (e.g. process JSON output), it was far from easy. Now it is far from difficult :-)
Output: - Database: MyDWH # name of an existing data source you already have Table: CAT.TestResult # name of the table
If CAT has enough permissions, it will even create the table for you. Or grab the script from the documentation link below and prepare the table.
CAT is highly configurable, feel free to name the table according to your naming conventions.
Only SQL server is supported, but ORACLE and PostgreSQL support will come soon.
CAT saves the result after each test execution finishes, so if the process is killed in the middle, you’ll have at least some results. The feature also works when you execute tests in multiple threads - each thread has its own connection for saving results.
See Full Documentation.
That’s it :-). Happy testing.