Keep using Data Mart until Data Warehouse ETLs finish (RTC 3.0.1)
Hi, We are going to migrate our RTC 3.0 to 3.0.1 version. During the time the Data Warehouse ETLs are running some reports will show inaccurate data. I have two questions: - Given that ETLs may take several days to run for the first time, is there any way to keep using Data Mart until ETLs finish? - How much will be the impact in the RTC performance? I would appreciate any help you may give me. Regards,
|
Accepted answer
Leonardo,
Here is a set of steps I once provided to a customer who wanted to do the same thing (continue to have access to the BIRT reports while the transfer is taking place). Since you have already created a DW and may also know how to run jts/setup to configure the use of the new DW, you can skip that information. Switching to a DW from a Datamart Switching from a 2.x style datamart to the 3.0.1 data warehouse involves at a high-level the following steps. There is a way to continue to have access to the BIRT reports while the transfer is taking place. I have added that to the steps below.
8. The BIRT reports will start using the data warehouse after Step 7 is completed. Leonardo Marzo selected this answer as the correct answer
|
3 other answers
The RTC will continue to use DataMart until the ETLs have run once successfully. After that RTC switches to warehouse automatically. You can continue the use the DataMart during this operation (with inaccurate data).
Also, as you rightly pointed out, the first run of the ETLs will be slow. However, subsequent fetches being delta, they will be much faster. The impact of the RTC performance will depend on the RTC user load on database and the total number of WorkItems (which will define the ETL load). If the number of WIs is very high and there is a busy traffic on RTC servers as well, then it is recommended to have a separate database server for the warehouse.
|
Thanks for your answer Ankur.
"The RTC will continue to use DataMart until the ETLs have run once successfully". But, how do you run ETLs for the first time? I think that you have to do it manually. And to do this you need to select "Data Warehouse..." in ccm/admin-->Reports-->Data Collections Jobs. And when you choose that option, RTC uses Data Warehouse instead of Data Mart. So, my question is... is it possible to run Data Warehouse ETLs while using the Data Mart?. Regards, |
Rosa,
Thanks for your answer. I think that's what I was looking for! I'll try it in our sandbox and I let you know. Regards,
|
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.