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

Database ERD

 Good day,


I would like to find out if there is an ERD (diagram) available for the Jazz Solution (RM, CCM, QM).

We would like to overcome some of the reporting limitations in the current reporting service, and extract data directly from the Database as read only.

Please note that our Jazz environment uses the SQL Server database system.

Thank you.

Alick

0 votes


Accepted answer

Permanent link

I believe this is usually proprietary, and guarded as trade secret. No?

I think you should stick with the supported way of reporting.
https://jazz.net/help-dev/clm/topic/com.ibm.rational.reporting.overview.doc/topics/c_reference_datadictionary.html

Alick Banda selected this answer as the correct answer

0 votes

Comments

  That answers my question. Thank you Donald.

I wouldn't call the database tables proprietary or a trade secret, but they are subject to change on each release, so we strongly recommend not trying to code directly against them because you would have to verify all of that code and possibly recode on every release.  Because of that, the format is not documented, and you would not receive any support if you tried to code against them.

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
× 12,019
× 7,494
× 1,381

Question asked: Mar 15 '18, 9:40 a.m.

Question was seen: 2,649 times

Last updated: Apr 02 '18, 5:45 p.m.

Confirmation Cancel Confirm