It's all about the answers!

Ask a question

Migrating the CLM data warehouse to Insight 1.1


Arun Batra (14612427) | asked Apr 27 '12, 1:48 a.m.
Hi,
I am trying to configure Insight 1.1 to use the CLM Data Warehouse. I am using the instructions given in the following link.

http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/index.jsp?topic=%2Fcom.ibm.rational.raer.migrating.doc%2Ftopics%2Ft_migrate_clm_dw_to_1011.html

It says in the second step:
Open the parameters.bat file and update the data warehouse connection properties.


Question: Which properties in the file do I have to change?

The file is as it appears below.
rem Oracle version database is bein deployed on
rem A value of 1 indicates 10G, 2 indicates 11g

SET ORA_VERSION=2

rem If ORACLE_HOME is not defined as an environment variable,
rem set the value for ORACLE_HOME

SET ORACLE_HOME=%ORACLE_HOME%

rem If ORACLE_BASE is not defined as an environment variable,
rem set the value for ORACLE_BASE


SET ORACLE_BASE=%ORACLE_BASE%

rem Default Rational Insight database ALIAS instance to use.
rem if a different value is required change the value of DBNAME
rem Not accepting the default implies changes in the connection information
rem defined on the Cognos BI server and Data Manager ETL

SET ORACLE_SID=JAZZWAREDB

rem Default account to use to execute the database installation.
rem If a different value is required change the value of DBUSER
rem Make sure to make the appropriate changes in the Data Manager credentials
rem for the "Rational Data Warehouse" connection

SET DBA_USER=SYS

rem Default schema name to use for the Operational Data Store.
rem If a different value is required change the value of NF_SCHEMA.
rem Not accepting the default implies that the Data Manager
rem ETL variable ODS will have to be changed as well

SET NF_SCHEMA=RIODS

rem Default schema name to use for the Asset Management Operational Data Store.
rem If a different value is required change the value of RIASSET_SCHEMA.
rem Not accepting the default implies that the Data Manager
rem ETL variables will have to be changed as well


SET RIASSET_SCHEMA=RIASSET

rem Default schema name to use for the MCIF Self-Check Operational Data Store.
rem If a different value is required change the value of RISCHK_SCHEMA.
rem Not accepting the default implies that the Data Manager
rem ETL variables will have to be changed as well

SET RISCHK_SCHEMA=RISCHK

rem Default schema name to use for the Data Mart.
rem If a different value is required change the value of STAR_SCHEMA.
rem Not accepting the default implies that the Frame Work Manager
rem meta-data model will need to be altered as well as as all published reports.
rem Additionally the Data Manager ETL variable DW will have to be changed as well.

SET STAR_SCHEMA=RIDW

rem Default schema name to use for the Business Analytics area of the database.
rem If a different value is required change the value of RIBA.
rem Not accepting the default implies that the Frame Work Manager
rem meta-data model will need to be altered as well as as all published reports.
rem Additionally the Data Manager ETL variable will have to be changed as well.

SET RIBA_SCHEMA=RIBA

rem Default account to use for the report executions.
rem If a different value is required change the value of REP_USER.
rem Not accepting the defaults implies that RIDW connection
rem in the Cognos BI server will have to be changed

SET REP_USER=RPTUSER

rem Default path for the table space files.
rem Change the value of DATA_HOME to any suitable value for your system

SET DATA_HOME=E:\JazzDatabases\JAZZDBWARE

rem Default start year from which to populate the
rem date dimension in the data mart. If the default is not suitable
rem change the value of START_YEAR to any sensible value required.

SET START_YEAR=2010

rem Default end year up to which to populate the
rem date dimension in the data mart. If the default is not suitable
rem change the value of END_YEAR to any sensible value required.
rem END_YEAR must be greater than the value specified for START_YEAR

SET END_YEAR=2012

rem Oracle Listener port
SET PORT=1521




Any help would be appreciated.


Thanks,
Arun

One answer



