HP Storage Essentials SRM 6.0 User Guide for Enterprise Edition and Standard Edition SRM Software (July 2008)

Running Reports446
1. Add the following class path to Report Designer. Refer to the documentation accompanying
Report Designer for more information.
C:\oracle\ora92\jdbc\lib\classes12.jar
where C:\oracle\ora92 is the directory containing classes12.jar.
2. Select File > New Catalog.
A catalog is a repository for reports. The catalog and the reports that are based on it must be in
the same directory for the report to run. This is because the catalog contains the object
definitions that are used by the reports in the catalog.
3. In the Name box, enter a name for the catalog, such as custom.cat.
4. Save the catalog in a directory created especially for it. This way you can work on the reports
remotely and then easily move them when you are ready to integrate them with the product.
5. Click OK.
When you finish creating the catalog, the Catalog Browser window is displayed. (If you do not
see the Catalog Browser window, open the catalog by selecting File > Open Catalog.) Select the
catalog you want to open, and then click Open.
6. In the Catalog Browser window, expand the Default node in the tree, and then right-click
Connection and select New Connection.
7. Verify that the OracleOraHome92TNSListener service is running on the management server.
NOTE: If you want to view live data in your custom reports, the management server does
not need to be running; however, the Oracle database for the management server does
need to be running.
8. In the Get JDBC Connection Information window do the following:
a. Deselect the Use ODBC Data Source option.
b. Select the JDBC Driver option.
c. Enter the following command for the JDBC driver:
oracle.jdbc.driver.OracleDriver
d. Enter the following command in the JDBC URL box:
jdbc:oracle:thin:@HostIP/DNS:1521:APPIQ
where HostIP/DNS is the host IP address or DNS name of the host running the management
server
If Report Designer is running on the same computer as the management server, you can use
localhost for the DNS name, as shown in the following example:
jdbc:oracle:thin:@localhost:1521:APPIQ
e. Enter the following in the User Name box: Report_User
This is the user name that is used to access the schema view in the management server
database. This user has read privileges only for the schema views.
f. Enter the following in the Password box: appiq
9. Click OK.
Report Designer searches for JDBC driver.