Enroll Now!!! and get 10% special Discount on all courses. Limited Time only!!!

Pentaho Introduction | Features and Architecture of Pentaho

Last updated on Tue 17 Mar 2020


Pentaho is one ETL tool which is growing big day-by-day. Learn all about pentaho and its architecture and features at IQ Online Training.


Pentaho Data Integration:

Pentaho Data Integration (PDI) also called as Kettle. It is the component of Pentaho which is responsible for Extracting, Transforming and Loading (ETL) processes. ETL tools are maximum often utilized in information warehouses environments.

  • PDI also can be used for other purposes:
  • Migrating data among programs or databases
  • Exporting statistics from databases to flat documents
  • Loading statistics massively into databases
  • Data Cleansing
  • Integrating programs

PDI is simple to apply. Every technique is created with a graphical tool in which you specify what to do without writing code to signify the way to do it; because of this, you can say that PDI is metadata oriented.

PDI can be used as a standalone utility, or it is able to be used as a part of the larger Pentaho Suite. As an ETL tool, it's miles the maximum popular open supply tool available.

PDI helps a considerable array of input and output formats, such as textual content documents, records sheets, and business and free database engines. Moreover, the transformation abilities of PDI can help you control records with only a few limitations.

Pentaho Reporting:

Pentaho Reporting is a collection for creating relational and analytical reporting. Using Pentaho, we are able to rework complex records into meaningful reports and draw statistics out of them. Pentaho supports creating reports in various formats which includes HTML, Excel, PDF, Text, CSV, and XML.

Pentaho can receive statistics from extraordinary statistics resources inclusive of SQL databases, OLAP records resources, and even the Pentaho Data Integration ETL device.

Prerequisites of Pentaho:

  • Understanding the concepts of database and data warehousing.
  • Familiarity with any programming languages like Java, C++, and basics of object-oriented programming
  • Knowledge of Linux and UNIX can be beneficial.

Features of Pentaho:

  • Data integration
  • Business Analytics
  • Big Data Analytics
  • Embedded Analytics
  • Cloud Analytics
  • Ad Hoc Analysis
  • Online Analytical Processing (OLAP)
  • Predictive Analysis
  • User-Friendly Interface
  • Ad Hoc Reporting
  • Customizable Features
  • Performance Measurements
  • Intuitive dashboard

The foremost motives why organizations are choosing Pentaho for their corporations are:

  • Controlled records transport: Controlled records transport: It merges trusted and timely records for effective information analytics at scale for all users in all environments
  • Easily embeddable: Pentaho helps multi-tenant architecture. It lets in embedding the analytics into any workflow utility like Cloud, mobile, and hybrid facts models.
  • Power to combine: It correctly integrates and blends statistics from a couple of sources, regardless of the deployment environments. Provides flexibility of analytics, turning massive statistics into treasured insights.
  • Interactive and easy visible tools: The visible drag and drop tools at Pentaho hold customers away from the burdens of complex coding.

Pentaho Architecture:

There are basically four layers in Pentaho’s architecture:

Presentation layer

Contains data available through reporting, analysis, process management, etc.

Data layer

Used to connect any database

Server layer

Allows applications to run on top of it

Client layer

Contains two client


How to add predefined function to your report:

Follow the steps given below to add a predefined function to your report.

Step 1 – At first, click the Function Button (FX)

Step 2 – In the step-2, select a Particular Function

Step 3 – In this step, define a Field Name

Step 4 – In the step-4, add a Function to Report Workspace

Step 5 – In the last step, check the Preview

Drop us a Query

+91 97846 54326

Available 24x7 for your queries