A DB2® for Linux, UNIX and Windows client
on Windows requires an ODBC
connection to the data warehouse. For the Warehouse Proxy Agent, you
must configure the ODBC connection manually.
Before you begin
- If the warehouse database is remote from the Warehouse Proxy Agent,
catalog the remote database before you configure the ODBC data source.
See Cataloging a remote data warehouse. The ODBC connection
does not work if the remote database has not been cataloged prior
to performing this procedure.
- This procedure uses default values for the data source name, warehouse
alias, and warehouse user ID. (Default values are used in configuration
procedures for warehousing components.) Substitute different values
if you do not want to use the default values.
About this task
Complete the following procedure to set up an ODBC connection
for a Warehouse Proxy Agent on Windows to
a local or remote Tivoli® Data
Warehouse.
Procedure
- On the computer where the Warehouse Proxy Agent is installed,
open the Control Panel.
- Click Administrative Tools → Data Sources (ODBC)
- Click Add in the System
DSN tab in the ODBC Data Source Administrator window.
- Select IBM® DB2 ODBC DRIVER from the list.
- Click Finish.
- In the ODBC DB2 Driver
- Add window, perform the following steps:
- Enter ITM Warehouse in Data
source name.
- Enter Warehous in Database
Alias.
If the Tivoli Data Warehouse is located on a remote
computer, ensure that the database alias matches the alias that you
used when cataloging the remote data warehouse. See Cataloging a remote data warehouse.
If local, ensure that the
database alias matches the name used for the warehouse database.
- Click OK.
- Test the ODBC database connection before continuing:
- In the ODBC Data Source Administrator window,
select ITM Warehouse.
- Click Configure.
- In the CLI/ODBC Settings - ITM Warehouse
window, you see the data source name, ITM Warehouse.
- Enter ITMUser for the User
ID.
- Type a password for the user in the Password field.
The default password is itmpswd1.
- Click Connect.
- A Connection test successful message
is displayed.
- Click OK.
- Click OK to close the window.