It's all about the answers!

Ask a question

Possible to Export RTC Data into a Data Warehouse


Steve Viens (61185) | asked Jun 25 '09, 12:07 a.m.
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



permanent link
James Moody (3.3k24) | answered Jun 25 '09, 9:21 a.m.
JAZZ DEVELOPER
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&
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

Comments
Jill Davies commented Jan 17 '13, 5:18 a.m.

Hi James,
Could you comment on the possibility of using the REST APIs and Java to write additional data to new tables in the existing Jazz DW?  We have a customer who is interested in viewing the TimeSheet Entry data from RTC using RRDI but this data is not currently stored in the DW.

We have proposed a solution involving Insight with a separate DW, but they are not keen on this at the moment.

Thanks,
Jill


permanent link
Steve Viens (61185) | answered Jun 25 '09, 2:05 p.m.
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&
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


Thanks James, It sounds promising. I'll have to take a closer look to be certain.

Your answer


Register or to post 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.