migration of historical data when switching to Insight

Prasad Vasiraju (15●4●7) | asked Oct 07 '13, 2:35 p.m.

I am testing the use of Rational Insight. Part of the process is to point the data warehouse of the RTC repository to the one created for Insight. Then we need to suspend the data collection jobs in the RTC repository and set them up in the Insight ETL server. The question I have is; how do I transfer the old data in the RTC repository to the new warehouse it is now pointing to.

2 answers

Most liked answers ↓|Newest answers|Oldest answers

0	permanent link Francesco Chiossi (5.7k●1●9●19) \| answered Oct 08 '13, 9:16 a.m. Hello Prasad, as far as I know it's not possible to merge the historical data from multiple data warehouses. This thread discuss a similar scenario: Merging data warehouse databases Best Regards Francesco

permanent link

Francesco Chiossi (5.7k●1●9●19) | answered Oct 08 '13, 4:37 a.m.

Hello Prasad,

if you want to retain the old data from your RTC repository you should keep the current data warehouse that you have for RTC and during the Insight setup point to that database when configuring the data warehouse.

Best Regards
Francesco

Comments

Prasad Vasiraju commented Oct 08 '13, 9:07 a.m.

Francesco,

Thanks for the reply. However, what do I do if I want to use Insight with multiple RTC repositories as data sources, and want to retain the historical data from all of them.

Thanks
Prasad

It's all about the answers!

Related questions

migration of historical data when switching to Insight

2 answers

Your answer