Update the Dashboard Server for Aternity 10

The Dashboard Server displays Aternity's intuitive dashboards using Tableau as its engine. It presents the data from the Aternity Vertica Database Server.

If you already have a fully functioning Aternity 9.0.2 or 9.0.3, you do not need to update the Aternity Dashboard Server's Tableau, as they both use the same version. However, if you have Aternity 9.0.0 or 9.0.1, you must update to the correct version of Tableau by running the setup over the previous pathname. Aternity 10.0 requires that your Dashboard Server runs Tableau Server 9.3.3 (using Tomcat 7.0.64). Aternity 10.0.1 runs Tableau Server 9.3.22 (using Tomcat 7.0.82).

Update the Dashboard Server component (Tableau Server)

However, there are several steps required for running this version of Tableau with Aternity 10.

Before you begin

Before updating the Dashboard Server:

  • If you are running a version earlier than v9, update to v9 before updating to 10. The same version of Tableau runs in Aternity 9 and 10, so there is no need to update Tableau.

  • Check the correct sizing for your deployment before updating any of your Aternity servers.

    The Dashboard Server in Aternity 10 requires much less resources than Aternity 9.

  • Download the latest Aternity on-premise's main setup package from the Riverbed support site by selecting Software (size).

  • Prepare the Aternity Oracle Database Server for Aternity 10 by verifying its schema..

  • Aternity 10 requires you set up one or more new Vertica Database Servers, depending on the size of your deployment.

Ensure the hardware conforms to the following requirements:

Attribute Requirement

Operating system for Dashboard Server

Windows Server 64 bit 2016 (for Aternity 10.0.1 only), or 2012 R2, or 2008 R2 Enterprise Edition (with KB2117917). Set the date and time formats to Control Panel > Regions > Formats > English (United States).

Time zone

Synchronize all Aternity components to have the same date, time AND time zone.

Hardware

Hardware specifications depend on the size of your Aternity on-premise deployment. Choose the sizing and hardware specifications for your deployment size.

In addition, check the ports which you must open on this server (learn more).

Microsoft .NET

Ensure this server has Microsoft .NET 3.5 (exactly) required for the database drivers, and .NET 4.5 or later, required for driver setup (both in parallel). To add .NET to a Windows Server, learn more.

Tableau version for Dashboard Server

Aternity 10.0 requires that your Dashboard Server runs Tableau Server 9.3.3 (using Tomcat 7.0.64). Aternity 10.0.1 runs Tableau Server 9.3.22 (using Tomcat 7.0.82).

Network

Ensure this server has a static IP v4 address, and that you open the required ports.

Connectivity for Dashboard Server

This server must be open for access on port 80 or 443 from the Aternity Management Server and users accessing the Aternity dashboards from their browser.

This server requires internet access (port 80) to connect to Tableau's map service to render Aternity's geographic maps correctly.

In addition, open port 8000 on the Windows Firewall for Tableau's internal load balancer. Check Tableau's online help for a full list of required open ports.

Permissions for Dashboard Server

Ensure you have local administrator privileges on this computer.

Verify the Local Service account of Windows has permission to read, write, list and execute in the Tableau Server setup directory and its sub-folders. Learn more.

For less standard hardware configurations, see the setup instructions and hardware best practices from Tableau. To deploy on a virtual machine, you must guarantee the CPU and memory requirements.

