Two additional open source BI offerings are worth considering. The first, the Eclipse Business Intelligence and Reporting Tools project, is primarily of interest to Java developers. The second, the Palo OLAP Server from German firm Jedox, develops enterprise technologies for Excel applications, targeting enterprise planning, analysis, reporting, and consolidation apps.
- Core software is free, and overall cost can be much lower than commercial packages
- Less vendor/platform lock-in risk
- Commercial products offer more capabilities and better support, and their software is more tuned to specific business or industry needs
- Eclipse BIRT, JasperSoft, Mondrian, Palo, Pentaho, SpagoBI, Talend
MCCA CIO Snyder similarly prioritized the ability to deliver critical BI capabilities over traditional ROI measures. The MCCA's JasperReports solution lets it segment and analyze data and generate advanced revenue metrics along multiple dimensions such as event, industry, and type of service provided. "We're pushing information and knowledge out to the end user, giving them access to what they want to see," Snyder says.
Will others take this leap to open source BI? Gartner projects triple the adoption by 2012, implying much faster growth than the overall BI market. BI is making progress, particularly when commercially packaged to deliver usability and support lacking with free components. As people like Snyder and Clazie push these tools out to employees, that packaging, coupled with open source's lower costs, will be critical to open source BI's enterprise success.
Seth Grimes is an analytics strategist with Alta Plana. He consults on data management and analysis systems.
Photo illustration by Sek Leung