Setting up the Cognos 8 Samples on DB2
Cognos 8 Business Intelligence ships with sample data and reports for a fictional company named “The Great Outdoors”. The samples are useful for testing the functionality of the product and for following the examples in the documentation. The Cognos 8 samples are similar to the samples shipped with Series 7 and ReportNet, but not exactly the same. It is recommended to use the sample data that shipped with the version of the product installed, or some of the sample reports will not work correctly. If you are using several versions of the Cognos software concurrently, this means restoring the data into different schemas or different databases. This tutorial will walk through restoring the sample data on DB2 and then setting up the sample reports. The five SQL scripts used to setup the database can be downloaded here: cognos8_sample_setup_db2.
Create the sample database
Installing DB2 Express-C on Windows
IBM makes available a free version of their flagship DB2 database called DB2 Express-C. It is a competitor to Oracle Express, Microsoft SQL Server Express and MySQL. It is ideal for a development environment or a small pilot project, and it can be updated to a fully supported licensed version at any time. Cognos 8 Business Intelligence supports reporting off this database and using it as the content store. This tutorial will step through the installation of DB2 Express-C on Windows.
Download DB2 Express-C from the IBM website: http://www-306.ibm.com/software/data/db2/express/download.html
Extract the files, and double click setup.exe to get started. On Windows Vista or Windows 2008 Server, right click the setup.exe and select ‘Run as Administrator’.
Installing Cognos 8 Business Intelligence Server on Windows
This tutorial walks through the installation of IBM Cognos 8.3 Business Intelligence Server on Windows.
To start the installation, double click the issetup.exe in the win32 directory. On Windows Vista or Windows 2008 server, right click issetup.exe and select ‘Run as Administrator’.
Troubleshooting BI software
Subscribe by email
Translate this page
New Resources
Recent Blog Posts
Categories
- Code Samples (3)
- Cognos 8 (5)
- Cognos 8 SDK (1)
- Databases (1)
- Security (1)
- Series 7 (2)
- Web Servers (1)
- White Papers (5)