Fabric BI Docker Installation

Introduction

The Fabric BI application is based on ExagoBI. So, the installation of Fabric BI starts from ExagoBI application installation. Once the application is installed, complete the configuration and implementation by following all the steps described in the Fabric BI User Guide.

Prerequisites

When you have Fabric and/or PostgreSQL server running on a docker on your local machine (Windows or MAC), use docker compose to join all containers in the same network based on Docker Installation instructions below or do one of the following:

  • Use the Docker GW:
    • On Linux - trough the Docker0 interface.
    • On Windows - trough the WSL network interface.
    • Not available for MAC.
  • Install the PostgreSQL locally to use it for Storage Management DB.
  • Keep the default SQLite as Storage Management DB. Note that the default SQLite DB can be used for demo or training purposes only.

Docker Installation on Linux / Windows / OSX

  1. Download the Docker image (D_k2view_BI_v2021.1.15.tar.gz) from here.

  2. Import the image using the following command:

   docker load -i D_k2view_BI_v2021.1.15.tar.gz
  1. Start the Docker image as follows:
   docker run -dt --name=exago -p 80:80 k2view/exagobi:2021.1.15

where exago is the docker name (you can define a different name if needed).

If you need to use a different port (for example, when the port 80 is already in use) - see the notes below.

  1. Update the WebReportsApi.xml file with the Container host IP:

    • Copy the WebReportsApi.xml from the container:
   docker cp exago:/opt/apps/exago/WebServiceApi/Config/WebReportsApi.xml .
  • Edit the file with a text editor, update the URL with the host IP or DNS name:
   <webreportsbaseurl>http://127.0.0.1/Exago</webreportsbaseurl>

Replace {127.0.0.1} with the actual IP or DNS name.

  • Copy the file back to the container.
   docker cp WebReportsApi.xml exago:/opt/apps/exago/WebServiceApi/Config/WebReportsApi.xml

In Linux environment, you can use the following script to automate the process. Download the Docker Configuration Script (for Linux) from here.

   ./docker_config.sh {Container Name} {IP Address}|{Host Name}| {leave blank}
 * docker name: name of the running Exago container.

 * IP Address: container assigned IP or host local IP.

 * Host Name: container assigned Host Name.

 * To set IP automatically, leave the second variable **blank**.

Continue to other installation and configuration steps described in the User Guide Installation article.

Notes

  1. If it is needed to connect to an existing network, use the "--network='network name' " option.

  2. To use a different port rather than 80, do the following:

    • Start the docker as follows:
     docker run -dt --name=exago -p <your port>:80 k2view/exagobi:2021.1.15
    
    • Update the WebReportsApi.xml file with the same port number.

    • In Linux environment, add the port number to the command:

     ./docker_config.sh {Container Name} {IP Address : Port}|{Host Name}| {leave blank}
    
  3. To manage the Apache and fastCGI services within the docker:

   docker exec exago service apache2 start|restart|stop|status
   docker exec exago bash -c "/opt/apps/exago/fastcgi.sh start|restart|stop|status

Directory Locations

Application Binaries /opt/apps/exago/bin
API for Exago Web Service /opt/apps/exago/WebServiceApi
3rd Party’s Utilities /opt/apps/exago/Utilities
3rd Party’s Drivers /opt/apps/exago/Drivers
Personalization Configuration/opt/apps/exago/Config
Exago Report Scheduler /opt/apps/exago/Scheduler

Fabric BI Docker Installation

Introduction

The Fabric BI application is based on ExagoBI. So, the installation of Fabric BI starts from ExagoBI application installation. Once the application is installed, complete the configuration and implementation by following all the steps described in the Fabric BI User Guide.

Prerequisites

When you have Fabric and/or PostgreSQL server running on a docker on your local machine (Windows or MAC), use docker compose to join all containers in the same network based on Docker Installation instructions below or do one of the following:

  • Use the Docker GW:
    • On Linux - trough the Docker0 interface.
    • On Windows - trough the WSL network interface.
    • Not available for MAC.
  • Install the PostgreSQL locally to use it for Storage Management DB.
  • Keep the default SQLite as Storage Management DB. Note that the default SQLite DB can be used for demo or training purposes only.

Docker Installation on Linux / Windows / OSX

  1. Download the Docker image (D_k2view_BI_v2021.1.15.tar.gz) from here.

  2. Import the image using the following command:

   docker load -i D_k2view_BI_v2021.1.15.tar.gz
  1. Start the Docker image as follows:
   docker run -dt --name=exago -p 80:80 k2view/exagobi:2021.1.15

where exago is the docker name (you can define a different name if needed).

If you need to use a different port (for example, when the port 80 is already in use) - see the notes below.

  1. Update the WebReportsApi.xml file with the Container host IP:

    • Copy the WebReportsApi.xml from the container:
   docker cp exago:/opt/apps/exago/WebServiceApi/Config/WebReportsApi.xml .
  • Edit the file with a text editor, update the URL with the host IP or DNS name:
   <webreportsbaseurl>http://127.0.0.1/Exago</webreportsbaseurl>

Replace {127.0.0.1} with the actual IP or DNS name.

  • Copy the file back to the container.
   docker cp WebReportsApi.xml exago:/opt/apps/exago/WebServiceApi/Config/WebReportsApi.xml

In Linux environment, you can use the following script to automate the process. Download the Docker Configuration Script (for Linux) from here.

   ./docker_config.sh {Container Name} {IP Address}|{Host Name}| {leave blank}
 * docker name: name of the running Exago container.

 * IP Address: container assigned IP or host local IP.

 * Host Name: container assigned Host Name.

 * To set IP automatically, leave the second variable **blank**.

Continue to other installation and configuration steps described in the User Guide Installation article.

Notes

  1. If it is needed to connect to an existing network, use the "--network='network name' " option.

  2. To use a different port rather than 80, do the following:

    • Start the docker as follows:
     docker run -dt --name=exago -p <your port>:80 k2view/exagobi:2021.1.15
    
    • Update the WebReportsApi.xml file with the same port number.

    • In Linux environment, add the port number to the command:

     ./docker_config.sh {Container Name} {IP Address : Port}|{Host Name}| {leave blank}
    
  3. To manage the Apache and fastCGI services within the docker:

   docker exec exago service apache2 start|restart|stop|status
   docker exec exago bash -c "/opt/apps/exago/fastcgi.sh start|restart|stop|status

Directory Locations

Application Binaries /opt/apps/exago/bin
API for Exago Web Service /opt/apps/exago/WebServiceApi
3rd Party’s Utilities /opt/apps/exago/Utilities
3rd Party’s Drivers /opt/apps/exago/Drivers
Personalization Configuration/opt/apps/exago/Config
Exago Report Scheduler /opt/apps/exago/Scheduler