Install SpagoBI 5.0 (Business Intelligence Suite) on Linux

SpagoBI is 100% FREE open source business intelligence suite which helps many large organizations to analyze their reports. It offers wide range of analytical tools (More than 15 analytical tools are available to generate reports) which are not available in some of paid BI tools.

SpagoBI is an Open Source Business Intelligence suite and It offers a large range of analytical functions, a highly functional semantic layer which is not available in other open source platforms and projects, and a respectable set of advanced data visualization features including geospatial analytics.

What’s New in SpagoBI 5.0

  • Added ViewPoints support to Import Export procedure
  • Option to change the parameter values of cross navigation target doc
  • Option to save cockpit for future execute/edit
  • Admin user have rights to undo the modifications which has been made by other users
  • For, Full change log

SpagoBI Comes with fore Modules

  • SpagoBI Server
  • SpagoBI Studio
  • SpagoBI Meta
  • SpagoBI SDK

1) Prerequisites

Before proceeding to SpagoBI installation, check whether java (openjdk) has been installed in your system or not. If not, install it.

# java -version
java version "1.7.0_71"
OpenJDK Runtime Environment (rhel-2.5.3.2.el6_6-x86_64 u71-b14)
OpenJDK 64-Bit Server VM (build 24.65-b04, mixed mode)

2) Download SpagoBI 5.0

Download All in on SpagoBI pack because it has all the dependent packages which are necessary to run SpagoBI server.

# Download SpagoBI All in one pack #
# wget http://download.forge.ow2.org/spagobi/All-In-One-SpagoBI-5.0-01102014.zip

# Extract the zip file #
# unzip All-In-One-SpagoBI-5.0-01102014.zip

# Give executable permission to .sh files in /bin directory #
# cd ../SpagoBI-Server-5.0-16092014/bin
# chmod +x *.sh

# Give executable permission to .sh files in /database directory #
# cd ../SpagoBI-Server-5.0-16092014/database
# chmod +x *.sh

3) Modify server.xml file

Open server.xml file under conf directory (find 8080) and add your IP address instead of localhost to access the URL anywhere.

# Navigate to conf directory #
# cd ../SpagoBI-Server-5.0-16092014/conf
# nano server.xml
<Environment name="spagobi_service_url" type="java.lang.String" value="http://Your-IP:8080/SpagoBI"/>
<Environment name="spagobi_host_url" type="java.lang.String" value="http://Your-IP:8080"/>

4) Start SpagoBI

Navigate to bin directory and hit SpagoBIStartup.sh file and wait for 2-3 seconds, then try to access it.

# Navigate to bin directory #
# cd ../SpagoBI-Server-5.0-16092014/bin

# Start SpagoBI server #
# ./SpagoBIStartup.sh
or
# ./startup.sh

5) Access the SpagoBI on browser

Navigate your browser to http://Your-IP:8080/SpagoBI/. By default SpagoBI have three accounts. Try to log into any account and start playing with BI.
spagobi-5-0-release-notes-installation-steps-2

6) Administrator Login page

I logged into Administrator details. See the below screen shot for Administrator area.
spagobi-5-0-release-notes-installation-steps-1

7) Add SpagoBI in boot

It will automatically start SpagoBI when we switch on the system.

# Add SpagoBI in boot #
# crontab -e
@reboot /opt/SpagoBI-Server-5.0-16092014/bin/startup.sh

Magesh Maruthamuthu

Love to play with all Linux distribution

You may also like...