Possible to Export RTC Data into a Data Warehouse
I'm interested in replacing my organization's SCM's (Synergy & CVS) and Work Item Mgmt tool (Mantis) with RTC.
However, over the past several years we've integrated the work item data in Mantis (via export/import) into several external data warehouses for reporting purposes. These external databases use data imported from several other systems (budgeting, financial, etc.) to produce reports for our Executive Team. I'm concerned that this might pose a problem in the adoption of RTC. Is the data model to RTC published. Is the scheduled export of data from the RTC database something that's available in a supported way? Thanks, Steve |
2 answers
Hi Steve,
I'll let someone on the Work Items team comment on the availability of REST APIs that might let you get the information you need from RTC periodically. I don't think there is any out-of-the-box mechanism to do automatic periodic pushing of data from the RTC repository to an external source. We do have a data warehouse in RTC, and we have scheduled tasks that do the ETL of data from the repository into our data warehouse. This involves writing a (java) service, so we have direct access to the java service APIs for work items (as well as other types of data). If you followed a similar approach and contributed a scheduled task, you could do what you want manually - that is, call the work item APIs like we are in our ETL snapshot, and instead of writing the data to the RTC data warehouse, call whatever APIs you need to store the information in your data warehouse, and let this task get called at specified intervals. Does this sound like what you need? james RTC Reports Team Lead On 6/25/2009 12:07 AM, sviens wrote: I'm interested in replacing my organization's SCM's (Synergy& Comments
Jill Davies
commented Jan 17 '13, 5:18 a.m.
Hi James,
|
Hi Steve, I'm interested in replacing my organization's SCM's (Synergy& Thanks James, It sounds promising. I'll have to take a closer look to be certain. |
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.