It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,952

question asked: Apr 26 '12, 11:01 a.m.
question was seen: 3,841 times
last updated: Apr 26 '12, 11:01 a.m.

Related questions

RQM Data Storage

0
Bharat Patel (81●12●39●43) | asked Apr 26 '12, 11:01 a.m.
Hi,

Can you please let me know how RQM data (Project Area, Test Plan, Test Case, Test Script etc.) is saved in Derby Database and Oracle Database? Is it in Metdata Format? Request to share more details pls.

Thanks
Bharat

4 answers

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Patrick Van Zandt (1.2k●1) | answered May 17 '12, 8:15 p.m.
JAZZ DEVELOPER
As Paul mentioned previously, the tables are proprietary.

While it is certainly possible to access the artifacts via an database query, this is not documented (or supported) by IBM. The table schema is not stable between releases so any queries that work in version n will very likely not work in version n+1 or n-1.

The recommended method for accessing data programatically is the use the Reportable REST API provided by RQM.

Cheers,
Patrick
0
permanent link
Paul Slauenwhite (8.4k●1●2) | answered Apr 30 '12, 6:55 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
RQM test resources are stored in the repository database, configured during install/setup. The tables are proprietary. However, you can access RQM test resources using the RQM Reportable REST API:

http://jazz.net/wiki/bin/view/Main/RqmApi
0
permanent link
Bharat Patel (81●12●39●43) | answered May 17 '12, 10:54 a.m.
RQM test resources are stored in the repository database, configured during install/setup. The tables are proprietary. However, you can access RQM test resources using the RQM Reportable REST API:

http://jazz.net/wiki/bin/view/Main/RqmApi


Thanks Paul.

So Does that mean, Test Artifacts i.e.which we are going to create in RQM like Unit Test Plan, System Test Plan , Test Cases, Test Scripts (including Test Steps) is going to store in Oracle Database? If so can i access the these Test Artifacts from oracle Databse by firing Select Query ? or can i view the test artifacts in Oracle database?
0
permanent link
Paul Slauenwhite (8.4k●1●2) | answered May 17 '12, 1:52 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
Yes, they stored in the Oracle DB. RQM recommends not accessing the DB directly, but rather through the RQM Reportable REST (http://jazz.net/wiki/bin/view/Main/RqmApi) and/or OSLC QM (http://open-services.net/bin/view/Main/QmSpecificationV2) APIs

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.