Transferring test execution records from RQM to local database
![](http://jazz.net/_images/myphoto/99827a4511d008229e5d664b038dd4be.jpg)
Hi,
I am executing approximately 1000 test cases manually through RQM. However, we are displaying test case execution results for automated and manual tests through a local webpage by querying a local database server.
Can you please help me, how I can retrieve test case execution records from RQM and copy them into our local database server?
Thanks
2 answers
![](http://jazz.net/_images/myphoto/99827a4511d008229e5d664b038dd4be.jpg)
Hi Sushma,
I don't know how to do, but I know it can be done using Rest API.
https://jazz.net/wiki/bin/view/Main/RqmApi
What do you plan to accomplish by "use RQM database to fetch execution records which can update the tables in my local sql server automatically".
For example, if it is for reporting, there are simpler ways to do it (for example by using rest api and macros or using custom reports in RPE or RRDI or JRS)
I don't know how to do, but I know it can be done using Rest API.
https://jazz.net/wiki/bin/view/Main/RqmApi
What do you plan to accomplish by "use RQM database to fetch execution records which can update the tables in my local sql server automatically".
For example, if it is for reporting, there are simpler ways to do it (for example by using rest api and macros or using custom reports in RPE or RRDI or JRS)
Comments
Sushma Jain
Mar 15 '16, 8:09 a.m.Hi,
Thanks for the response.
I think I will make myself more clear this time.
Please note that I don't want to transfer the execution details from RQM using downloaded excel sheets. Because this would mean that execution details in my local database will not be updated unless I transfer those records using Excel downloads from RQM manually.
If you could please suggest how to use RQM database to fetch execution records which can update the tables in my local sql server automatically possibly whenever new execution records in RQM are available.
Please let me know if I was able to explain it more clearly now.
Thanks & regards,
Sushma