IBM Tivoli Monitoring: Implementation and Performance Optimization for Large Scale Environments

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

Password?

Validating user...

KUIC00007I: User sysadmin logged into server on https://berlin:3759.

C:\IBM\ITM\BIN>tacmd configureportalserver -s OracleDB -p DSN=OracleDB

UID=system PWD=password

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?

DSN=OracleDB;UID=system;PWD=password

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

properties:

DSN=OracleDB;UID=system;PWD=password

KUICCP029I: The OracleDB datasource in the Windows Registry has been

created with the following properties:

DSN=OracleDB;UID=system;PWD=password

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

steps:

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

Portal Server.

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

choice):

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

previous step.

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

query.

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.

328 IBM Tivoli Monitoring: Implementation and Performance Optimization for Large Scale Environments

e. Click OK, Apply, and OK again, as shown in Figure 9-34.

Figure 9-34 Query selection window