Set up Trial POC for Aternity on-premise 10 with VMWare Images (OVA files)

You can set up a trial POC of Aternity on-premise using VMWare virtual machines using OVA image files for each of the three servers. An OVA image file contains both the operating system and Aternity server setups required for a POC.

Important

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

Also, the operating system in each OVA file comes with security updates up to September 2018. We recommend you update to the latest security patches for the same version of that OS in each OVA.

Set up trial POC for Aternity on-premise on VMs with OVA image files

This procedure uses VMWare's vSphere to deploy the virtual machines.

Before you begin

You must be familiar with VMWare vSphere and vCenter.

This procedure assumes you already have a vCenter server with a resource pool for VMs, and access to a vSphere client.

Allocate the virtual machines with the dedicated resources as detailed in the trial sized hardware requirements.

Procedure

  1. Step 1 To download the three virtual machine image files (.ova), contact Customer Services.

    An OVA file contains an entire disk image, including both the operating system and Aternity server setups required for a POC (learn more).

    Field Description

    aternity-mgmt.ova

    This is the VM image file which contains Windows Server 2012 running the Aternity Management Server computer for trial deployments.

    It also contains the Aternity Oracle Database Server, the Aternity Data Warehouse Server and the Aternity Aggregation Server.

    aternity-tabl.ova

    This is the VM image file which contains Windows Server 2012 running the Aternity Dashboard Server computer for trial deployments.

    It also contains the Aternity Dashboard Gateway Server and the Aternity dashboard layouts.

    aternity-vertica.ova

    This is the VM image file which contains CentOS Linux 7 running the Aternity Vertica Database Server computer for trial deployments.

    It also includes the Aternity ETL Server, the Aternity Data Source for Portal and (in Aternity 10.0.1 only) the Aternity REST API Server.

  2. Step 2 Open the VMWare vSphere client.
  3. Step 3 Select File > Deploy OVF Template to select the ova image file to deploy.

    Select Next to review the details, then select Next.

    Open the image file for this VM
  4. Step 4 Assign the VM's internal vSphere name and location within vSphere's window.
    Add VM metadata to vSphere
    Field Description
    Name

    Enter the logical name for this VM which appears in the vSphere tree.

    Itinerary Location

    Enter the location of this VM in the vSphere tree.

  5. Step 5 Assign the CPU and disk resources for this virtual machine.

    The virtual machine (and therefore its host or cluster) must have the resources available as per the requirements for trial/POC deployments.

    Assign the virtual host or cluster which runs the VM
    Field Description
    Host/Cluster

    Select the host or cluster of hosts which you want to assign as the resource pool for this VM.

    Destination Storage

    Select the disk storage allocation for this virtual machine.

    Disk Format

    Select the method your VM allocates disk storage.

    Choose the method according to your enterprise provisioning policy. We recommend selecting Disk Format > Thin Provision if available.

  6. Step 6 Deploy all three virtual machines on the same network (recommended) or on networks where they can reach each other.

    Select Next then Finish to deploy. Perform the above steps for each of the image files.

    Deploy the VM to a network which ensures it can reach the other two VMs
  7. Step 7 Switch on each VM and update ALL the network settings for each VM to match your enterprise's environment.

    Edit the network settings as follows:

    • For Windows Server 2012 virtual machines, sign in as user administrator with password Aternity123, then select Start > Run and enter ncpa.cpl. Find your active network configuration, then select Properties > Internet Protocol version 4 (TCP/IPv4).

    • For Linux virtual machines, sign in as user root with password Aternity123, then edit ifcfg-ens160 in /etc/sysconfig/network-scripts with a plain text editor.

    Change VM network settings to fit your enterprise
    Field Description
    DNS1 / DNS2 Preferred DNS server / Alternate DNS server

    Enter the IP v4 address of the enterprise DNS server which would hold the entries for these three VMs: aternity-mgmt, aternity-tabl, and aternity-vertica.

    DOMAIN

    (Linux only) Remove the predefined value of this field (lab.aternity.com) and replace it with the domain suffix which your enterprise needs to resolve a hostname like aternity-vertica to aternity-vertica.mycompany.com.

    (Windows only) Select Advanced > Advanced TCP/IP Settings > DNS > Append these DNS suffixes (in order) > Add, then enter the domain suffix which you need to resolve a hostname like aternity-mgmt to aternity-mgmt.mycompany.com.

    Add DNS suffix in Windows
    NETMASK / GATEWAY / Subnet mask / Default gateway

    Enter the remaining network settings of this VM which fit your enterprise's address policy.

    IPADDR / IP Address

    Enter the IP v4 address of this VM which fits your enterprise's address policy.

    Ensure the VM is connected in vSphere.

  8. Step 8 Restart the network service of the Aternity Vertica Database Server for the new network settings to take effect.

    Enter service network restart

  9. Step 9 Create DNS entries in your enterprise DNS server for the three virtual machines, and map them to the IP v4 addresses which you assigned.

    Create entries for aternity-mgmt, aternity-tabl, and aternity-vertica in your DNS

  10. Step 10 Verify the version of Aternity components is the correct one, the one you wanted to download and install, by checking the Properties files in each place:
    • For the aternity-mgmt properties, see C:\data\aternity\build.properties.

    • For the aternity-tabl properties, see C:\data\AternityTableauGateway\build.properties.

    • For the aternity-vertica properties, see /root/ova_info.

  11. Step 11 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
  12. Step 12 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.

  13. Step 13 Restart the AternityTableauGateway service.
  14. Step 14 Access the Aternity Management Server computer.
  15. Step 15 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.

  16. Step 16 Stop the AternityPlatform service.

    Wait until the service has the status Stopped (not Stopping).

  17. Step 17 Select Start > ConfigTool, then select Database Configuration.
    Configure the database address

    Select Next for all screens and then Apply Changes.

  18. Step 18 Select Start AternityPlatform service then select Finish.

    This automatically starts the Aternity Management Server, which may take a few minutes.

  19. Step 19 Access the computer of the Vertica Database Server as a user with root or sudo root privileges on the computer. To verify, enter sudo id.
  20. Step 20 Verify the setup by confirming that Vertica is running.
    1. a Switch to the Vertica database administrator user, like dbadmin, by entering su - dbadmin.
    2. b Run the Vertica administration tool by entering admintools.
      Vertica's database administrator tools
    3. c Select the first option View database cluster state.

      Confirm the State is UP.

      Verify the database is running
      Tip

      If the database is not up, return to the main menu and select 3 to start the database.

  21. Step 21 Access Aternity by going to http://aternity-mgmt.

    Sign in with username administrator and password Q!w2e3r4. This trial deployment is not configured with secure communication (HTTPS).

    There are some browser settings which must be in place to access Aternity (learn more).

    To send queries to the REST API, use the URL http://aternity-vertica:8080/ in this trial deployment. Learn more.