IBM Tivoli Netcool/OMNIbus, Version 7.4

Importing event summary reports into Tivoli Common Reporting

To run the event summary reports, connect Tivoli® Common Reporting to a relational database via a gateway. Then, import the report package that is supplied with Tivoli Netcool/OMNIbus into Tivoli Common Reporting.

Before you begin

Several products and components must be installed and configured so that the event data can be stored and displayed. These products are listed in the following table:

Product or component	Instructions
Tivoli Netcool/OMNIbus Gateway Configuration Scripts (Reporter Mode)	You can obtain these scripts from IBM® Passport Advantage® Online at http://www-306.ibm.com/software/howtobuy/passportadvantage/pao_customers.htm. To find the scripts on Passport Advantage Online, search for nco-g-jdbc-reporting-scripts 1_0. Configure the ObjectServer, the gateway, and the relational database according to the instructions that are provided with these scripts.
Tivoli Netcool/OMNIbus	An ObjectServer must be created and running.
Tivoli Common Reporting	V2.1 or V2.1.1 is required. For more information about installing and configuring Tivoli Common Reporting, see http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.tivoli.tcr.doc_21/ic-home.html. Tivoli Common Reporting is hosted in an instance of Tivoli Integrated Portal.
Relational database	You can use an IBM DB2® database, or Microsoft SQL, Sybase, or Oracle.
A Tivoli Netcool/OMNIbus gateway	Use the Gateway for JDBC. As an alternative, if your relational database is Oracle, you can use the Gateway for Oracle. Run the gateway in reporter mode. For more information about the gateway, see the IBM Tivoli Netcool/OMNIbus Gateway for JDBC Reference Guide, which contains information about the JDBC drivers that are required. Alternatively, see the IBM Tivoli Netcool/OMNIbus Gateway for Oracle Reference Guide. These publications are available from this information center.

About this task

To show the reports in Tivoli Common Reporting, you need to create a connection between Tivoli Common Reporting and the relational database. Then, you import the reports package, which is supplied with Tivoli Netcool/OMNIbus into Tivoli Common Reporting and verify that the import was successful.

Tip: Use Internet Explorer to work with Tivoli Common Reporting.

Procedure

To import the reports, proceed as follows. These steps assume that your relational database is DB2. If you are using a different database, make a different selection in step 2.b. The fields in the New Data Source Wizard change to reflect your choice.

Log in to Tivoli Integrated Portal as the tipadmin user, or another suitable user, and access the Administration page as follows:
1. From the left navigation, click Reporting > Common Reporting.
2. From the task bar at the top-right side, click Launch > Administration
3. On the Administration page, click the Configuration tab.
Add the data source connection. Perform these substeps with the information from the Tivoli Common Reporting information center at http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.tivoli.tcr.doc_21/ttcr_config_db.html.
1. Select Data Source Connections and click Add.
2. In the New Data Source Wizard, complete the fields as follows as you progress through the panels.
  Name
  
  Type Reporter. The name must be Reporter because it must be identical to the name that is used in the report package.
  
  Type
  
  Select the type of relational database, for example DB2.
  
  Use the default object gateway
  
  Select this check box.
  
  DB2 database field
  
  Type REPORTER. The DB2 database name must match the name in the Gateway for JDBC database schema.
  
  Signon
  
  Select this radio button.
  
  Password
  
  Select this check box.
  
  Create a signon that the Everyone group can use
  
  Select this check box.
3. Type your DB2 user name and then type and confirm your password. The DB2 user name must match the DB2 schema that contains the tables from the Gateway for JDBC database schema. Typically, this user name is the DB2 user that ran the gateway database script.
4. Click Test the connection and then click the Test button. Then, click Close > Close.
5. Click Next > Finish.
On the Tivoli Netcool/OMNIbus host, copy the Netcool_OMNIbus.zip report package from $NCHOME/omnibus/extensions/tcr_event_reports to the Tivoli Common Reporting host.
- /opt/IBM/tivoli/tipv2Components/TCRComponent/cognos/deployment
- C:\IBM\Tivoli\tipv2Components\TCRComponent\cognos\deployment
As the tipadmin user, or another suitable user, go to the location described in step 1 and click New Import .
Ensure that the Netcool_OMNIbus.zip file is selected and click Next. Then, type a name for the deployment specification and click Next. If the package is not available for selection, ensure that is copied to the location that is specified in step 3.
Select the check box that is next to the package that is contained in the Netcool_OMNIbus.zip file and click Next.
Click Next > Next. Then click Save only > Finish.
Click Play next to the imported package. Select Now and then click Run To return to the Content Administration page, click Back .

Results

The reports are added to Tivoli Common Reporting. You can view the reports in the Public folders area in Tivoli Common Reporting.

What to do next

You can take the following actions:

Read the report descriptions to familiarize yourself with the reports and their parameters.
Edit reports. To edit reports, click Report Studio from the report list, or from the right side of the HTML report.
Change the Tivoli Common Reporting model. For more information, see IBM DeveloperWorks article Tivoli Common Reporting Event Reports for Netcool OMNIbus at https://www.ibm.com/developerworks/mydeveloperworks/wikis/. To locate the article on DeveloperWorks, use the search function on the right of the page to search for items that are tagged with omnibus-tcr.