Configuring BI solution (Smart Analytics) via Docker
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:
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
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:
docker-compose up -dVerify Log of Container:
docker logs -f citBI
Configuration
- 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:
docker ps2. Verify inactive containers:
docker ps -a3. Stop container:
docker stop citBI4. Remove container:
docker rm citBIWhat 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;