IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Administrator's Guide > Tivoli Common Reporting > Import and run BIRT reports

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2

Configure the data source

All reports in a BIRT report package must point to the same data source. The data source pointer needs to be modified to point to the Tivoli Data Warehouse.


After you have installed Tivoli Common Reporting and imported your first set of reports, you or a user with Administrator authority must copy JDBC drivers from the local or remote database manager that you are using to run the Tivoli Data Warehouse into the Tivoli Common Reporting server directory. You specify these files in the Edit Data Source window. Perform the following steps to install these drivers.


Procedure

  1. Locate the JDBC driver files:

    IBM DB2 db2jcc.jar and db2jcc.license_cu.jar

    C:\Program Files\IBM\SQLLIB\java

    db2_installdir/java
    For example, the default DB2 on the workstation Version 9 installation directory is /usr/opt/db2_09_01 on AIX and /opt/IBM/db2/V9.1 on Linux and Solaris.

    The JDBC drivers are typically found in this default DB2 installation path or in the java directory of whatever alternate path you specified for DB2 installation.

    You can also download the IBM DB2 Driver for JDBC and SQLJ from the IBM website.

    Microsoft SQL Server sqljdbc.jar

    Download the Microsoft SQL Server JDBC Driver from the Microsoft website. The SQL Server 2005 JAR file name and location after installation is mssql2005installdir/sqljdbc_1.1/enu/sqljdbc.jar.

    Oracle oraclethin.jar

    Obtain the JDBC Type 4 driver from the Oracle website. The Oracle JDBC driver JAR file name and location after installation is oracleinstalldir/jdbc/lib/oraclethin.jar.

  2. Copy the JDBC driver to the Tivoli Common Reporting installation directory:

    • tcr_install_dirTCR_component_dir\lib\birt-runtime-2_2_2\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.2.r22x_v20071206\drivers

    • For a DB2 data source, copy the DB2 JDBC drivers and the license JAR file to the same location. You can copy db2jcc.jar and th db2jcc_licence_cu.jar file on the DB2 server system from the db2_installdir/java location (for example, C:\Program Files\IBM\SQLLIB\java).

  3. Run the trcmd -modify command to configure the data source. See the trcmd-modify command topic in the Tivoli Common Reporting Information Center for complete instructions.


What to do next

For additional information, refer to the JDBC driver section of the IBM Tivoli Common Reporting: Development and Style Guide on IBM developerWorks Tivoli Common Reporting community. For more information about Tivoli Data Warehouse connectivity issues, refer to "Part 5. Setting up data warehousing" in IBM Tivoli Monitoring Installation and Setup Guide.


Parent topic:

Import and run BIRT reports

Previous topic: Import a BIRT report package

Next topic: Generate a sample BIRT report

+

Search Tips   |   Advanced Search