Analytics Exchange 14.1 Server Admin Guide

Install AX Engine Node for PostgreSQL

Install AX Engine Node to increase the analytic processing capability of Analytics Exchange. AX Engine Node is hosted on a separate server from AX Server.

Install and configure AX Server before you install AX Engine Node. For more information, see PostgreSQL installation.

Note

The installer download page provides the latest version of Analytics Exchange. If you require an installer for a previous version, you must contact Support for a copy of the installer for that version.

  1. Sign in to Launchpad (www.highbond.com).

    Your company's System Admin should have already received sign-in information from notifications@highbond.com. If you are unable to sign in to your Launchpad account, contact your company’s System Admin or Support for assistance.

  2. Under Resources, click Downloads.
  3. In the top menu, click Analytics Exchange.
  4. From the Select software package to download list, select the installer you want to download.

    Note

    Ensure that you download the correct edition (non-Unicode or Unicode) as all installed applications must use the same edition.

  5. Click Download Version <version_number> and save the installer to the computer where you will install the application.

Caution

You must install the KB2919355 Windows Updates before starting your Analytics Exchange installation on Windows Server 2012 R2. If you do not install this update, your Analytics Exchange installation cannot succeed.

Run the installer and select the database configuration

  1. Double-click the installation package and if a security warning dialog box appears, verify the information listed and click Yes.
  2. Select the setup language and click OK.
  3. In the Setup Extraction Location page, specify the folder where the installation files will be extracted, and click Install.

    Tip

    Click Browse to select a folder or accept the default location:

    C:\Program Files (x86)\ACL Software\Installers\ACLAX<version>_EngineNode_<edition>.

  4. In the Analytics Exchange Server Setup Options page, select PostgreSQL and click Next.
  5. If you are prompted to install prerequisites, click Install and wait while the prerequisites are installed.

    Follow any on-screen instructions to complete the prerequisite setup.

Configure the database service

  1. In the Welcome page, click Next and in the License Agreement page, select I accept the terms in the license agreement and click Next.
  2. In the Destination Folders page, specify where the AX Engine Node application files will be installed and the working directory for analytic processing, and then click Next.

    If necessary, click Change to modify either, or both, of the default locations. The paths you specify must not include any spaces.

  3. In the ACL Analytics Exchange server information page, enter the IP address of the server where AX Server is installed and click Next.
  4. In the first Analytics Exchange Server database connection settings page, select PostgreSQL from the Database Platform options.
  5. To encrypt the database connection, select Encrypt database communications and then click Next.

    To encrypt the connection, the database server must be configured for SSL connections.

    Tip

    Encryption slows performance somewhat, so you should enable it only if data is being transferred between the database server and the application server over an unsecure network.

  6. In the second Analytics Exchange Server database connection settings page, enter the following information:
    FieldDescription
    Database Server

    The IP address or server name of the server where the database server is located.

    If you are installing AX Server on the same physical server as PostgreSQL, keep the default value of localhost unless you have a reason to change it.

    PortThe port to use to connect to the PostgreSQL database. The default port is 5432.
    SuperuserThe name of the PostgreSQL Superuser account. Leave the default value of postgres unless you have a reason to change it.
    PasswordThe password for the Super user account.

Configure the application service account and security

  1. In the Analytics Exchange Tomcat Service Account panel, do the following and click Next:
    1. Enter the domain and username for the account in the format domain\username.

      Depending on the version of Windows Server, the installer may include a Browse button for locating the required account. If you browse, you must enter or select the domain or server name first in the Browse for a User Account dialog box in order for the installer to present the appropriate list of available user accounts.

      Note

      Using a local user account to run the TomEE service is not supported. These accounts do not have the appropriate privileges to run some Analytics commands.

    2. Enter the Password for the account.
    3. Click Next.
    4. If you are prompted to grant the “Log on as a service” right to the Tomcat service account, click Yes and then OK.

    For information on the options for configuring service accounts, see Service account configuration.

  2. In the SSL certificate information page, enter the following information to create a self-signed security certificate to secure HTTPS connections to the AX Engine Node and then click Next:
    FieldDescription
    Server nameThe hostname of the database server. For example: ax.abc.com.
    Department or division nameThe division or business unit that the certificate is being issued for. For example: Development.
    Organization NameThe name of your company or organization. For example: ABC Corporation.
    City NameThe city or locality where your company or organization is located. For example: Vancouver.
    State/Province NameThe state or province where your company or organization is located. For example: BC.
    Country codeThe two-character country code for the country where your company or organization is located. For example: CA.
    Keystore password

    Enter a password of at least 6 characters.

    Note

    If you are using an existing keystore file, this instance of the Keystore password text box is disabled.

    Private key passwordEnter the same password again. The Keystore password and the Private key password must be identical.

    For information about how this certificate is used, and for configuration options, see Security certificates.

Finish the installation

  1. Click Install.

    Note

    Before the installation process completes you are required to wait for about a minute while the TomEE application server becomes fully functional. The command window may appear intermittently during this period. Do not cancel the installation.

  2. When the installation process is complete, click Finish to exit the installer.