Procedure

  1. Step 1 Access the new Aternity Dashboard Server.
  2. Step 2 Log in to the computer as a local administrator.

    To verify you are a local administrator on this computer, not a domain administrator, open the System control panel, select Advanced system settings > Computer Name, and confirm the Change button is active.

  3. Step 3 (Aternity 10.0 only) If you already have Tableau 9.3.3 (Aternity 9.0.2 or 3), you can skip to this step.

    If you had Aternity 9.0.2 and 9.0.3, skip to this step below.

    If you are updating from Aternity 9.0.0 and 9.0.1, you must first update to Tableau 9.3.3. Proceed to the next step.

  4. Step 4 Uninstall the previous Tableau Server or Aternity Dashboard Server from the Windows Control Panel.

    From the Windows Control Panel, select Programs and Features and uninstall Tableau Server or Aternity Dashboard Server.

    Do NOT remove the Aternity Dashboard Gateway Server.

    The uninstall preserves all existing settings for the update.

    Tip

    If it displays Tableau Server Command Line Utility or psqlODBC_x64 in the installed list of applications, you must also uninstall them.

  5. Step 5 Locate the TableauServer-9-3-3-Aternity-64bit.exe setup file, which you downloaded from the Useful Links section.

    Copy it to a temporary location on this computer.

  6. Step 6 Right-click the setup and select Run as administrator to begin.
  7. Step 7 Select Next and enter the path to the setup directory on a local, non-system drive.
    Important

    To use the settings from the previous version, you MUST use the same target pathname as the old version. This can be confusing, as the old and new pathnames may be very similar.

    Select the location to place the Tableau files
  8. Step 8 Enter the name of the Start menu container to create, like Aternity Dashboard Server 10.0.
    Select the folder for the program's shortcuts
  9. Step 9 Select Next > Install to start.
  10. Step 10 Review the settings in the configuration wizard which opens automatically.

    When you install in the same directory as the previous version, it preserves the settings here. Typically you would not change these values.

    Tableau Server settings
  11. Step 11 Sign in to the Tableau Server which opens automatically, using the dashboard administrator credentials when you originally set up the Tableau Server.

    The update preserves the same username and password from the previous setup. This is NOT your Aternity username.

    Tip

    The Tableau Server administrator username is only for the Aternity Dashboard Gateway Server to connect to Tableau.

    If you set up SSL access to the dashboards, it requires a valid certificate. Therefore accessing localhost in this way may cause your browser to issue a security warning.

    Log in to the Tableau Server
  12. Step 12 Verify it selects the Launch the Aternity Dashboard Server Monitor, and select Finish.
    Select to launch the server automatically
  13. Step 13 Select Start > Configure Aternity Dashboard Server > Servers.
    Access the Dashboard Server configuration
  14. Step 14 Select This Computer (Primary) and select Edit.
    Edit the process allocation for dashboard components

    Enter the values according to the size of your deployment.

    Field Trial X-Small Small Medium Large X-Large XX-Large
    VizQL Server

    1

    1

    1

    2

    2

    2

    2

    Application Server

    1

    1

    1

    1

    1

    1

    1

    Backgrounder

    1

    1

    2

    2

    2

    2

    4

    Cache Server

    0

    0

    0

    0

    0

    0

    0

    Data Server

    1

    1

    2

    2

    2

    2

    2

    Data Engine

    1

    1

    1

    1

    1

    1

    1

  15. Step 15 Enter the activation key for the Tableau Server in Aternity 10.

    Right-click the Tableau Server's system tray icon and select Manage product keys > Activate. Enter the new key TS1E-AFF9-2A60-C12B-CBF5, then select Activate.

    Add a key to the Tableau Server
  16. Step 16 Verify the setup succeeded, by checking the status of the system tray icon.

    Right-click and select Display Status to verify it is Running.

    Verify the Aternity Dashboard Server

    If the Tableau server does not start, open a command prompt and enter tabadmin status –v. If the status is DEGRADED, check your computer has the required resources dedicated for Tableau.

  17. Step 17 (For Aternity 10.0 only) For improved security, update Tableau's Apache web server.

    This update addresses a specific vulnerability.

    1. a On the main Dashboard Server, stop the Tableau service by opening a command prompt as administrator and entering tabadmin stop.

      Navigate to <setup_dir>\Tableau\Tableau Server\<version>\bin then enter tabadmin stop

      Stop the server on the main Dashboard Server
    2. b Stop the AternityTableauGateway service.
    3. c Download these update files to a temporary directory on your Dashboard Server:

      vc_redist_x86.exe, httpd-2.4.27-Win32-VC15.zip, and mod_log_rotate-1.00a-win32-VC15.zip

    4. d Run vc_redist_x86.exe.
    5. e Unpack httpd-2.4.27-Win32-VC15.zip and mod_log_rotate-1.00a-win32-VC15.zip in the temporary directory.
    6. f Backup the old files, then copy these specific files and folders from the httpd-2.4.27-Win32-VC15\Apache24 folder in the temporary directory to <setup_dir>\Tableau\Tableau Server\<version>\apache, overwriting the existing files and folders:

      All of the *.txt files

      The entire \bin folder

      The entire \cgi-bin folder

      The entire \conf folder

      The entire \error folder

      The entire \modules folder

    7. g Backup the existing file, then copy the mod_log_rotate.so file from the mod_log_rotate-1.00a-win32-VC15 folder in the temporary directory to <setup_dir>\Tableau\Tableau Server\<version>\apache\modules, overwriting the existing files.
    8. h On the Dashboard Server, start the Tableau service by opening a command prompt as administrator and entering tabadmin start.

      Navigate to <setup_dir>\Tableau\Tableau Server\<version>\bin then enter tabadmin start

      Start the Dashboard Server
    9. i Verify that the update succeeded by opening a command prompt and entering tabadmin status –v.
      Tableau status after a successful update
    10. j Start the AternityTableauGateway service.
  18. Step 18 To secure browser access to Aternity with HTTPS, configure the Dashboard Server to use your certificate files.
    Tip

    For secure HTTPS (SSL) web access to Aternity, you must secure both the Aternity Management Server and the Aternity Dashboard Server.

    Secure the Dashboard Server for secure access to Aternity
    1. a On the Dashboard Server itself, create a subdirectory in the Tableau directory called SSL.

      For example, D:\Tableau\Tableau Server\SSL.

    2. b Copy your signed certificate file (.crt) and the key file (.key) into this folder.
    3. c On the main Dashboard Server, stop the Tableau service by opening a command prompt as administrator and entering tabadmin stop.

      Navigate to <setup_dir>\Tableau\Tableau Server\<version>\bin then enter tabadmin stop

      Stop the server on the main Dashboard Server
    4. d Backup libeay32.dll and ssleay32.dll from the apache\bin directory (like C:\Program Files\Tableau\Tableau Server\9.3\apache\bin).
    5. e Download Win64OpenSSL_Light-1_0_2n.exe and launch it.
    6. f Copy the newly downloaded libeay32.dll and ssleay32.dll into the apache\bin directory.
    7. g Configure SSL by selecting Start > All Programs > Aternity Dashboard Server > Configure Tableau Server > SSL.
      Open the Tableau Server Configuration window
      Field Description
      Use SSL for server communication

      Select to enable SSL encrypted communication with other components.

      SSL certificate file

      Enter the pathname of the certificate (.crt) file.

      SSL certificate key file

      Enter the pathname of the key (.key) file.

    8. h Select OK.
    9. i On the Dashboard Server, start the Tableau service by opening a command prompt as administrator and entering tabadmin start.

      Navigate to <setup_dir>\Tableau\Tableau Server\<version>\bin then enter tabadmin start

      Start the Dashboard Server