Data access via API/Command Line
We've just moved from T-Plan to TD8 here at VM and I need to get access to the defect data to import into our Build and Release Database. In the past I have simply connected directly to the TD database for this kind of stuff but the way we have our networks set up here it is unlikely Iím going to get this access. To work around the problem I'm hoping I might be able to access the data via the API or command line. Iíve downloaded the docs on the OTAClient 75.dll but donít really know where to begin.
All I need to do is automatically create a list of defects with specific criteria, is there a simple way to do this without getting access directly to the DB?
Re: Data access via API/Command Line
You can do this with the API. Look at the TDConnection.Command property. It allows you to specify a SQL statement and execute it to get a result set. The API documentation will cover all the details and provide sample code.