324 IBM Tivoli Monitoring: Implementation and Performance Optimization for Large Scale Environments
9.4 Viewing data in Tivoli Enterprise Portal Server using
an external ODBC data source
You can add any ODBC data source to Tivoli Enterprise Portal Server and view
the data in the portal desktop client. This data is only used for viewing purposes.
If you want to view data from an Oracle database, you can configure the portal
server to add that data source by using the commands shown in Example 9-5.
Example 9-5 Adding a data source example
C:\IBM\ITM\BIN>tacmd login -u sysadmin -s berlin
KUIC00007I: User sysadmin logged into server on https://berlin:3759.
C:\IBM\ITM\BIN>tacmd configureportalserver -s OracleDB -p DSN=OracleDB
KUICRA031: Are you sure you want to create the OracleDB datasource in
the portal server configuration file C:\IBM\ITM\CNPS\kfwcma.ini and the
Windows Registry with the following properties?
Enter Y for yes or N for no: Y
KUICCP013I: The OracleDB datasource in the portal server configuration
file C:\IBM\ITM\CNPS\kfwcma.ini has been created with the following
KUICCP029I: The OracleDB datasource in the Windows Registry has been
created with the following properties:
After you log in to the Tivoli Enterprise Portal Server, you can write a query to
view data from your custom data source. To configure this, perform the following
1. From the portal client, open the Query Editor. You can create a custom query
by selecting OracleDB data source and assign this query (OracleSQL)
under Tivoli Enterprise Monitoring Server category to a view. The Query and
View are displayed, as shown in Figure 9-31 on page 325.
Note: After you add this data source, you must restart the Tivoli Enterprise
Chapter 9. Integrating data from external or third-party applications into Tivoli Data Warehouse 325
Figure 9-31 Creating a query from an ODBC data source
2. In the Custom SQL window, enter the following SQL (or an SQL of your
SELECT PID, USERNAME, PROGRAM, PGA_USED_MEM, PGA_ALLOC_MEM,
PGA_FREEABLE_MEM, PGA_MAX_MEM FROM V$PROCESS;
Click Apply and OK, as shown in Figure 9-32 on page 326.
326 IBM Tivoli Monitoring: Implementation and Performance Optimization for Large Scale Environments
Figure 9-32 Custom SQL window
3. Select any workspace and you can apply the OracleSQL query created in the
a. Select a workspace at Enterprise Level. Click File, then select Save
Workspace as, and give it a name.
b. Drag and drop a table icon on the empty view and click Yes to assign the
Chapter 9. Integrating data from external or third-party applications into Tivoli Data Warehouse 327
c. Select Click here to assign a query button, as shown in Figure 9-33.
Figure 9-33 Assigning a custom query to a workspace
d. Select the query (OracleSQL), which was created in the previous step.
First select Queries, then select Tivoli Enterprise Monitoring, then
select Server, and then Custom SQL.