Tell me more ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.
up vote 0 down vote favorite

I am a fresher in Quality Center 10.0 HP software testing tool.

As per my understanding in order to generate reports from QC and to troubleshoot the scenarios, we need to write SQL queries in the QC back end database. In my case it is SQL db.

I downloaded the database reference help file but I could not understand from where I can start.

It just gave the table name and its information.

For a starter like me are there any online tutorials or helpful websites, hands on exercises, scenario's where I can better understand how to write queries for the QC data model? I am very confident about the SQL coding itself, what I want to know is how to query on the QC database tables based on the scenarios that occur in QC tool.

share|improve this question
Usually products like this come with sample queries. You need to look at the ERD and have a certain query in mind then try to find the tables that would satisfy your query and see how they are related on the ERD. Also, such products usually come with several built-in reports that should cover basic needs. – Emmad Kareem Nov 27 '11 at 17:45
Thanks Emmad , will dig into details. – srihari Nov 27 '11 at 19:05

closed as off topic by maple_shaft♦ Jun 25 '12 at 11:06

Questions on Programmers Stack Exchange are expected to relate to software development within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

1 Answer

up vote 0 down vote

Start with the Primary table you will be querying and look to see i the data you need is there, if not look for related tables... repeat.

Start to create an ERD for your self.

You can get data to show on the UI that you are looking for and have a Profiler running in the background (monitoring the DB) so you can see where\how the UI got the data.

The HP forums claim you can Download the ERD..

http://h30499.www3.hp.com/t5/ITRC-Quality-Center-Forum/Where-amp-What-is-the-HP-Quality-Center-Data-Model/td-p/5185540

share|improve this answer
Hi Morons, Thanks for your response. I have a doubt over this statement "You can get data to show on the UI that you are looking for and have a Profiler running in the background (monitoring the DB) so you can see where\how the UI got the data." Can you please explain me how this is done or link me up to the corresponding references. – srihari Nov 28 '11 at 2:22
use a profiler tool that Monitors all query sent to the db. Sql server for example comes with "sql profiler" (google that ) then find the eqivilent for what ever qc uses as its db. – Morons Nov 28 '11 at 2:35
Morons many thanks i will try this ,thanks a lot for explaining. – srihari Nov 28 '11 at 2:58

Not the answer you're looking for? Browse other questions tagged or ask your own question.