Skip to main content
OnCommand Insight

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.


  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.

    system dsn
  4. Select an OnCommand Insight Data Source from the list.

  5. Click Configure

    The Data Source Configuration screen is displayed.

    data source password
  6. Enter the new password in the Password field.