Configuring BI solution (Smart Analytics) via Docker

12min
﻿4biz Analytics is a solution of Business Intelligence (BI) for analyzing the data from 4biz. The BI solution uses resources of the tools Saiku Analytics and Pentaho.
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 here and then unzip;
Enter the command and then unzip:
Dockerfile
cd /citbi/files/

 sh
   unzip storage.zip    
cd /citbi/files/

 sh
   unzip storage.zip    
﻿
Command to build an image
Dockerfile
 cd/citbi/
 
 docker build -t registry.4bizcloud.com/templates/bi .
 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
    vi /citbi/composes/
    [docker-compose.yml](/citbi/src/master/composes/docker-compose.yml)
﻿
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.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
    ```
    ```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
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/4biz_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 4biz instance, it is necessary to configure the parameters 401 and 412. 
To do so, access the main menu
 Parametrization > 4biz Parameters;
Did this page help you?
Smart Analytics
Using Smart Analytics (BI) to generate reports