Is it possible to reach the oracle DB?
![]()
Ziv Rechnitser (9●1●16●18)
| asked Apr 10 '13, 7:17 a.m.
retagged Apr 10 '13, 7:57 a.m. by Krzysztof Kaźmierczyk (7.5k●4●80●103)
Hi All,
In our organization we use Oracle DB.
Is it possible to reach from the oracle GUI to the RTC ccm&jts tables in the DB schemas?
We want to export WIs list to Excel file from different ProjectsArea.
Thanks,
Ziv
|
Accepted answer
![]()
@Ziv accessing the WI's directly from database is not possible. The WI data and history etc are stored in a Blob column as a gzipped xml.
The best way would be to use the export a WI query as a csv and open in excel. If you have defined the same query with output fields in the 2 PA's you can append 1 excel to the cells of the other. Ziv Rechnitser selected this answer as the correct answer
|
One other answer
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.