ZSI

  • Updated on Jul 20, 2023
  • Published on Apr 11, 2022
  • 2 minute(s) read
  • Alexandre BATARD
  • Guilhem PREVOT
 Prev Next

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.