The requirement here is to store the server data collected during the tests by Silk Performer Monitors directly to a database running on SQL server.
However as saving the monitored data directly in the DB is not supported in any of the existing versions of Silk Performer, we would need to do this in the following manner where the difficult part being that the entire process needs to be automated.
1. Export the server data to a raw CSV file format.
2. Parse only a few metrics w.r.t server data from the csv file along with the load test id from the file
3. Connect to the database & store the parsed values to a table in the database.
Have anyone worked on such a scenario. Any help/thought is greatly appreciated.