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

Database ERD

Questions
Tags
Users
Badges
Alick Banda
(43●7●18) retagged
Mar 16 '18, 1:58 p.m.

 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

1 answer
5,104 views
0 votes

Accepted answer

Permanent link
Donald Nong
(14.5k●6●14) Mar 15 '18, 10:49 p.m.

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
Alick Banda
Mar 16 '18, 2:15 a.m.
  That answers my question. Thank you Donald.

Geoffrey Clemm
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Apr 02 '18, 5:45 p.m.
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.

Ask a question
Guidelines
FAQ
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,144
× 7,622
× 1,381

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

Question was seen: 5,104 times

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

Confirmation Cancel Confirm