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

Get IBM Tivoli Monitoring: Implementation and Performance Optimization for Large Scale Environments now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.