Database Schema for RTC
Hi, I am a CAS student and working on application of metrics for agile development. Actually, I want to create a database of metrics so that I would be able to perform various analysis using queries on that data. I have heard that database schema for RTC is publicly available but I am unable to locate that on this website. Therefore, I request if someone could tell me where to find this then it would be a great help.
Thanks, Zeeshan |
7 answers
|
Hi, I am a CAS student and working on application of metrics for agile development. Actually, I want to create a database of metrics so that I would be able to perform various analysis using queries on that data. I have heard that database schema for RTC is publicly available but I am unable to locate that on this website. Therefore, I request if someone could tell me where to find this then it would be a great help. Hi Zeeshan, I'll quote an earlier response to this question by Annie Ying: I was asked by several people independently about where they can find the schema of the Jazz repository for mining purposes, so I just thought to share this information with everybody. |
Hi tklinger,
Is it possible to connect to the database used to develop the team concert itself? I know we can browse through the web-based interface (https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=jazz.viewPage&id=com.ibm.team.dashboard), but I couldnt find any information to access the database directly. The reason for that is as a large scale project, it already has many interesting data. |
Hello, can anyone help me?
Hi tklinger, |
the simple answer is: no.
You can however if you got a dump by IBM Research set this one up and work on the data contained in the dump. |
The data is also made available to IBM Jazz Innovation Award winners:
http://www.ibm.com/developerworks/university/innovation/jazz.html |
As first step you need for database connection the Code: Select all value="Demo Database NAV (6-0)" to something like Code: Select all value="MyNewDatabase" - the database name you have used when creating the DB within NAV Classic client. You need to copy the file back "As Administrator" (if you are using explorer to copy the file, it will ask you if you want to do that as admin). After that, you need to go into Control Panel - Administration tools - Services (or just search for services in start menu), find the correct service there (e.g. something like "Microsoft Dynamics NAV Server") and restart it. Look into event log, that there are no errors or warnings in the application log connected to this restarted service. If not, you can try to open RTC again at it should connect to correct DB.
|
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.