[p4] Merging Bug Tracking Tools with Perforce

[sandy at releng.com]

FYI

We have an integration with ClearQuest up and running:

http://www.releng.com/p4cq.html

ClearQuest can be run on top of several different databases, from
oracle to sequal server, etc.

It is currently not based on p4dti, but maybe one day it might
be!

The main difference from p4dti is that it is based solely on
perl (the CQ API is in perl).  It is also tightly integrated into
ClearQuest (though highly configurable) with a lot of work
done with getting the various forms to be user friendly.
It also does not take over the job database, so one can share the
job database with other groups/processes and other integrations.

It also comes with a tightly integrated (configurable)
call tracking piece, which is very cool.

The end result is that it provides such web based queries as:

1) what is the difference (+/-) between these two releases (or codelines
for that matter) in terms of jobs and/or changes.

2) list the releases (or codelines) that contain a fix for this
specific defect/job.

Hopefully, it will be available (under G.P.L. or something
similar) real soon.  Unfortunately, freeware projects tend to go
slow sometimes.

-sandy


Currently, we own Perforce and Onyx (http://www.onyxsoftware.com/).
Onyx is our bug tracking system.
We are currently planning to integrate Onyx and Perforce so that the
following occurs:
- Whenever a successfully created Onyx QA incident is logged, it will
trigger the creation of a Perforce job
- Fields chosen on the QA incident form will update fields chosen on the
Perforce job spec, vica versa
- Internal email in both tools will be leveraged to perform updates to
interested parties in the company

To be more specific ... This project will culminate in the Integration of
ODBC compliant, SQL based Onyx's bug tracking functionality with Perforce,
an SCM tool written in C++ on a Berkeley DB open database. The result will
be a software link between the two tools to streamline Aegis' change control
process.

I would like to know if anyone out there has done this integration before
(Onyx and Perforce).  I am doubting the answer is yes, so my next quesiton
is has anyone connected in this fashion, an SQL based CRM tool to Perforce?


I'm interested in any recommendations, comments, or problems anyone may have
had in doing this type of integration.

Thanks in advance,
Brian

_______________________________________________________