Configuring BI solution (Smart Analytics) via Docker

citsmart citsmart analytics is a solution of business intelligence (bi) for analyzing the data from citsmart citsmart the bi solution uses resources of the tools https //www meteorite bi/products/saiku reporting https //www meteorite bi/products/saiku reporting and 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 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 d verify log of container 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 docker ps 2\ verify inactive containers docker ps a 3\ stop container docker stop citbi 4\ remove container docker rm citbi what to do next to enjoy the benefits of bi in your citsmart citsmart instance, it is necessary to configure the parameters 401 and 412 to do so, access the main menu parametrization > citsmart parameters ;