Where are the ETL jobs stored in Rational Insight 1.1.1.1

Hello Andrew,

you need to download the Data Manager packages from the CLM server and import them using the data manager client.

You can see the detailed instructions here:

Integrating the Collaborative Lifecycle Management report packages with Rational Insight
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m2/topic/com.ibm.rational.rrdi.admin.doc/topics/t_import_clm301_dm_rietl.html

Best Regards
Francesco

Hi Andrew

Were you able to integrate CLM 4.0.2 and RI 1.1.1.1 sucessfully ?
We also have similar environment and while running ETL jobs it gets hung.
After that we had suggestion from Rational as CLM 4.0.2 and RI 1.1.1.1 are not compatible.

Can you please confirm if that combination works for you ?

Thanks.

Hi Nikhil,

We are in the process of trying to load data from CLM 4.0.2 into RI 1.1.1.1
We have a lot of data in our CLM environment and the data loads are taking a long time to run (and occasionally fall over).
However, we have managed to get the JTS and the RTC jobs to complete and a couple of RQM project areas have also loaded.
I excluded a couple of the RTC jobs from the dataload as we don't need this data for our applications and these ones seemed to be taking a particularly long time:
- RTC_WorkitemHistory3.0.1.2 and
- RTC_HistoryCustomAttr3 (part of RTC_WorkitemCustomAttribute JobStream)
NB. If you exclude RTC_WorkitemHistory3.0.1.2, you will need to edit the "Finish" routine and remove "AND $RESULT05=TRUE"

Hope this helps.
Jill