Configuring a Warehouse Proxy agent on Windows (ODBC connection)

Use this procedure to configure a Warehouse Proxy agent on Windows to connect to a Tivoli Data Warehouse in Microsoft SQL Server:

1. Log on to the Windows system where the Warehouse Proxy agent is installed and begin the configuration:
   1. Click Start → Programs → IBM Tivoli Monitoring → Manage Tivoli Monitoring Services.

      The Manage Tivoli Enterprise Monitoring Services window is displayed.

   2. Right-click Warehouse Proxy and click Configure Using Defaults.

      Click Reconfigure if the Warehouse Proxy is installed on the same computer as the portal server.

   3. Click OK on the message regarding connection to a hub monitoring server.
2. The next two windows (entitled Warehouse Proxy: Agent Advanced Configuration) contain the settings for the connection between the Warehouse Proxy agent and the hub monitoring server. These settings were specified when the Warehouse Proxy agent was installed. Click OK on each window to accept the settings.
3. Click Yes on the message asking if you want to configure the ODBC data source.
4. Select SQL Server from the list of databases and click OK.

   The following configuration window is displayed.

   Figure 46. Configure SQL Data Source for Warehouse Proxy window

   
5. Click OK to accept all default information on this window, or change one or more default values and then click OK. The fields on this window are described in Table 85.
   Note:
   The values for the data source name, and database user ID and password must match the values that you used when configuring an ODBC connection for the Warehouse Proxy agent. (See Configuring an ODBC data source for a Microsoft SQL data warehouse.)

   Table 85. Configuration information for the Tivoli Data Warehouse database on Microsoft SQL Server

   Field	Default value	Description
   Data Source Name	ITM Warehouse	The name of the data source.
   Database Name	WAREHOUS	The name of the database.
   Admin User ID	sa	The database administrator ID.
   Admin Password	(no default)	The password for the database administrator.
   Database User ID	ITMUser	The login name of the database user that the portal server will use to access the Tivoli Data Warehouse database. The user ID must match exactly, including case, what was created in the SQL Server database if using database authentication or the ID that was created in the Windows OS.
   Database Password	itmpswd1	The password for the database login user. If your environment requires complex passwords (passwords that require both alpha and numeric characters), specify a password that complies with these requirements.
   Reenter Password	itmpswd1	Confirm the password by entering it again.
   Synchronize TEPS Warehouse Information	yes	This check box is used only if you are re-configuring a Warehouse Proxy agent that is installed on the same Windows computer as the portal server. If this check box is selected, any change that you make to the connection information on this window for the Warehouse Proxy is automatically applied to the portal server.

6. Click OK.

[ Top of Page | Previous Page | Next Page | Contents | Index ]