It's all about the answers!

Ask a question

Tables in RICALM schema?


Jill Davies (241417) | asked Jun 11 '13, 10:13 a.m.

Hi,

I'm trying to get Insight 1.1.1.1 to pull data from CLM v4 and I'm using the following instructions:

http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m2/index.jsp?topic=%2Fcom.ibm.rational.rrdi.admin.doc%2Ftopics%2Ft_import_clm301_dm_rietl.html

It's telling me that I need to run the JTS setup wizard to add the CALM tables to the datawarehouse.

However, we have a complex setup where

1. the CLM server is on an environment outside of our control and

2. we have multiple Data Warehouses, not all of which relate to the CLM environment.  We don't necessarily want to specify any one DW as the "default".

Is there any way in which we can add the CALM tables without using the JTS setup wizard?

Also, if we DO use the JTS setup wizard, what would be the implication of running it multiple times to install the tables into each of our DWs?

NB. Most of our Insight reports are bespoke and don't use the CALM tables anyway.

Thanks, Jill

One answer



permanent link
Josh Crawford (984615) | answered Jun 11 '13, 11:55 a.m.
 Hi Jill,  you don't necessarily have to use the JTS setup page but you will need to run repotools -createWarehouse at some point.  

http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/topic/com.ibm.jazz.install.doc/topics/r_repotools_createwarehouse.html?resultof=%22%63%72%65%61%74%65%57%61%72%65%68%6f%75%73%65%22%20%22%63%72%65%61%74%65%77%61%72%65%68%6f%75%73%22%20

How many JTS's do you have in your environment?  As far as CLM is concerned there should only be 1 DW per JTS and all registered applications (CCM, RM, QM)

Your answer


Register or to post 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.