---
title: Configuring BI solution (Smart Analytics) via Docker
slug: hyper-en/configuring-bi-solution-smart-analytics-via-docker
description: Looking to install and configure citBI solution, a powerful Business Intelligence (BI) tool for analyzing data from 4biz? This document provides step-by-step instructions, including downloading and unzipping citBI files, configuring the database, and veri
createdAt: 2021-10-11T14:43:58.000Z
---

****<font color="#ff6900">**4biz** </font>**Analytics&#x20;**&#x69;s a solution of **Business Intelligence** (BI) for analyzing the data from <font color="#ff6900">**4biz**</font>. The BI solution uses resources of the tools [Saiku Analytics](https://www.meteorite.bi/products/saiku-reporting) and [Pentaho](https://www.hitachivantara.com/go/pentaho.html).

It is possible to have BI in your environment using the container structure of Docker, following the installation configuration.

## Before getting started

- [x] The user must have Docker previously installed.

## Procedure

### Installation

- Download citBI in [here](ftp://ftpgo.4biz.com.br/10104_DIRETORIA_DE_SOLUCOES/PUBLICO/citBI/citbi-1.0.0/citbi-1.0.0.zip) and then unzip;
- Enter the command and then unzip:

```dockerfile
cd /citbi/files/

 sh
   unzip storage.zip    
```

Command to build an image

```dockerfile
 cd/citbi/
 
 docker build -t registry.4bizcloud.com/templates/bi .
```

- In the folder /citbi/composes, configure the database:

```dockerfile
sh
    vi /citbi/composes/
    [docker-compose.yml](/citbi/src/master/composes/docker-compose.yml)
```

````sh
    ```sh
    vi /citbi/composes/
    [docker-compose.yml](/citbi/src/master/composes/docker-compose.yml)
    ```
    
    i (enter)

    ```java
    version: '2'
    services:
      citBI:
        container_name: citBI
        image: registry.4bizcloud.com/templates/bi:latest
        environment:
    - BI_HOST=127.0.0.1
    - BI_DATABASE= 4biz_equipeteste_equatorial
    - BI_PORT=5432
    - BI_USER=root
    - BI_PASSWORD=1
    - BI_LANGUAGE=pt-br
    - URL_SAIKU=http://localhost:8282
    volumes:
    - /citbi/files/home:/home
    ports:
    - 8282:8282
    - 8085:8085
    ```

    Ctrl+C

    :wq!
    
    Check:

    ```
    cat /citbi/composes/docker-compose.yml
    ```
````

- In the folder /citbi/composes:

### Build and Start Container:

```Text
docker-compose up -d
```

### Verify Log of Container:

```Text
docker logs -f citBI
```

### Configuration

1. Access the saiku as a manager: [[http://127.0.0.1:8282/](http://127.0.0.1:8282/)](http://127.0.0.1:8282/)
2. Add the Schema available on: **/citbi/src/master/files/SchemaEnglish.xml**
3. Add DataSource: **jdbc\:postgresql://127.0.0.1:5432/4biz\_equipeteste\_equatorial**

### Useful Commands: Box

1. Verify active containers:

```Text
docker ps
```

2\. Verify inactive containers:

```Text
docker ps -a
```

3\. Stop container:

```Text
docker stop citBI
```

4\. Remove container:

```Text
docker rm citBI
```

## What to do next

To enjoy the benefits of BI in your <font color="#ff6900">**4biz** </font>instance, it is necessary to configure the **parameters 401&#x20;**&#x61;nd **412**.&#x20;

To do so, access the main menu
&#x20;`Parametrization > 4biz Parameters`;