This document will outline the steps necessary to install Discovery Hub or upgrade your production environment to use a new version of Discovery Hub. It will cover the download and installation of the software, upgrading the project repository (if upgrading), and ensuring that the Discovery Hub Scheduler service for the new version is up and running.
Please see the separate Discovery Hub Prerequisites article for information on the settings and software you need to have on the machine to install Discovery Hub.
Step by Step
Download and Installation
If you are installing Discovery Hub for the first time, i.e. not upgrading from a earlier version, you can ignore steps 12-15.
- Download the latest version of Discovery Hub in the edition and bit-version you need.
- When the file has been downloaded, unzip the installation package and run Setup.exe.
If all prerequisites has been met, you should be able to install using the .msi file in the downloaded archive. Using setup.exe is recommended, however, since it checks for the required version of the .NET Framework and installs it if necessary.
- On the welcome page, click Next.
- On the End-User License Agreement page, review the license agreement and select I accept the terms in the License Agreement if you do. Click Next.
- On the Choose Setup Type page, select Typical and click Next.
- On the Ready to Install page, click Install. Windows might ask you to confirm that you wish to make changes to the computer. If so, click Install the software. Wait for the installation to finish.
- Once the installation is completed, click Finish to close the setup program.
- Start Discovery Hub. There will be an icon on the desktop for Discovery Hub that you can doubleclick to launch the program. The first time Discovery Hub is opened it will prompt you for an activation code. Select Activate over the Internet
- If your server is located behind a proxy server you can add the credentials here, by activating the Use this proxy server.
- On the following screen paste or type in your organization's activation code and click Next. This will synchronize with our licensing server and enable all your licensed features of Discovery Hub.
- You will then be presented with this screen. Notifying you that the product have been activated successfully.
- After activating the software, you will receive a warning that the project repository settings are invalid.
Click OK to dismiss the warning, and on the next screen type in the server name that your current project repository resides on. Click the drop down arrow for the Database and select your current project repository. Click OK.
- If you are upgrading, Discovery Hub will recognize the old repository and prompt that it needs to be upgraded to be compatible with the new version of Discovery Hub. It will also show the location where the backup of the repository will be located. Click the Upgrade button.
While it is running a menu prompt will show you the current progress.
- You will then be prompted for the upgrade method. Select Web service.
The upgrade scripts will be downloaded and processed. Discovery Hub has now been installed and the project repository has been upgraded to be compatible with the new version of the software.
- Deploy and execute your project(s) using the new version to have the upgrade reflected in the actual project code. Validate the results before letting your end-users perform reporting on the upgraded projects data warehouse and/or cubes.
Setting Up the Scheduler Service
During the installation of Discovery Hub Server, a service is installed on the local machine that controls the execution packages. These execution packages handle the regular updates made to the data warehouse and the cubes.
The service needs to be run by a user with sufficient user rights and configured to use the correct repository database. This can either be the same account that you use to develop your projects or a different service account (recommended). How to point that user to the correct repository will be described below.
Follow the steps below to set up a new user account for use with the scheduler service. If you have upgraded to a new version you will still need to start up the scheduler in this new version. You can skip the first bit and go the step where we start the service, if you are using the account you use for development or if you are upgrading and already have a user account set up with the correct repository settings.
- Make sure that the account has sufficient permissions.
- On Analysis Services, Administrator rights (if you use OLAP Cubes).
- On the msdb database, membership of the db_ssisadmin role.
- On repository, staging and data warehouse databases, membership of the db_owner role.
With the user account configured, there is only one thing missing. Setting up what should be done if the service fails.
- Press the Windows button to bring up the start menu/start screen, type "services.msc" and press enter. This brings up a overview of Windows Services.
- Right click the Discovery Hub Server Scheduler service and select "Properties".
- On the Recovery tab the First failure and subsequent failures should be set to "Restart the service".
If you have started the service, but for some reason the execution gets errors regarding the wrong repository. It could be that the old version of the service is still running. Press the Options menu and choose filters All versions.
You can now see all the installed versions of Discovery Hub scheduler and server. Sort it by status. Only one scheduler service should be running.
To solve it simply stop it.
If you are upgrading from an earlier version, you can uninstall the old version of Discovery Hub once all of the previous steps have been successfully completed.