This document will outline the steps necessary to install TX DWA or upgrade your production environment to use a new version of TX DWA. It will cover the download and installation of the software, upgrading the project repository (if upgrading), and ensuring that the TX DWA Scheduler service for the new version is up and running. Note that the same procedure applies to tX2012 and TX2014.
Please see the separate TX DWA Prerequisites article for information on the settings and software you need to have on the machine to install TX DWA.
Step by Step
Download and Installation
If you are installing TX DWA for the first time, i.e. not upgrading from a earlier version, you can ignore steps 6-8.
- Download the latest version of TX DWA 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 TX DWA. There will be an icon on the desktop for TX DWA that you can doubleclick to launch the program. The first time TX DWA is opened it will prompt you for an activation code. Select Internet – I have a license code.
- On the following screen paste or type in your organization's activation code and click Send. This will synchronize with our licensing server and enable all your licensed features of TX DWA.
- 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, TX DWA will recognize the old repository and prompt that it needs to be upgraded to be compatible with the new version of TX DWA. Click the Upgrade button.
- You will then be prompted for the upgrade method. Select Web service.
The upgrade scripts will be downloaded and processed. TX DWA 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 TX DWA 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).
Follow the steps below to set up a new user account for use with the scheduler service. You can skip this 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, you are ready to set the service to start automatically with the correct username and password.
- 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 TX DWA Server Scheduler service and select "Properties".
- On the General tab the Startup Type should be set to "Automatic (Delayed Start)". If your version of Windows does not support this, select "Automatic" instead.
- On the Log On tab a service account should be used. You can refer to the original TX DWA Scheduler service to determine which account was previously used. The password is required.
- Click OK to save your changes and close the window.
- Right click on the TX DWA Server Scheduler service and click "Start".
- If you receive a message that the service started and then stopped the most common cause is that the TX DWA configuration files have not been created for the service account that was specified to start the service. The proper solution is to log on to the server using this service account, open TX DWA, and point to the project repository when prompted. This will create the configuration files required by the service account. You can now log off and log back on as the original user. You should now be able to properly start the service.
Uninstalling the Old Version
If you are upgrading from an earlier version, you can uninstall the old version of TX DWA once all of the previous steps have been successfully completed.
This article applies to: tX2012, TX2014, TX DWA.