Set Up a New Aternity Dashboard Server

The Dashboard Server displays Aternity's intuitive dashboards using Tableau as its engine. It presents the raw data (from the Data Warehouse Server) and the older aggregated data (from the Database Server). Larger on-premise deployments require one or more additional Aternity Dashboard Worker Servers to display dashboards more efficiently.

Create the Dashboard Server which contains the Tableau Server and other components

The Dashboard Server must be a separate computer which contains the following components:

  • Tableau Server: Aternity 9.0.2 or 9.0.3 requires that your Dashboard Server runs Tableau Server 9.3.3.

    Tableau is the engine which processes the data into intuitive dashboards, as defined by the Aternity dashboard definitions.

  • The Dashboard Gateway acts as the interface between the Dashboard Server and the Aternity Management Server, performing background tasks like preprocessing the data for display in the dashboards, and maintaining logs, audits and cleanup. It must be on the same computer as the Dashboard Server. While it has no user interface of its own, it is crucial to the proper functioning of Aternity.

  • The Aternity dashboard definitions describe the layout and format of the Aternity dashboards which present the data to users.

Before you begin

Before creating the Dashboard Server:

  • Complete deployment of the Aternity Database Server.

    • (Non-DBAs) Use the express database setup for small deployments up to 3000 devices.

    • (DBAs only) Use the custom database setup for larger deployments or to integrate any sized database properly into your enterprise.

  • Make sure the hardware and operating system of the Aternity Dashboard Server conform to the following requirements:

    Attribute Requirement

    Operating system for Dashboard Server and Dashboard Worker Server

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

    Hardware

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

    Tableau version for Dashboard Server

    Aternity 9.0.2 or 9.0.3 requires that your Dashboard Server runs Tableau Server 9.3.3.

    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 installation directory and its sub-folders. Learn more.

    For less standard hardware configurations, see the installation 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 Download the latest version of Aternity on-premise from our website.

    The setup package is for all Aternity servers.

    Download Aternity on-premise from the website
  4. Step 4 Right-click the setup and select Run as administrator to begin.
  5. Step 5 Select Next and enter the pathname of a local, non-system drive.

    This reduces the risk of the server application competing with the operating system for disk space. For example, D:\Program Files\Tableau Server\Tableau.

    Select the location to place the Tableau files
  6. Step 6 Enter the name of the Start menu container to create, like Aternity Dashboard Server 9.0.
    Select the folder for the program's shortcuts
  7. Step 7 Select Next > Install to start.
  8. Step 8 Select Activate the product to activate Tableau.
    Activate Tableau
  9. Step 9 Enter Aternity's license key: TSE9-01A2-69C0-1B14-8A87, and select Activate.
    Enter the Aternity Dashboard Server activation key
  10. Step 10 If this computer is not connected to the Internet, perform an offline activation.

    When you select Activate, it prompts you to save a file for activating Tableau offline (learn more)

    1. a Select Save to save the offline.tlq file, and then copy it to a computer with Internet connectivity.
    2. b Select Exit to close the activation window.
    3. c From a computer with online access, upload the file on the Tableau activation page.

      Select Choose File, select offline.tlq, and select Upload Activation File.

      It returns a .tlf file.

    4. d Save the activation.tlf file, and copy it to the Dashboard Server.
    5. e (On the Dashboard Server) Open a command prompt as an administrator.

      Search for cmd on your computer, and on the result, right-click and select Open as Administrator.

      Open the computer's command prompt as an administrator
    6. f In the command prompt, navigate to C:\Program Files\Tableau\Tableau Server\9.3\bin and run the following command:
      tabadmin activate --tlf <path>\activation.tlf

      where <path> is the location of the second activation.tlf file you saved.

      Tip:

      The double hyphen is part of the command.

      Leave the command prompt open to use later in the procedure.

    7. g On the Dashboard Server, select Start > All Programs > Tableau Server 9.3.
    8. h Right-click Manage Product keys and select Run as Administrator.
    9. i Enter the Aternity's license key: TSE9-01A2-69C0-1B14-8A87 and select Activate the product.

      It generates a second .tlq file.

    10. j Save the newly generated .tlq file.
    11. k From a computer with Internet access, open the Tableau activation page again and upload the second new .tlq file.

      It generates a new and separate .tlf file.

    12. l Save the new, second activation.tlf file, and copy it to a different location on the Dashboard Server, separate from the first activation file.
    13. m On the Dashboard Server, from the command prompt, run the command:
      tabadmin activate --tlf <path>\activation.tlf

      where <path> is the location of the second activation.tlf file you saved.

      Confirm the activation completed successfully.

  11. Step 11 Configure the Dashboard Server in the configuration wizard which automatically opens.
    1. a In the General tab, maintain the default values.
      Configure the user, authentication and ports
      Field Description
      User / Password

      Do not change unless absolutely required.

      If the server is not on a domain like aternity.com, set the Tableau service to run as a local administrator user.

      User Authentication

      Always select Use Local Authentication.

      The users interacting with the Tableau Server are fixed in an Aternity deployment.

      Port number

      (Non-secure deployments only) Enter the port number for Aternity users to access the dashboards from their devices via HTTP. Default is 80.

      To deploy SSL (HTTPS), you must leave this as 80, and configure SSL later in this procedure.

      Tip:

      Later Tableau reroutes this automatically to 443. Tableau does not support any other secure port.

      You may need to change firewall rules to allow Aternity users to access this port from their devices. Use this port number when you deploy the Dashboard Gateway without SSL, so it too can communicate with the Dashboard Server.

    2. b Configure the size of the cache by selecting Data Connections.

      Use the recommended values listed here to obtain the optimal dashboard performance for Aternity.

      Configure the data connections
      Field Description
      Caching

      Select Balanced. Set the maximum cache time to be 15 minutes or less.

      Initial SQL

      Do not change the default setting.

  12. Step 12 Create a Tableau administrator account in the browser window which automatically opens.

    Enter an administrator username and password for the Aternity Dashboard Server (Tableau). Make a note of it for when you add the Aternity Dashboard Gateway Server.

    Tip:

    If the browser does not automatically open, manually go to http://localhost:[port_for_Tableau].

    Create a Tableau server administrator account
  13. Step 13 Verify it selects the Launch the Aternity Dashboard Server Monitor, and select Finish.
    Select to launch the server automatically
  14. Step 14 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.
      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.0\apache\bin).
    5. e Download Win32 OpenSSL v1.0.2j Light 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 main Dashboard Server, start the Tableau service by opening a command prompt as administrator and entering tabadmin start.
      Start the Dashboard Server after configuring the Dashboard Worker Server
  15. Step 15 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 and one of the Tableau processes is Stopped, grant explicit Run As User permission to each folder in the pathname of Tableau, including the root of the drive:

    1. a On the main Dashboard Server, stop the Tableau service by opening a command prompt as administrator and entering tabadmin stop.
      Stop the server on the main Dashboard Server
    2. b In Windows Explorer, right-click on the drive containing Tableau, and select Properties > Security > Edit > Add.
    3. c Enter Tableau Run as the user.
    4. d Select Allow on all options, including Modify.
    5. e On the main Dashboard Server, start the Tableau service by opening a command prompt as administrator and entering tabadmin start.
      Start the Dashboard Server after configuring the Dashboard Worker Server
  16. Step 16 (Large deployments only, above 20,000 devices) Add one or more standalone Dashboard Worker Servers by running its setup on a separate dedicated computer for that component.

    Add the number of standalone Dashboard Worker Servers according to the requirements for the size of your deployment.

    The Aternity Dashboard Worker Server accepts much of the intensive processing required to create dashboards, enabling larger Aternity on-premise deployments to display dashboards more efficiently.

    Dashboards in large deployments are more efficient with Dashboard Worker Servers
  17. Step 17 If the process did not complete successfully, or one of the steps returned an error:
    1. a Go to http://localhost, and enter the administrator's username and password.

      Verify you see the Tableau page.

    2. b Check the internet connection for maps, by trying to access one of their maps.

      Open the Tableau Console, and go to http://{$hostname}/views/Sales/2013SalesGrowth (or use https if you configured a secure connection). If the geographic maps are empty, try to access http://mapvisual.tableausoftware.com. If you receive a 404 error message, check your firewall is not blocking network service, or configure Tableau to work with a proxy. Then restart Tableau and access the maps again.

    3. c Check the logs located in the Tableau data folder (for example, C:\ProgramData\Tableau\Tableau Server\data\tabsvc\logs), or contact Aternity customer services.
  18. Step 18 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.
      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

      • 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 Copy these specific files and folders from the httpd-2.4.27-Win32-VC15\Apache24 folder in the temporary directory to C:\Program Files\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 Copy the mod_log_rotate.so file from the mod_log_rotate-1.00a-win32-VC15 folder in the temporary directory to C:\Program Files\Tableau\Tableau Server\<version>\apache\modules, overwriting the existing files.
    8. h On the main Dashboard Server, start the Tableau service by opening a command prompt as administrator and entering tabadmin start.
      Start the Dashboard Server after configuring the Dashboard Worker Server
    9. i Start the AternityTableauGateway service.
    10. j Verify that the update succeeded by opening a command prompt and entering tabadmin status –v.
      Tableau status after a successful update