Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic SYNERGY (steve huntington)
Decrease font size
Increase font size
Topic Title: ODBC connection? ccm query syntax?
Topic Summary: Is there an odbc connection to Synergy/Change?
Created On: 6-Jul-2006 16:47
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 6-Jul-2006 16:47
User is offline View Users Profile Print this message


Robert Poldervaart

Posts: 5
Joined: 7-Jun-2006

I'd like to get some data out of Synergy/Change to combine with data from other tools to produce some charts/graphs/metrics.  I found the csapi perl api, but am having some problems which I think are related to timing out on large queries. 

I was wondering if there is an ODBC driver that will work with Synergy/Change so I can get the data directly into excel, and eventually in some web based charts and graphs.

I'm also looking at other more multi-step approaches like the perl script, but that seems to be having problems timing out on large queries.  It looks like there is something called "ccm query", but I cannot find any documentation on syntax and examples.  If someone can point me to the documentation on this, I would appreciate it.

Thanks,
Robert
Report this to a Moderator Report this to a Moderator
 7-Jul-2006 22:15
User is offline View Users Profile Print this message


Charles Murphy

Posts: 5
Joined: 31-Jan-2005

"ccm query" is the command for the Synergy/CM command line, so check the Synergy/CM documentation.  The help files have a reference for the command syntax, and there's also a section called "Create a Query Expression" that has some good examples of how to create more complex queries.

-Julie Lee
Report this to a Moderator Report this to a Moderator
 7-Jul-2006 23:11
User is offline View Users Profile Print this message


Robert Poldervaart

Posts: 5
Joined: 7-Jun-2006

Thanks Julie. I finally found it thanks to your post. I've been looking this entire time under the Synergy/Change documentation. Your pointer to the Synergy/CM documentation helped me find the command line document. The contents are what I've been looking for. Hopefully with this, I can do a multi-step approach with ccm query getting my data out, and then another program picking the data up for manipulation with outside data and present the results. Thanks again, Robert
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic SYNERGY forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 15:34.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.