permanent link
Pinglao Zhao (21) | answered May 08 '12, 10:55 a.m.
JAZZ DEVELOPER
You have to review all the parameters according to their definition in the .bat/.sh file (the comment part before each parameter) and modify them based on your environment. They are environment dependent.

Hi,
I am trying to configure Insight 1.1 to use the CLM Data Warehouse. I am using the instructions given in the following link.

http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/index.jsp?topic=%2Fcom.ibm.rational.raer.migrating.doc%2Ftopics%2Ft_migrate_clm_dw_to_1011.html

It says in the second step:
Open the parameters.bat file and update the data warehouse connection properties.


Question: Which properties in the file do I have to change?

The file is as it appears below.
rem Oracle version database is bein deployed on
rem A value of 1 indicates 10G, 2 indicates 11g

SET ORA_VERSION=2

rem If ORACLE_HOME is not defined as an environment variable,
rem set the value for ORACLE_HOME

SET ORACLE_HOME=%ORACLE_HOME%

rem If ORACLE_BASE is not defined as an environment variable,
rem set the value for ORACLE_BASE


SET ORACLE_BASE=%ORACLE_BASE%

rem Default Rational Insight database ALIAS instance to use.
rem if a different value is required change the value of DBNAME
rem Not accepting the default implies changes in the connection information
rem defined on the Cognos BI server and Data Manager ETL

SET ORACLE_SID=JAZZWAREDB

rem Default account to use to execute the database installation.
rem If a different value is required change the value of DBUSER
rem Make sure to make the appropriate changes in the Data Manager credentials
rem for the "Rational Data Warehouse" connection

SET DBA_USER=SYS

rem Default schema name to use for the Operational Data Store.
rem If a different value is required change the value of NF_SCHEMA.
rem Not accepting the default implies that the Data Manager
rem ETL variable ODS will have to be changed as well

SET NF_SCHEMA=RIODS

rem Default schema name to use for the Asset Management Operational Data Store.
rem If a different value is required change the value of RIASSET_SCHEMA.
rem Not accepting the default implies that the Data Manager
rem ETL variables will have to be changed as well


SET RIASSET_SCHEMA=RIASSET

rem Default schema name to use for the MCIF Self-Check Operational Data Store.
rem If a different value is required change the value of RISCHK_SCHEMA.
rem Not accepting the default implies that the Data Manager
rem ETL variables will have to be changed as well

SET RISCHK_SCHEMA=RISCHK

rem Default schema name to use for the Data Mart.
rem If a different value is required change the value of STAR_SCHEMA.
rem Not accepting the default implies that the Frame Work Manager
rem meta-data model will need to be altered as well as as all published reports.
rem Additionally the Data Manager ETL variable DW will have to be changed as well.

SET STAR_SCHEMA=RIDW

rem Default schema name to use for the Business Analytics area of the database.
rem If a different value is required change the value of RIBA.
rem Not accepting the default implies that the Frame Work Manager
rem meta-data model will need to be altered as well as as all published reports.
rem Additionally the Data Manager ETL variable will have to be changed as well.

SET RIBA_SCHEMA=RIBA

rem Default account to use for the report executions.
rem If a different value is required change the value of REP_USER.
rem Not accepting the defaults implies that RIDW connection
rem in the Cognos BI server will have to be changed

SET REP_USER=RPTUSER

rem Default path for the table space files.
rem Change the value of DATA_HOME to any suitable value for your system

SET DATA_HOME=E:\JazzDatabases\JAZZDBWARE

rem Default start year from which to populate the
rem date dimension in the data mart. If the default is not suitable
rem change the value of START_YEAR to any sensible value required.

SET START_YEAR=2010

rem Default end year up to which to populate the
rem date dimension in the data mart. If the default is not suitable
rem change the value of END_YEAR to any sensible value required.
rem END_YEAR must be greater than the value specified for START_YEAR

SET END_YEAR=2012

rem Oracle Listener port
SET PORT=1521




Any help would be appreciated.


Thanks,
Arun

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.