Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RQM Data Storage

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

0 votes



4 answers

Permanent link
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

1 vote


Permanent link
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 votes


Permanent link
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 votes


Permanent link
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

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Apr 26 '12, 11:01 a.m.

Question was seen: 4,123 times

Last updated: Apr 26 '12, 11:01 a.m.

Confirmation Cancel Confirm