SpagoBI is the 100% open source, complete and flexible Business Intelligence suite.
SpagoBI is the 100% open source, complete and flexible Business Intelligence suite. Developed and supported by the SpagoBI Labs of Engineering Group, it provides full analytical capabilities, ranging from traditional reporting and charting features to innovative solutions for emerging domains, such as self-service cockpits, location intelligence, what-if analytics, social listening and real-time BI.
The SpagoBI charm requires a database (MySQL) and an Application server (Apache Tomcat) to function properly. The mysql and tomcat charms already have the installation and configuration done for you.
Use the following steps to set up SpagoBI:
juju deploy mysql juju deploy tomcat juju deploy spagobi juju add-relation spagobi tomcat *(This step installs SpagoBI in Tomcat)* juju add-relation spagobi:metadataddb mysql *(This step creates the database for SpagoBI)* juju expose tomcat
SpagoBI requires a database connection and will remain undeployed until the relation to MySQL exists. If the relation is removed or destroyed Tomcat will be shutdown, SpagoBI will be undeployed and the charm will wait for a new database connection.
It is important to wait for SpagoBI and Tomcat to finish starting before
accessing the web site. Use the
juju status command to see the status of
the deployments and to copy the IP address and http port of Tomcat.
Datasource on SpagoBI represents one database. Datasources could be added from SpagoBI application and also from juju using juju actions. To add datasource using juju actions firts thing is to create relation between spagobi and database server.
For mysql datasource:
juju add-relation spagobi:mysqlds mysql
For postgresql datasource:
juju add-relation spagobi:postgresqlds postgresql
For mongodb datasource:
juju add-relation spagobi:mongodbds mysql
For hive datasource:
juju add-relation spagobi:hiveds hive
For cassandra datasource:
juju add-relation spagobi:cassandrads cassandra
For hbase datasource:
juju add-relation spagobi:hbaseds hbase
Then create datasource for spagobi using juju action command:
juju action do spagobi/0 add-datasource unitname="<unit/number>" database="<database_name>" username="<username>" password="<password>"
parameters of the action are: unitname - to specify the unit that contains database, database - database name username and password- to access database