Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

HP ALM/QC dashborad

Hi All,

Do any body created test management dashboard using HP ALM/QC as source with all tables like , Test, defect, requirement etc.

Could you please share the data model for the same.

what are the relationship between test cases, test ID , defect id and req ID .

Any help will be appreciated.

Thanks in advance

BKC

2 Replies
Anonymous
Not applicable
Author

Can anybody plz reply .

shayraber
Creator
Creator

I have one for the HP QC but its confidential and I'm not allowed to take it out of the organization.

What I can give you is website with all tables and the connections between them

check this:

http://systemmanager.ru/322224.en/quality%20center%20database_db.html

the main table that will interest you are:

Capture2.PNG

where:

REL_ID=RCYC_PARENT_ID

RCYC_ID=RQC_CYCLE_ID

RQC_REQ_ID=RQ_REQ_ID=RC_REQ_ID

RC_ENTITY_ID(if RC_ENTITY_TYPE='TEST')=TS_TEST_ID

TS_TEST_ID=RN_TEST_ID

RN_RUN_ID=ST_RUN_ID

ST_TEST_ID=TS_TEST_ID

hope that helps you