Configuring BI solution (Smart Analytics) via Docker

9min
﻿CITSmart Analytics is a solution of Business Intelligence (BI) for analyzing the data
 from CITSmart. The BI solution uses resources of the tools  Power Bi and Data Studio.
It is possible to have BI in your environment using the container structure of
 Docker, following the installation configuration.
Before getting started
The user must have Docker previously installed.
Procedure
Installation
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 .
```
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:
Text
    ```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
    ```
    ```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
docker-compose up -d
﻿
Verify Log of Container:
Text
docker logs -f citBI
docker logs -f citBI
﻿
﻿
Configuration
Access the Saiku as a manager﻿ http://127.0.0.1:8282/﻿﻿
Add the Schema available on, /citbi/src/master/files/SchemaEnglish.xml
Add DataSource: jdbc:postgresql://127.0.0.1:5432/citsmart_equipeteste_equatorial
Useful commands: box
Verify active containers:
Text
docker ps
docker ps
﻿
2. Verify inactive containers:
Text
docker ps -a
docker ps -a
﻿
3. Stop container:
Text
docker stop citBI
docker stop citBI
﻿
4. Remove container:
Text
docker rm citBI
docker rm citBI
﻿
What to do next
To enjoy the benefits of BI in your CITSmart instance, it is necessary to configure the parameters 401 and 412. To do so, access the main menu
 Parametrization > CITSmart Parameters;
Smart Analytics
Using Smart Analytics (BI) to generate reports