Changing the dwh password using the ODBC Administration tool

When you change the password on for the dwh user on the Insight server, the password must also be changed on the Data Warehouse server. You use the ODBC Data Source Administrator tool to change the password on the Data Warehouse.

Before you begin

You must perform a remote login to the Data Warehouse server using an account with administrator privileges.

Steps

  1. Perform a remote login to the server hosting that Data Warehouse.
  2. Access the ODBC Administration tool at C:\Windows\SysWOW64\odbcad32.exe
    The system displays the ODBC Data Source Administrator screen.

  3. Click System DSN
    The system data sources are displayed.

  4. Select an OnCommand Insight Data Source from the list.
  5. Click Configure
    The Data Source Configuration screen is displayed.

  6. Enter the new password in the Password field.