Configuring the report development tools: Tasks for Oracle Server

Linux To let the developer system access the Rational® Common Reporting data warehouse for running the reports, catalog the data warehouse and run the reports.
About this task
To configure the Rational Common Reporting database catalog and the Rational Common Reporting models:
  1. Catalog the data warehouse.
    • If the database is installed locally, create a database.
    1. Run the following command under the [rational_insight_installation_directory]/cognos/bin directory:
      #./catmanage ORACLE "USERNAME/PASSWORD@RICTG" -c
      where USERNAME and PASSWORD are the user name and password of a valid Oracle user account.
    2. Restore the catalog by running the following command under the [rational_insight_installation_directory]/cognos/bin directory:
      #./catrestore ORACLE "USERNAME/PASSWORD@RICTG" [INSTALLDIR]/datamgr/insight_catalog/OOTBDMCatalog.ctg
      where USERNAME and PASSWORD are the user name and password of a valid Oracle user account.
  2. Run the ETL jobs.
    1. To list all fact jobs in catalog, run the following command under the [rational_insight_installation_directory]/cognos/bin directory:
      #./catlist ORACLE "USERNAME/PASSWORD@RICTG" J 
      where USERNAME and PASSWORD are the user name and password of a valid Oracle user account.
    2. To run the fact jobs, run the following command under the [rational_insight_installation_directory]/cognos/bin directory:
      #./rundsjob ORACLE "USERNAME/PASSWORD@RICTG" OOTBE2E
      where USERNAME and PASSWORD are the user name and password of a valid Oracle user account.

Feedback