First Time Report Configuration
From Tecniq
Contents |
TCR - First Time Report Configuration
Pre-requisites
- ITM 6.2 is installed with OS agents up and running.
- Summarisation and pruning agent is started (with or without shifts enabled).
- Historical collection turned on and collection started. Summarised tables and views are created and populated in the Tivoli Data Warehouse.
NOTE: Daily and Hourly summarisation MUST be enabled for the following tables:
Windows Agents:
- NT_Memory, NT_Logical_Disk, NT_System, NT_Processor, NT_Process, NT_Server
Linux Agents:
- Linux_CPU, Linux_Disk, Linux_VM_Stats, Linux_Process, Linux_Network
Unix Agents:
- System, Disk, Unix_Memory, Process, Network
JDBC Database Driver Installation
Place the JDBC drivers needed to establish a connection to the database in the following directory:
C:\IBM\tivoli\tip\products\tcr\lib\birt-runtime-2_2_1\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.1.r22x_v20070919\drivers
|
Database Driver | File(s) | Source | |
|---|---|---|---|
| DB2 | com.ibm.db2.jcc.DB2Driver | db2jcc.jar db2jcc_license_cu.jar | TDW server: \Program Files\IBM\SQLLIB\java |
| Oracle | oracle.jdbc.driver.OracleDriver | oraclethin.jar | TDW server: \oracle\product\10.2.0\db_1\jdbc\lib ♦ |
|
SQL Server 2005 | com.microsoft.sqlserver.jdbc.SQLServerDriver | sqljdbc.jar | TDW server: <mssql2005installdir>/sqljdbc_1.1/enu/sqljdbc.jar ♦ |
♦ unverified
Data Source Configuration
1. Right click on any report in the Reports panel on the right hand side and click on “Data Sources…”
2. This will pull up the list of data source name and type used by the report set. Select the “ITM” data source and click “Edit”:
3. This will display the Data Source Edit dialogue. You will need to provide a recognisable “Display Name”, set the Database “User ID” to “itmuser”, with corresponding “Password”.
Change the “JDBC URL” so the domain/IP part matches your own TDW server. Provide a descriptive comment if desired to replace the default “undefined”, and then press “Save”:
Note: You do not need to repeat this step for the other reports. Once defined via any report it is changed for all.
