Installation

The latest version can be downloaded from https://biexcellence.com.

The installation files should always be stored locally on the server. Execute the following steps for the installation.

Windows

  1. Start the OpenBiRepositoryServerInstaller.exe image.png
  2. Click on Options to configure the installation location. The default location is C:\OPENBI. image.png
  3. Click on Install to start the installation. image.png

The installer also installs Microsoft SQL Server LocalDB and .NET Hosting Bundle automatically if it does not already exists.

The installer creates a Windows Service entry named open bi Repository Server (OpenBIServer). The startup type is set to Manual by default and it is recommended to change it to Automatic. image.png

Start

There are two ways to start the open bi server:

  1. Start the Windows Service, which is the recommended way.
  2. Run OPENBI\ibssolution.bioxRepository.exe as administrator. This is useful to debug any startup errors.

These don't work at the same time, make sure to stop the Windows Service or Console before starting the server the other way.

Firewall

Make sure to open the desired ports in the Windows Firewall so the open bi server can be accessed from outside as well.

Update

After updating the open bi server it is neccessary to check the Windows Service entry again, e.g. the startup type would be reset to Manual and the logon information might got reset.

Linux

  1. Install Microsoft SQL Server if an existing one is not available.
  2. Create a database.
sqlcmd -S localhost -U sa -P 'XXX' -C

CREATE DATABASE [openbi]
GO
  1. Extract open bi server and make sure ibssolution.bioxRepository is executeable.
chmod +x ibssolution.bioxRepository
  1. Add CONNECTION_STRING parameter to the Configuration.xml file.
<Parameter>
  <Name>CONNECTION_STRING</Name>
  <Value>Server=(local);UID=sa;PWD=XXX;Database=openbi;TrustServerCertificate=True;</Value>
</Parameter>

Start

Run ./ibssolution.bioxRepository to start the open bi server.