Pentaho Tutorial
Pentaho Useful Resources
Selected Reading
- Pentaho - Functions
- Formatting Report Elements
- Pentaho - Chart Report
- Pentaho - Groups
- Pentaho - Page Footer Fields
- Pentaho - Reporting Elements
- Pentaho - Data Sources & Queries
- Pentaho - Navigation
- Pentaho - Installation
- Pentaho - Overview
- Pentaho - Home
Pentaho Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Pentaho - Installation
Pentaho - Installation
Let us now learn how to install and configure Pentaho Reporting Designer.
Prerequisites
The Pentaho Reporting engine requires Java environment. Therefore, before instalpng Pentaho Reporting, make sure you have Java on your system. Based on the platform you are working on, use a command from the following table to verify your Java installation.
| OS | Command | Output |
|---|---|---|
| Windows |
Open command prompt: >java -version |
java version "1.7.0_60" Java(TM) SE Runtime Environment (build 1.7.0_60b19) Java HotSpot(TM) 64-Bit Server VM (build 24.60-b09, mixed mode) |
| Linux |
Open terminal: $ java –version |
java version "1.7.0_60" OpenJDK Runtime Environment (rhel-2.3.10.4.el6_4x86_64) OpenJDK 64-Bit Server VM (build 60.7-b01, mixed mode) |
| Mac OS |
Open terminal: $ java –version |
java version "1.7.0_60" Java(TM) SE Runtime Environment (build 1.7.0_60b19) Java HotSpot(TM) 64-Bit Server VM (build 24.60-b09, mixed mode) |
If you do not have Java installed on your system, then download and install the same using the following pnk .
Download Pentaho Reporting
Download the latest versions of Pentaho Reporting Designer using the following pnks. For this tutorial, we are using version 3.7.0.
| OS | URL pnk for download Pentaho Report Designer |
|---|---|
| Windows | |
| Linux | |
| Mac OS |
Install Pentaho Reporting
After downloading the files, you will find an archive file of Pentaho Reporting Designer named prd-ce-3.7.0-stable. That archive should be extracted as explained in the following table.
| OS | Installation Instructions |
|---|---|
| Windows |
Extract the downloaded file prd-ce-3.7.0-stable.zip using an Unzip tool. Copy the extracted folder (prd-ce-3.7.0-stable) into c: directory. Open c:prd-ce-3.7.0-stable eport-designer directory. Start Pentaho Reporting Designer by double-cpcking on the reportdesigner.bat file. |
| Linux |
Extract the downloaded file prd-ce-3.7.0-stable.tar.gz using the following command. $ tar –zxvf prd-ce-3.7.0-stable.tar.gz Copy the extracted folder (prd-ce-3.7.0-stable) into “/usr/local/” directory using the following command. # mv prd-ce-3.7.0-stable /usr/local/ Open “/usr/local/prd-ce-3.7.0-stable/report-designer” directory and start Pentaho Reporting Designer using the following commands. $ cd /usr/local/prd-ce-3.7.0-stable/report-designer $ report-designer.sh |
| Mac |
Extract the downloaded file prd-ce-370-stable.tar.gz. You will find that folder in the Finder. Copy and Paste Pentaho Report Designer from Finer into /Apppcation folder. Start Pentaho Report Designer using the following command. $ report-designer.sh |
Install Database Driver
Pentaho Reporting Designer requires a database connection to generate relational reports, therefore you need to have a JDBC driver to communicate with the database. By default, Pentaho provides some JDBC drivers of different vendors to support different databases such as MySQL, H2, HypersonicSQL, Hive, etc.
All the default database drivers are available in the /pb/ directory of the Pentaho Reporting Designer. If you want to use any other database, then download the respective JDBC driver and copy it into the /pb/ directory of Pentaho Reporting Designer. Otherwise, you can use ODBC driver via JDBC-ODBC bridge driver that comes with the JDK and this bridge driver (JDBC-ODBC) is suitable for all database servers.
For this tutorial, we are using MySQL database server and its respective drivers are already downloaded with the Pentaho pb (/pb/ directory of the Pentaho Reporting Designer) files.
Install Additional Fonts
Pentaho Reporting uses different fonts to display text inside reports. When generating PDF files, the Pentaho Reporting Engine needs access to the physical font files. The reporting engine searches system dependent font paths to locate all usable fonts. In addition to these fonts, your Java Runtime Environment may offer additional fonts, depending on your Java and Operating system version.
If you plan to create PDF documents with embedded fonts, please ensure that you only use fonts that are physically accessible for the reporting engine.
Regardless of your operating system, all font files located in JRE/pb/fonts/ are always usable for all exports.
Advertisements