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
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'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
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
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.