In this information age, every minute produces huge amounts of data per second. In the massive data, it is very important to dig out useful data and to display the data in a more humane and intuitive way. This article will introduce 7 top open source BI (business Intelligence) software and reporting tools for the analysis and processing of business data, and hope to help you.
Birt
BIRT (Business Intelligence and Reporting Tools) is an Eclipse-based reporting system that was open-source by IBM in 2004 and is primarily used on Java-and EE-based Web applications. Birt consists of two main parts: an Eclipse-based report design and a run-time component that can be added to your app service. Birt also provides a graphical report making engine.
Get Address: http://www.eclipse.org/birt/
Seal Report
Seal report is a production statement and an open database Kanban framework, using Microsoft. NET Framework, written in C #. The main features are as follows:
- Supports dynamic SQL query data.
- Support local pivot tables, arbitrarily modify table elements, the pivot table will immediately follow the new layout to recalculate the data.
- Supports fast generation of Web page diagrams via HTML 5.
- Hierarchical navigation and hierarchical reporting can be generated.
- Support timed tasks, can write batch processing, timed to perform some data loading, processing, backup and other operations.
- Lower TCO (total cost of ownership).
- provides Web Reporting Services.
Get Address: Https://github.com/ariacom/Seal-Report/archive/master.zip
JasperReports
JasperReports is a Java-developed open source reporting tool that can produce reports in the Java environment like other IDE reporting tools. JasperReports supports PDF, HTML, XLS, CSV, and XML file output formats. JasperReports is the most commonly used reporting tool for Java developers today.
Get Address: Http://community.jaspersoft.com/download
ReportServer
ReportServer is a Java-developed BI platform that supports Linux, OS X, Windows three platforms, and runs on application servers such as Apache tomcat,wildfly, allowing Excel, Word, and multidimensional OLAP to display report information.
Get Address: https://reportserver.net/en/download/
Pentaho
Pentaho is a workflow-centric BI suite that emphasizes solution-oriented rather than tool components, consolidating multiple open-source projects with the goal of competing with business bi. It favors BI solutions that are combined with business processes, focusing on medium to large enterprise applications. It allows business analysts or developers to create reports, dashboards, analysis models, business rules, and BI processes.
Features and Features
Workflow engine: Shark and JaWE
Database: Firebird RDBMS
Integrated management and development environment: Eclipse
Reporting tools: Eclipse BIRT
ETL Tool: Enhydra/kettle
OLAP Server:mondrian
OLAP Show: JPivot
Data Mining components: Weka
Application Server and Portal Server: JBoss
Single sign-on service and LDAP authentication: Josso
Custom scripting support: Mozilla Rhino JavaScript script processor
Get Address: http://www.pentaho.com/download/
SpagoBI
SpagoBI provides a Java EE-based framework for managing BI objects such as reports, OLAP analysis, dashboards, scorecards, and data mining models. It provides the BI manager with the ability to control, verify, validate, and distribute these BI objects. SpagoBI features include support for portal, report, OLAP, QbE, ETL, Dashboard, document management, meta Data management, data mining, and geo-information analysis.
Get Address: http://forge.ow2.org/project/showfiles.php?group_id=204
Knime
Knime (Konstanz information Miner) is a user-friendly, intelligent, and abundant open source data integration, data processing, analysis and data exploration platform. It gives the user the ability to visually create a data stream or data channel, optionally running some or all of the analysis steps, with later research results, models, and an interactive view. Knime is written in Java and provides more functionality based on Eclipse and plug-ins. With plug-in files, users can add processing modules to files, images, and time series, and can be integrated into various other open source projects such as: R language, Weka, Chemistry development Kit, and LIBSVM.
Get Address: Https://www.knime.org/downloads/overview
The above introduction of the 7 BI software and reporting tools, the difference, in the actual production, but also need a lot of comparison trial, the right is the best.
http://my.oschina.net/drenerd/blog/702821
7 Top Open Source BI (business Intelligence) software and reporting tools