
To let the developer system access the
IBM® Rational® Insight data warehouse
for running the reports, catalog the data warehouse and run the reports.
About this task
To configure the
Rational Insight database
catalog and the
Rational Insight models:
- Catalog the data warehouse.
- If the database is not installed locally, to enable Cognos® Data Manager to store
the catalogs in a database, create a database with an alias named RICTG.
- If the database is installed locally, create a database.
- 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.
- 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.
- Run the ETL jobs.
- 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.
- 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.