INSTALLATION OF IBM COGNOS 8.4.1 (Part-3)

Import the Database Files:
The next step is to unzip the files related to database and import them.
Go to C:\Program Files\IBM\Cognos\webcontent\samples\datasources\oracle.
We can find the files with the extension ".dmp". Unzip each one of them. And hence the Crash Dump Files are created. We will be importing each of the following files.
Now execute the following command in the command prompt.
First change the directory in the command prompt to:
C:\Program Files\IBM\CognosDeveloper841\webcontent\samples\datasources\oracle.
Run the following commands step-by-step. After executing each of these commands, make sure to check the log files.


imp gosales/cognos@xe file = GOSALES.dmp log = log_gosales.txt
imp gosaleshr/cognos@xe file = GOSALESHR.dmp log = log_gosaleshr.txt
imp gosalesdw/cognos@xe file = GOSALESDW.dmp log = log_gosalesdw.txt
imp gosalesmr/cognos@xe file = GOSALESMR.dmp log = log_gosalesmr.txt
imp gosalesrt/cognos@xe file = GOSALESRT.dmp log = log_gosalesrt.txt


Hope you remember that gosales, gosaleshr, gosalesdw, gosalesmr, gosalesrt are the users we have already created in Oracle. We have pretty much done all the data import into our Oracle database.


Creating the Data Sources:
Open Start -> IBM Cognos 8 BI Developer Edition -> IBM Cognos 8 BI Developer Edition. Now Launch IBM Cognos Administration. Open the "Configuration" Tab -> Data Source Connections.