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
Before proceeding to SpagoBI installation, check whether java (openjdk) has been installed in your system or not. If not, install it.
- Oracle JAVA Installation in CentOS/Fedora/RHEL using rpm
- Oracle JAVA Installation in Ubuntu/LinuxMint/Debian using java alternative
- OpenJDK 7 installation in Ubuntu/LinuxMint/Debian
- Setting up JAVA Environment Variable in linux
- Remove Oracle Java and OpenJDK in Linux
- OpenJDK 8 installation in Ubuntu 14.10
# java -version java version "1.7.0_71" OpenJDK Runtime Environment (rhel-22.214.171.124.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.
6) Administrator Login page
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