Hi Everyone,

Business intelligence can augment an ERP installation. This is especially true after an ERP has been in production for a couple of years and you have the resources to support and consume more complex reporting. SpagoBI is a good fit for ADempiere and iDempiere, open source ERP, because it is a collection of capable reporting products and it is a purely open source solution. All you need to do is apply know-how and best practices.

The purpose of this post is to offer a super quick installation script for SpagoBI for Ubuntu linux in AWS. You should use at least an AWS small server. The AWS medium is preferred because of memory usage.

    • sudo apt-get update
    • sudo apt-get –yes install unzip openjdk-6-jdk htop
    • wget http://download.forge.objectweb.org/spagobi/All-In-One-SpagoBI-4.1_16122013.zip
    • unzip All-In-One-SpagoBI-4.1_16122013.zip
    • chmod 766 SpagoBI-Server-4.1-16122013/bin/*.sh; chmod 766 SpagoBI-Server-4.1-16122013/database/*.sh
    • ./SpagoBI-Server-4.1-16122013/bin/SpagoBIStartup.sh

Give the server a couple of minutes to finish launching. Read the README.txt located in the base directory where you extracted the zip. The readme will tell you that you can access your spagobi instance at http://your.url:8080/SpagoBI.

I hope this helps!!

About Chuck Boecking: I am an ERP educator. I believe that open source ERP have achieved mainstream capabilities, and as a result, more companies can create greater efficiency across their organization. I started using the iDempiere code base in 2003. Back then, it was called Compiere. In 2006, I started my first multi-million dollar installation. Since then, ADempiere has helped me create great success with distribution and manufacturing companies all over the world. My vision of success is to find companies that can best use open source ERP to help them achieve a single, global instance that drives a discontinuous increase in profitability. I believe that organizations win when they own their technology.

If you have questions, comments or concerns, let me know. I definitely want your feedback.

You can contact me by phone using 512.850.6068.

My email is chuck@chuboe.com.

You can complete the form on this page.

Thank you for taking the time. I look forward to speaking with you.

Chuck Boecking



Leave a Reply

Your email address will not be published. Required fields are marked *