Review: For ERP, Is It Time To Applaud Openbravo?

Think of any proprietary platform, and there is an open-source alternative, whether it's an operating system or a database, or even, yes, an ERP system. Enterprise resource planning software is used for operational planning, including managing orders, inventory, accounting, and logistics. Long dominated by industry giants Oracle and SAP, ERP deployments are generally associated with the large enterprise. Open source ERP systems bring the technology within reach of the small and midsize enterprises, and all the way down to the small business.

There are a handful of open source ERP solutions that can be considered business-ready --- thorough documentation, extensive technical and customer support, and a regular release schedule. Openbravo ERP, from Spanish company Openbravo is one. The Test Center deployed the Web-based ERP and discovered a fully functional system that supports procurement and warehouse management, project and service management, production management, and financial management. It also supports BI and CRM. Designed for the SME, Openbravo ERP is flexible, scalable, and affordable.

A big concern about open source has always been about interoperability: would it work with what's already in production? Openbravo ERP eases those concerns somewhat, supporting both proprietary Oracle (10g) and open source PostgreSQL databases. Openbravo ERP is Java-based and requires several Apache products. At this point, Microsoft-centric customers with SQL Server databases, .NET framework, and IIS, won't be feeling the Openbravo love, but they are probably looking at Microsoft Dynamics ERP, anyway. However, Openbravo does run on servers running Microsoft Windows XP, 2000, 2003 Server.

Openbravo is different from other open-source ERP in that its interface is entirely Web-based. The user can view production information, inventory, customer information, order tracking, and workflow information all from a Web browser. This simplifies access, since authorized users don't have to wait for special client software to be installed on their computers. As most Web applications, the interface is intuitive and menu options are easily accessible. Various management options are organized as menus, such as sales, procurement, and production. Clicking on the option opens up all the associated tasks in a drop-down. For example, transactions such as sales and shipment orders are accessible under the Sales Management menu. Each task window is icon-driven, and the icons are pictorially easy to understand. Reports are easy to create and there are several templates, as well as the ability to create customized ones. The reports and data can be exported to Microsoft Excel or saved as PDF.

Openbravo spent a lot of time designing the architecture the ERP is constructed on. The metadata-driven engine is based on a 2002 version of another open-source ERP project, Compiere. Openbravo improved upon the engine, and consists of only 10 percent of the code base, according to the company's Web site. The entire system is constructed on two development frameworks: the Model-View-Controller and Model-Driven-Development. Under MVC, data is manipulated by controllers, not directly by the user. By referencing a data model dictionary, the application engine can automatically recompile and rebuild whenever the administrator makes a change. And MDD allows models of code for user-created code. These two models simplify integration with other programs.

Deploying Openbravo ERP requires getting all the supporting applications installed and configured first. Test Center used a Debian 4.0r3 Etch server. Openbravo has been tested on other Linux flavors as well, including Red Hat Enterprise Linux, CentOS, Novell SUSE, Canonical's Ubuntu and Fedora. The testing server already had the latest Java and Ant installed; solution providers would have to remember to install them beforehand. Ant is an Apache software tool that automates software builds for Java files (similar to make).

Because it's a Java-based application, Openbravo also requires Tomcat, an Apache Web container that specifically handles Java Servlet and JSP. For the database backend, PostgreSQL was installed on the test server.

Once the individual components are in place, the actual Openbravo ERP installation is script-driven. Openbravo is distributed with all source code developed by Openbravo and few third-party libraries. The script requires information about the database server, such as IP address, username, and port, and about the system, such as the Web URL. Once the script completes, the Openbravo ERP is accessible by pointing the browser to the specified URL.

Next: Openbravo Works For System Integrators