---
title: Configuring BI solution (Smart Analytics) via Docker
slug: hyper-en/configuring-bi-solution-smart-analytics-via-docker
description: Learn how to install and configure CITSmart Analytics, a powerful business intelligence solution that seamlessly analyzes data from CITSmart. This document walks you through the step-by-step process of downloading and unzipping the required files, configu
docTags: 
createdAt: 2021-10-26T20:45:11.000Z
---

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

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

## Before getting started

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

## Procedure

### Installation

1. Download citBI in: ftp\://ftpgo.centralit.com.br/10104\_DIRETORIA\_DE\_SOLUCOES/PUBLICO/citBI/citbi-1.0.0/citbi-1.0.0.zip **and then unzip;**

2\. Enter the command and then unzip:

````Text
cd /citbi/files/
```sh
unzip storage.zip
```
command to build image

cd/citbi/

```
docker build -t registry.citsmartcloud.com/templates/bi .
```
````

3\. In the folder /citbi/composes, configure the database:

````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.citsmartcloud.com/templates/bi:latest
        environment:
    - BI_HOST=127.0.0.1
    - BI_DATABASE= citsmart_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
    ```
````

4\. In the folder /citbi/composes:

**Build and Start the 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/citsmart\_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="#3b9f0f">**CITSmart** </font>instance, it is necessary to configure the **parameters 401&#x20;**&#x61;nd **412**. To do so, access the main menu
&#x20;`Parametrization > CITSmart Parameters`;