Reporting across multiple data warehouses
hi,
due to our historical deployment of RTC we will have multiple "silo" deployments of RTC, a new RRC deployment and shortly RQM. Each will be supported by a JTS, and therefore a DWH (data warehouse).
I have limited understanding of insight, but it seems to me that having independant DWH is going to limit or complicate our reporting capacity, especailly generating consolidated reports across the lifecycle, requirements to change to tests.
So, what we would be looking for is a mechanism to generate consolidate reports which extract data from RRC,RTC and RQM, across multiple projects.
Does Insight facilitate this? I understand that it allows multiple datasets (similar to RPE), which I assume can then be joined to formulate a more detailed report.
Are there any caveats or issues that we should be aware of with our topology (which currently cannot be changed)....
due to our historical deployment of RTC we will have multiple "silo" deployments of RTC, a new RRC deployment and shortly RQM. Each will be supported by a JTS, and therefore a DWH (data warehouse).
I have limited understanding of insight, but it seems to me that having independant DWH is going to limit or complicate our reporting capacity, especailly generating consolidated reports across the lifecycle, requirements to change to tests.
So, what we would be looking for is a mechanism to generate consolidate reports which extract data from RRC,RTC and RQM, across multiple projects.
Does Insight facilitate this? I understand that it allows multiple datasets (similar to RPE), which I assume can then be joined to formulate a more detailed report.
Are there any caveats or issues that we should be aware of with our topology (which currently cannot be changed)....
3 answers
hi,
due to our historical deployment of RTC we will have multiple "silo" deployments of RTC, a new RRC deployment and shortly RQM. Each will be supported by a JTS, and therefore a DWH (data warehouse).
I have limited understanding of insight, but it seems to me that having independant DWH is going to limit or complicate our reporting capacity, especailly generating consolidated reports across the lifecycle, requirements to change to tests.
So, what we would be looking for is a mechanism to generate consolidate reports which extract data from RRC,RTC and RQM, across multiple projects.
Does Insight facilitate this? I understand that it allows multiple datasets (similar to RPE), which I assume can then be joined to formulate a more detailed report.
Are there any caveats or issues that we should be aware of with our topology (which currently cannot be changed)....
Hi
Rational Insight is deliberately designed to use an independent data warehouse. This way data can be ETL'd (extract, transform and load) from the various products into the Insight data warehouse so that reports can be generated which cross many products and provide linkage between the domains that you mentioned. Insight seems to fit your requirements very well.
hi,
due to our historical deployment of RTC we will have multiple "silo" deployments of RTC, a new RRC deployment and shortly RQM. Each will be supported by a JTS, and therefore a DWH (data warehouse).
I have limited understanding of insight, but it seems to me that having independant DWH is going to limit or complicate our reporting capacity, especailly generating consolidated reports across the lifecycle, requirements to change to tests.
So, what we would be looking for is a mechanism to generate consolidate reports which extract data from RRC,RTC and RQM, across multiple projects.
Does Insight facilitate this? I understand that it allows multiple datasets (similar to RPE), which I assume can then be joined to formulate a more detailed report.
Are there any caveats or issues that we should be aware of with our topology (which currently cannot be changed)....
Hi
Rational Insight is deliberately designed to use an independent data warehouse. This way data can be ETL'd (extract, transform and load) from the various products into the Insight data warehouse so that reports can be generated which cross many products and provide linkage between the domains that you mentioned. Insight seems to fit your requirements very well.
Hi Jeff,
Am I correct to assume from your responseno that we can set up 1 insight DWH and ETL data from multiple RTC, RRC, RQM instances into it???
thanks
dD