A Microsoft SQL
client on Windows requires
an ODBC connection to the data warehouse. For the Tivoli® Performance Analyzer, you must configure
the ODBC connection manually.
Before you begin
This procedure uses default values for the data source name
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 Tivoli Performance
Analyzer on Windows to a
local or remote Tivoli Data
Warehouse.
Procedure
- 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 SQL Server and click Finish.
- Enter ITM Warehouse in the Name field.
- Select the Microsoft SQL
Server where the Tivoli Data
Warehouse is located from the drop down list and click Next.
- Select With SQL Server authentication using
a login ID and password entered by the user.
- Enter ITMUser for the Login
ID. 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. Mixing the case will cause tables
to be created with dbo as the owner rather than ITMUser. This will
cause many warehousing components to not work correctly.
- Type a password for the user in the Password field.
The default password is itmpswd1.
- Click Next.
- Click Next again.
- Click Finish.
- Click Test Data Source to test the
connection to the database.
- Click OK.