In a recent Gartner survey, CIOs picked business intelligence and analytics as their top technology priority for 2012. The market research firm predicts that enterprises will spend more than $12 billion on business intelligence (BI), analytics and performance management software this year alone.
As the market for business intelligence solutions continues to grow, the open source community is responding with a growing number of applications designed to help companies store and analyze key business data. In fact, many of the best tools in the field are available under an open source license. And enterprises that need commercial support or other services will find many options available.
This month, we've put together a list of 50 of the top open source business intelligence tools that can replace proprietary solutions. It includes complete business intelligence platforms, data warehouses and databases, data mining and reporting tools, ERP suites with built-in BI capabilities and even spreadsheets. If we've overlooked any tools that you feel should be on the list, please feel free to note them in the comments section below.
Jaspersoft claims the title of "the world's most widely used business intelligence software." It offers Web-based reports, dashboards and analysis, and it supports cloud computing, mobility and big data. In addition to the free Community versions of its software, the company also offers paid Express, Professional and Enterprise editions. Operating System: OS Independent.
The Palo BI Suite brings together four open-source business intelligence tools: Palo OLAP Server, Palo Web, Palo ETL Server and Palo for Excel. Commercial solutions based on Palo can be purchased through Jedox. Operating System: OS Independent.
Claiming more than 10,000 users, Pentaho offers tools that provide data integration and analytics capabilities. The link above provides information about the commercial versions of the software; the open source downloads can be found at the Pentaho Community Wiki. Operating System: Windows, Linux, OS X.
SpagoBI boasts that it is "the only 100% open source, complete and flexible BI suite." It includes engines for reporting, multidimensional analysis (OLAP), charts, KPI, location intelligence, data mining, real-time dashboards, mobile, master data management, ETL and more . Operating System: OS Independent.
OpenI is "all about monetizing your data... in the quickest and most economic way." It offers open source dashboards, interactive reporting, ETL, predictive modeling and more. Operating System: OS Independent.
6. ERP BI
Designed for enterprises that use open source ERP systems including PostBooks and XTuple ERP, this project offers business intelligence tools that extend the capabilities of those ERP solutions. It's based on the community edition of Pentaho. Operating System: Windows, Linux, OS X.
Apatar focuses on integrating data from cloud-based and on-premise applications, which special features for CRM applications, including Salesforce.com, SugarCRM and Goldmine CRM. The company offers paid support, consulting, training, and other services, as well as an on-demand version of the software. Operating System: Windows, Linux.
8. Clover ETL
This data integration platform aims to "keep data in your business systems valuable, organized, and meaningful." They offer a range of commercial products based on the open source CloverETL Engine, which is available for download from SourceForge. Operating System: Windows, Linux, OS X.
Based on Kettle/Pentaho Data Integration, GeoKettle incorporates geospatial capabilities from a variety of other open source tools. It is owned by Spatialytics, which offers commercial versions of the tools. Operating System: Windows, Linux, OS X.
Java-based KETL is a portable, scalable ETL tool with support for many popular security and data management tools. Commercial support is available through project owner Kinetic Networks. Operating System: OS Independent.
Java-based Scriptella offers a simple tool for performing ETL tasks and executing scripts. Note that this tool isn't quite as polished as some of the others on our list, and no enterprise version or commercial support is available. Operating System: Windows, Linux, OS X.
Talend offers a range of open source data integration, data quality, MDM and big data solutions. In addition to the open source editions, it also offers products with a commercial subscription, as well as paid support, training and consulting. Operating System: Windows, Linux, Unix.