It's all about the answers!

Ask a question

What is the best way to access data from Doors 9.6.# for analysis


jay urbanowicz (112) | asked Sep 05 '17, 10:44 p.m.
retagged Jan 02 '18, 6:17 a.m. by Minakshi Jaint (5113)

  We are looking for the best way to accesst Doors data to something like SOLR for Tableau or analysis. We would like something that would also work for Doors Next Generation (DNG).  Is the XML ODBC driver an option,  is there a service that exports ReqIF that can be called, DXL (will DXL work with DNG?), OSLC? Something like Sodius MDAccess that works for 9 and NG.

Any guidance would be appreciated.
Thank you,
Jay

One answer



permanent link
Benjamin Silverman (4.1k69) | answered Sep 20 '17, 6:13 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Hi Jay,

Your best bet for DNG would be OSLC or the reporting API.  DNG does not support DXL nor is there a service that exports ReqIF automatically.  For DOORS, DXL would be your best bet.  Hope it helps,


Comments
jay urbanowicz commented Oct 04 '17, 3:48 p.m.

 Hi Benjamin;

     Thank you, for the answer, that is what I was expecting.
 Do you know anything about the odbc connection mentioned in: Rational Insight

"Defining Rational DOORS as a data source
You can set up the connections for Rational® DOORS® so that you use the XML Data Configuration tool to work with the data configuration files. The XML ODBC driver uses the configuration information to extract data."

I don't see what version of doors this works with. It would be, possibly, an easier task if the driver works with 9.6.
Thanks again,
Jay


Kenji Sarai commented Jan 03 '18, 7:17 p.m.

Hi Jay,

You can obtain doors.xdc from your DWA 9.6.0 server.
https://www.ibm.com/support/knowledgecenter/SSYQBZ_9.6.0/com.ibm.rational.doors.integrating.doc/topics/t_download_xdc_file.html

You usually do not need to customize it in XML Configuration Tool, so register it in unixODBC. Then you will have an ODBC interface with your DWA server. You can do these steps without Rational Insight. Hope it helps. 

Your answer


Register or to post your answer.