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.

Note

When upgrading DWH, the folder containing the securityadmin tool vault backup is deleted. It is highly recommended to back up the vault prior to upgrading DWH. For reference, the default vault folders are as follows:

  • Vault folder (vaults in use):%SANSCREEN_HOME%\wildfly\standalone\configuration\vault

  • Vault backups: %SANSCREEN_HOME%\backup\vault

See Managing security on the Data Warehouse for more information.

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.