From pentaho to jaspersoft

From pentaho to jaspersoft

Because of infobright, I know pentaho and jaspersoft, because infobright provides virtual machines that match them, and people are lazy. What's more, I am obsessed with using virtual machines. So I first boarded pentaho's one-piece ship, and now I am still wandering in jaspersoft, a ghost ship that I don't know if I can get to my head.

On the infobright website, we describe these two partners as follows:

Pentaho:

Pentaho Corporation provides a full spectrum of specified cial Open Source Business Intelligence (BI) capabilities including reporting, analysis, dashboards, data mining, data integration, and a bi platform that have made it the world's most popular open source
Bi suite.

Jaspersoft:

Jaspersoft's Open Source Business Intelligence suite is the world's most widely used Bi software, with more than 8 million total downloads worldwide and more than 10,000 faster cial MERs in 96 countries. the company's jaspersoft Business Intelligence
Suite provides a web-based, open and modular approach that address the next generation business intelligence needs of the enterprise. jaspersoft's software is rapidly updated by a community of more than 90,000 registered members working on more than 350 projects,
Which represents the world's largest business intelligence community.

The general idea is that pentaho is the world's most popular open-source Bi (Business Intelligence) suite, while jaspersoft is the world's most widely used Bi software. Although I don't know what the difference between "Most Popular" and "most widely used" is, even though I know that my intuition is often inaccurate, I chose pentaho based on my intuition, as my first bi attempt. I think that pentaho, which emphasizes Bi suite and Bi platform, is more powerful than jaspersoft, which emphasizes software. It may only be because pentaho ranks higher than jaspersoft on the download menu of infobright.org. However, my heavy experience once again proves that being large is not as powerful as being small. It is better to focus on details.

So I first downloaded the infobright + pentaho virtual machine, decompressed the package, and started VMware to use it. I still provide a web-based service, and I can experience it immediately, with a great sense of accomplishment. In fact, we still encountered some minor problems, mainly in terms of network and access permissions. We set VMware's network connection to host-only, and refer to readme In the compressed package, there are basically no major problems.

After a bit of fun, I thought it was fun to go deep into the code and try again to build the code. So I ran to this page to start downloading. Don't be confused. A web-based bi kit usually includes several parts: A web service, a report designer, and data aggregation and conversion (ETL ). The Service Platform: business must be downloaded.
Intelligence server also downloads the report designer for report design. You don't need to worry about the others. These two are enough.

After a period of use, I feel exhausted. Business Intelligence is a low technical threshold for enterprise users, however, it is very important to have a detailed user manual or receive training courses from the software provider. Otherwise, it will be difficult for a person to explore. Pentaho's report design software report designer has many bugs. I don't know if this is the case for the Windows version, but the Linux version is really a matter of patience. In the end, I had no idea how to deal with it, not to mention the other data integration and metadata editor suites that seem to be more powerful.

Pentaho's Web interface looks more user friendly, but it is not the case at all. Comparatively speaking, jaspersoft's Web interface is more engineer-oriented, which makes people feel a heavy sense. Jaspersoft also provides more official documents than pentaho. Although both documents are earlier versions, jaspersoft even has some Chinese documents.

Here, the jaspersoft suite list is mandatory for jasperserver, which is embedded with jasperreports and jasperanalysis. The former is a report system and the latter is a data cube analysis system. Jasport is the client software for report production, and jasperetl is an essential data integration tool in business intelligence software. The related documentation is version 3.5. You can download the installation package and documentation here.

You can install it by referring to the documentation. You may need to create some databases, which should be smooth. After installation, start the service in the installation directory and access the service through the Web. Some conceptual issues are described as follows:

Several steps are required to create a Jasper analysis:

1. A data source needs to be created, which is equivalent to defining a data source. All operations will be performed on this data source;
2. A data schema is required, which is a data definition file in XML format. It defines the tables and table connections required in data source;
3. Create a data connection, which is a query connection of the data cube. Select the appropriate data source and data schema here;
4. Finally, create an analysis view. Here, select a data connection and define an MDX query statement. The MDX query statement determines what the data cube will look like.

It should be noted that several examples provided by jaspersoft are also of great reference value when defining data pipeline. After an analysis view is defined, you can perform operations such as drilling, sorting ting, filtering, and visualizing. For details, see the document jasperanalysis-user-guide.pdf.

Another major feature of jaspersoft is report generation. The common practice is to first use the client software ireport to make a report and then synchronize it to the server to perform real-time queries on the server or to develop real-time tasks, periodically run the task and send the report to the specified mailbox. There are not many documents in this document, so I have to find more information. Some simple instructions can be obtained from jasperserver-user-guide.pdf. A report can include data sources, controls, custom parameters, charts, and so on. If you have a wealth of documents and have patience, you can make beautiful reports. Because I am not a designer, I prefer coding practices. In design, I only need to make usable reports, so there is not much depth in this aspect.