11-25-2011 05:40 PM
I am a beginner for QC 10.0,Please advise.
I understood that for generating reports and troubleshooting in QC( Quality Center ) we can use SQL queries from backend of the QC 10.0.
Please guide me through any any tutorial websites,cookbook's or workbook's which will explain how to write queries for different scenarios on the QC 10.0.
I have downloaded the Database reference guide from the quality center,but I want to know when to use and how to use these tables and how to query these tables for getting the desired output.
I did Google search, but could not find any helpful tutorial sites.
Please guide me to the correct forum if this question is not appropriate here.
11-26-2011 12:17 AM
Thanks for your advice.
I am not sure about which demo CD you are specifying.
I am using QC that was aleady installed from the corporate office.
Alternatively planning to download the software from http://www8.hp.com/us/en/software/software-product
BTW which Demo CD are you referring to?
Can you please point me to that,also can you please tell me how to establish connection between QC and SQL server?
11-26-2011 02:46 AM
If you wan to install Quality Center, you will either download an ISO file from HP's support site or you have an installation dvd containing the sources.
In the installation sources, a folder "DemoProject" can be found. This folder contains a qcp file which can be imported into Quality Center via site administration. Database type does not matter for this import.
On the Dashboard module select Analysis view. In this View, some sample excel reports were created for querying the database.
11-26-2011 11:23 AM
Thanks a lot.
I donot have the QC DVD.
I will download the software from http://www8.hp.com/us/en/software/software-product
11-29-2011 11:25 AM
Since you are using QC 10.0 for using sql's you can navigate to Dashboard module in QC project and create an excel report and then go to query builder.In here you can see the entities pane on to the right side which basically lists all the tables available in that project.Since you have the db reference guide you can check the modules to see how the relation ship is maintained.
Also you can navigate to qc help-->doc library -->QC user guide-->refer to Dashboard module.