Tables in RICALM schema?
Hi,
I'm trying to get Insight 1.1.1.1 to pull data from CLM v4 and I'm using the following instructions:
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
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)