ZSI
    • 20 Jul 2023
    • 2 Minutes to read
    • Contributors
    • Dark
      Light

    ZSI

    • Dark
      Light

    Article summary

    Installation

    The ZSI module contains the BI Tool. The BI Tool and all the associated assets must be installed with the Zetaly Installer. For more information about the Zetaly Installer, see Zetaly Installer.

    The installation comprises:

    • BI Tool installation
    • BI configuration (SSO, plugins, specific configuration, etc.)
    • Elasticubes importation
    • Dashboards importation
    The installation can take more than one hour.

    Requirements

    • Windows Server 2008 R2 and later
    • RAM : 32 GB minimum.
      Note: Can vary according to your needs. See with your Zetaly commercial representative to get an estimation. 
    • Storage : 1 To minimum.
      Note: Can vary according to your needs. See with your Zetaly commercial representative to get an estimation. 
    • Machine ID consistent with the one used to generate your BI license
    • Certificate (self or publically signed) generated for the host machine
    • BI port open (usually 8081, can be configured) 
    SSL activation
    For a first installation, the Zetaly Installer is unable to configure the SSL automatically. You must manually SSL by following the SSL Configuration article.

    To install the BI Tool, enter the following command:

    ./zetalyinstall.ps1 BI

    Once the installation is complete, launch the Windows Services Console, and check that all the services named Sisense.* are running.

    Update BI Tool Protocol to https (versions 2022-11 and Lower Only)

    As of Zetaly version 3.0-R2022-11, using the BI Tool with the http protocol is no longer supported. Switching to https is possible by two methods: 

    • Completely un-installing and re-installing the BI Tool : easiest, at the cost of losing all data
    • Reconfiguring the existing BI Tool : easy, by following the next procedure

    Hereafter are the steps to reconfigure the BI tool to be accessed via https.

    Requirements

    • Zetaly package version 2022-11 or above
    • Certificates of the machine where the BI Tool is installed, in a folder named Secrets (a .crt and a .key file are expected). The certificates can be self-signed.

    Steps

    Update the BI Tool and Zetaly database, as follows:

    1.  Extract the package and configure the properties in the zetalyinstall.cnf file as usual.
      Note: Since only https is now possible for the BI Tool, the property BI.Protocol no longer exists.
    2.  Place the Secrets folder at the root of the extracted package.
    3.  Update the BI Tool, Backend, Frontend, and Zetaly database by entering the following command:
      ./zetalyinstall.ps1 BI BackAndFront Database-update
      This is command updates the BI Tool installation, and all the modules that use it. This is command also updates the Zetaly database, which is mandatory during a BI Tool version update.

    Once the BI Tool and Zetaly database are updated, do the following:

    1.  On the machine hosting the BI Tool, access the BI Tool administrator interface at http://localhost:3030 .
      1. Enable SSL. 
      2.  Select the CERT-KEY radio button, and upload the .crt file and .key file from the Secrets folder for the CERT File and Key File, respectively.
    2. Access the main BI Tool interface at http://<BI machine IP>:8081, and login with an admin account. Select the Admin tab located at the top-right.
      1.  In the User Management > Single Sign On section, change the Remote Login URL to https.
      2. In the System Configuration > Security Settings section, set Support Cross Site Cookies for Embedding to None.
    3. Restart the BI Tool services for the changes to take effect.
      1. On the machine hosting the BI Tool, access the BI Tool administrator interface at http://localhost:3030
      2. In the System Configuration section, click Restart Services. 
    4.  Confirm that the process worked
      1. Access the main BI Tool interface at new secure address at https://<BI machine IP>:8081.
      2. Accept the installed certificate.
      3. Login with an admin account.

    What's Next
    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.