Introduction to the existing Java open-source Bi front-end framework

Existing Java open-source Bi front-end framework

I recently demonstrated the open-source Bi front-end framework in the Java field and shared some things I remember.
Because I only watched it for a few days and didn't have time to sort it out, it looks messy and not very thorough.

Currently, common bi front-end frameworks (Business Intelligence projects) in the Java field mainly include the following open-source frameworks such as pentaho, spagobi, openi, and Jasper intelligence.

 

They all have their own strengths and weaknesses. The following is a brief introduction:

Lightweight:

OpeniUsing the Mondrian and July frameworks, the Report Engine is Jasper Report, and the data mining interface is r-project,

Development and learning are relatively simple, and openi supports Ms Data Warehouse (xmla), but its internationalization fails (Chinese garbled characters) and needs to be improved in depth.

 

Jasper intelligenceIt is also a lightweight project with the best support for Jasper report, so the report part is better.

 

Heavyweight:

Pentaho,SpagobiIs two relatively large frameworks, integrated with a considerable number of open-source projects, jfreereport, Mondrian, kettle, WEKA are basically used. It is particularly suitable for the development of large-scale and complex projects.

PentahoIn China, there are a lot of users and more documents. In particular, it is worth mentioning that on the Internet his Chinese support is quite good, and many volunteers have translated its documents. This makes development very convenient.

 

PentahoModule workflow engine, central resource library, audit component, report design tool, ETL tool, OLAP Server, multi-dimensional display, and data mining components.

AndPentahoWith great investment, great development effort, and paid official releases.

 

Http://blog.csdn.net/dust_bug/archive/2006/09/18/1240753.aspx

This is pentahoSource codeRead the report to introduce the pentaho architecture in a comprehensive manner.

 

PentahoThe Chinese forum in http://www.bipub.org/

 

PentahoCompared with spagobi, spagobi has a strong function, especially when a workflow is executed.

Official station demos in http://www.pentaho.com/products/demos/

 

Spagobi is also very powerful, especially the latest release of 1. 9 version, in http://spagobi.eng.it: 8080/sbiportal/faces/public/exo (or http://spagobi.eng.it: 8080/sbiportal)

DemosSpagobiMany features.

Postscript

These Bi frameworks are open-source front-end frameworks, so some open-source projects are used in the core part,

Mondrian, July, jfreereportTherefore, setting up a suitable framework will take a lot of time for the project. However, once the framework is set up, the report can be generated like a pipeline.

However, it is troublesome to add Performance functions to the original functions. It may take a long time to implement a new function.

In addition, the permission management of these open-source frameworks is not very strong and may need to be modified.

In addition, global speaking is also a problem. Similar to openi, it does not support Chinese characters and must be modified.