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:metadatadb 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.
Juju has created the virtual servers, installed the software, created the database, deployed the web application and connected these services for you. To access SpagoBI web site interface browse to: http://tomcat-host:port/SpagoBI Replace "tomcat-host" with the public IP address from 'juju status' command. Replace "port" with the http_port of the Tomcat charm. To connect to different datasoources for the data analysis use SpagoBI web interface or juju actions as it is described below.
Datasource on SpagoBI represents one database. When the database is configured and ready to be analized by SpagoBI the datasource need to be added to SpagoBI. To add datasource using juju actions firts thing is to create relation between spagobi and server where the database is located.
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
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