cognos installation
TRANSCRIPT
-
7/29/2019 Cognos Installation
1/20
6/18/2010
Cognos 8 BI Configuration Document | ASHISH
TECHNO
FLAIR(TF)
LABHOWTO CONFIGURE COGNOS 8 WITH ORACLE?
-
7/29/2019 Cognos Installation
2/20
Table of Contents
Table of Contents ................................................................................................................. 2Installing and Configuring Cognos 8 Reporting on One Computer .................................... 3
Set Up Database Connectivity for the Content Store Database .......................................3
Create the Content Store .................................................................................................. 3Steps for Cognos Content Database .................................................................................4
.............................................................................................................................................. 4
Steps for Oracle ....................................................................................................................4
.............................................................................................................................................. 4Update the Java Environment .......................................................................................... 5
.............................................................................................................................................. 7
Configure the Web Server ................................................................................................... 7
.............................................................................................................................................. 7Cognos Configuration ........................................................................................................ 13
............................................................................................................................................ 13Create Cognos Content Store .........................................................................................13
Save Configuration ............................................................................................................16
............................................................................................................................................ 18
Launch Cognos Connection ...............................................................................................18............................................................................................................................................ 18
-
7/29/2019 Cognos Installation
3/20
Installing and Configuring Cognos 8 Reporting on One Computer
Set Up Database Connectivity for the Content Store Database1. Install the appropriate JDBC driver for your Content Manager database, as follows:
Oracle JDBC thin driver, ojdbc14.jar
Create the Content Store
The content store is a database that Content Manager uses to store global configuration data,global settings (such as the language and currency formats shown in the user interface),connections to data sources, and product-specific content. Design models and log files are notstored in the content store.By default, Cognos 8 products share the content store database. You must create thisdatabase using one of the following: Microsoft SQL Server Oracle DB2 Sybase Adaptive Server Enterprise (ASE)
We will use ORACLE as a database and content store.
Steps for Oracle1. Ensure that the parameter for the database instance compatibility level of the content storedatabase is set to 9.0.1 or higher. Cognos 8 will not work if Oracle version is below
9.0.1.For information about changing an instance configuration parameter, see the Oracledocumentation.2. Determine if the database is Unicode.Tip: One method is to type the following select statement:
SELECT * FROM NLS_DATABASE_PARAMETERS
The result set returns NLS_CHARACTERSET as UTF-8 or UTF-16, or AL32UTF8 orAL16UTF16, or not Unicode.
If the result set returns an NLS_CHARACTERSET that is not Unicode, create a new databaseand specify AL32UTF8 or UTF-8 for the database character set parameters.
3. Determine which user account will be used to access the database. Its better to createa new user.
Refer attached file
-
7/29/2019 Cognos Installation
4/20
:
C:\Documents andSettings\ASHISSHA\
4. Refer above document for sample database restore also.
Ensure that the user account that accesses the database has permission to do the following:
connect to the database create, alter, and drop tables, triggers, views, procedures, and sequences insert, update, and delete data in the database tables
Steps for Cognos Content Database
1. On the computer where you installed Cognos Content Database, go to the
c8_location\derby10.1.2.1\bin directory.
Steps for Oracle
1. On the computer where the Oracle client is installed, go to the ORACLE_HOME/jdbc/libdirectory.
2. Copy the ojdbc14.jar file to the c8_location/webapps/p2pd/WEB-INF/lib directory oncomputers where Content Manager is installed.
-
7/29/2019 Cognos Installation
5/20
If the directory contains the classes12.jar file, delete it before installing the ojdbc14.jar file.This file includes the driver required by the content store.
Update the Java Environment
Cognos 8 cryptographic services use a specific .jar (Java Archive) file, named bcprov-jdknn-nnn.jar, that must be located in your Java Runtime Environment (JRE).
1. Copy the bcprov-jdknn-nnn.jar file from the c8_location/bin/jre/version/lib/ext directory tothe Java_location/jre/lib/ext directory.
-
7/29/2019 Cognos Installation
6/20
2.
3.
4.
-
7/29/2019 Cognos Installation
7/20
And to
Configure the Web Server
Before you use Web pages generated by Cognos 8, you must configure your Web server. Youmust set up virtual directories, also known as Web aliases, for the directories that contain theHTML and Web files for Cognos 8. The virtual directories in the Alias column of the followingtable are required for all Web servers.
Alias Location Permission
cognos8 c8_location/webcontent Read
cognos8/cgi-bin c8_location/cgi-bin Execute
Go to Control Pannel> Administrative Tools> IIS
-
7/29/2019 Cognos Installation
8/20
-
7/29/2019 Cognos Installation
9/20
-
7/29/2019 Cognos Installation
10/20
Click next and finish.
-
7/29/2019 Cognos Installation
11/20
Again right click on cognos8 and select New Virtual Directory
Select EXECUTE
-
7/29/2019 Cognos Installation
12/20
Now your IIS is configured.
-
7/29/2019 Cognos Installation
13/20
Cognos Configuration
Create Cognos Content Store
Right click Content Store and click Delete.
Click YES
-
7/29/2019 Cognos Installation
14/20
Now provide user ID and Password that you have create on Step 3.
C:\Documents andSettings\ASHISSHA\
-
7/29/2019 Cognos Installation
15/20
-
7/29/2019 Cognos Installation
16/20
Save Configuration
Click Close
Now Click on ACTION> START
-
7/29/2019 Cognos Installation
17/20
Let the services start completely.
-
7/29/2019 Cognos Installation
18/20
Launch Cognos Connection
Now go to Environment
Copy the Gateway URL, This is your Personal URL.
Home URL: http://localhost/cognos8/
http://localhost/cognos8/http://localhost/cognos8/ -
7/29/2019 Cognos Installation
19/20
Click on MY HOME
-
7/29/2019 Cognos Installation
20/20