I am working on a Database Synchronization of
Quality center 8.2SP1 with a third party's issue tracking tool(works like a PVCS) . The company wants to pull up the same defect ID (Issue tracking) in Quality center. The client would never be using QC to add any new defects to their existing database.So thats why i am calling it a Database Syncro rather tahn an integration. Now i made a .vbs outside the Quality center which run as an executioner and maps their issue ID with DefectID of QC . It also maps a lot of info like status and desription.
One of my concerns is whether if i add the code inside QC's(defect_Afterbug_post). Will the QC work .In other words whnever someone opens QC it just updates the database with VBscript running
It is assumed that workflow of QC is too defined . Or is it a good idea to follow the OTA guide to make a TestType class playing with DLL's and test_type.ini.
I am attatching part of .vbs
Set con = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
Set rs1 = CreateObject("ADODB.Recordset")
rs.Open "Select * from Issues where issuesid=18848", con
'issues is the databse name