Upgrading Data Warehouse

After you complete all prerequisite tasks, you can log in to the Data Warehouse server and run the installation package to complete the upgrade.

About this task

Inline upgrade is not supported by the Data Warehouse (DWH). Use the following steps to upgrade to the new version of DWH software.

Steps

  1. Log in to the DWH server using an account that has Windows local administrator permissions.
  2. Back up the DWH DB and Reports using the DWH portal interface.
  3. Back up the security configuration if the server is using a non-default security configuration.
  4. Uninstall the DWH software from the server.
  5. Reboot the server to remove components from memory.
  6. Install the new version of DWH on the server.
    The installation takes approximately 2 hours. It is a best practice to leave all the defaults selected.
  7. Restore the non-default security configuration to the DWH server.
  8. Restore the DWH database to the server.

After you finish

After you upgrade, you must restore the Data Warehouse database, which can take as long or longer than the upgrade.
Note: During an OnCommand Insight upgrade, it is not uncommon for a customer to switch to a different Insight server. If you have changed your Insight server, after you restore the data warehouse database the existing connectors will point to the previous server IP address or hostname. It is a best practice to delete the connector and create a new one, to avoid possible errors.