Install Client Tools
Installation of Clients Tools ..
Pentaho Client Tools
There are two methods for installing the Business Analytics (BA) design tools. You can use either of these methods:
Pentaho Business Analytics Evaluation Wizard - Windows Desktop.
Install each separate tool manually - Linux / Windows Desktop.
The Pentaho Business Analytics Installation Wizard is the easiest way to install design tools, utilities, or plugins on the server or client workstations. The manual method allows you to manually copy design tool installation files to any directory on the server or client workstations. The deployment pattern will depend on the DevOps requirements.
The following steps install the client plugins into a Linux Desktop - for Windows
Unpack Client Package
The jar command is a general-purpose archiving and compression tool, based on ZIP and the ZLIB compression format.
x - Extract files from a JAR archive
f - Sets the file specified by the jarfile operand to be the name of the JAR file that is created
Pentaho Data Integration
Pentaho Data Integration (PDI) provides the Extract, Transform, and Load (ETL) capabilities that facilitates the process of capturing, cleansing, and storing data using a uniform and consistent format that is accessible and relevant to end users and IoT technologies.
Pentaho Client Directories
Create ~/Pentaho/design-tools directory.
cd
mkdir -p ~/Pentaho/design-toolsCheck for client plugins.
cd
cd ~/Downloads/'Client Tools'/'PDI (Spoon)'
lsUnjar pdi-ee-client-10.2.0.0-222.zip.
cd
cd ~/Pentaho/design-tools
jar -vxf ~/Downloads/'Client Tools'/'PDI (Spoon)'/pdi-ee-client-10.2.0.0-222.zipChange the permission for all .sh files.
cd
cd ~/Pentaho/design-tools
find . -iname "*.sh" -exec bash -c 'chmod +x "$0"' {} \;Check that it matches the following directory structure:
Data Integration UI
Ubuntu 22.04 the Repository is:
• missing libwebgtk: webkit browser extensions.
• and fails to load canberra-gtk-module
Add package repository.
sudo apt-get install -qq software-properties-commonAdd repository entry.
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 3B4FE6ACC0B21F32
sudo add-apt-repository 'deb [trusted=yes] http://cz.archive.ubuntu.com/ubuntu bionic main universe'Update repositories.
sudo apt-get updateInstall package.
sudo apt-get install -qq libwebkitgtk-1.0-0sudo apt-get install libcanberra-gtk-moduleStart PDI.
cd
cd ~/Pentaho/design-tools/data-integration
./spoon.sh
Pentaho Metadata Editor
Pentaho Metadata Editor is a tool that allows you to create and manage metadata models and domains for Pentaho data integration and analytics. Metadata models and domains are logical representations of your physical data sources that make them easier to understand and use by business users.
Unjar pme-ee-10.2.0.0-222.zip.
cd
cd ~/Pentaho/design-tools
jar -vxf ~/Downloads/'Client Tools'/'Metadata Editor'/pme-ee-10.2.0.0-222.zipChange the permission for all .sh files.
cd
cd ~/Pentaho/design-tools
find . -iname "*.sh" -exec bash -c 'chmod +x "$0"' {} \;Check that it matches the following directory structure:
Metadata Editor
Building a Pentaho Metadata Editor model starts with connecting to your data sources and defining business tables that provide user-friendly views of your underlying database tables. You rename technical columns to business terms, create relationships between tables, and can add calculated fields and hierarchies that make sense to end users.
The model building process includes setting up security rules to control data access and adding localization support for multiple languages. You can hide technical complexity while exposing only the relevant data and metrics that business users need for their analysis and reporting.
Once complete, the metadata model is published to the Pentaho server where it serves as a semantic layer for reporting tools, dashboards, and ad-hoc analysis. This provides business users with a consistent, governed view of organizational data without requiring them to understand the underlying database structure or write complex queries.
Start PME.
cd
cd ~/Pentaho/design-tools/metadata-editor
./metadata-editor.sh
Schema Workbench
Pentaho Schema Workbench is a tool that allows you to create and test Mondrian OLAP cube schemas visually. Mondrian OLAP cube schemas are XML files that define the logical structure of a multidimensional database, such as dimensions, hierarchies, levels, measures, and calculations.
Unjar psw-ee-10.2.0.0-222.zip.
cd
cd ~/Pentaho/design-tools
jar -vxf ~/Downloads/'Client Tools'/'Schema Workbench'/psw-ee-10.2.0.0-222.zipChange the permission for all .sh files.
cd
cd ~/Pentaho/design-tools
find . -iname "*.sh" -exec bash -c 'chmod +x "$0"' {} \;Check that it matches the following directory structure:
Schema Workbench
Building a Pentaho Schema Workbench schema starts with connecting to your data warehouse and defining the basic schema structure. You create cubes that represent your main analytical subjects, each containing dimensions for context (like time or geography) and measures for quantitative data (like sales or revenue).
The development process involves mapping these logical structures to your database tables by defining fact tables for measures and dimension tables for attributes. You establish proper join relationships between tables and create hierarchies within dimensions to enable drill-down analysis from high-level summaries to detailed data.
After configuring the core structure, you can add calculated members and advanced features to enhance analytical capabilities. The final step involves validating the schema to ensure all relationships work correctly, then deploying it to the Pentaho server where reporting and analysis tools can access the multidimensional data model.
Start PSW.
cd
cd ~/Pentaho/design-tools/schema-workbench
./workbench.sh
Aggregation Designer
Pentaho Aggregation Designer is a tool that helps you to improve the performance of your Pentaho Analyzer (Mondrian) OLAP cubes by creating and deploying aggregate tables. Aggregate tables are tables that contain pre-aggregated measures from the base fact table, which can speed up the query processing by reducing the amount of data that needs to be scanned and aggregated.
Unjar pad-ee-10.2.0.0-222.zip.
cd
cd ~/Pentaho/design-tools
jar -vxf ~/Downloads/'Client Tools'/'Aggregation Designer'/pad-ee-10.2.0.0-222.zipChange the permission for all .sh files.
cd
cd ~/Pentaho/design-tools
find . -iname "*.sh" -exec bash -c 'chmod +x "$0"' {} \;Check that it matches the following directory structure:
Aggregation Designer
The Pentaho Aggregation Designer is a performance optimization tool that creates pre-calculated summary tables (aggregates) for OLAP cubes to speed up analytical queries. It automatically analyzes query patterns and recommends which aggregate tables to build based on frequently accessed data combinations.
The tool connects to existing OLAP schemas, examines dimensional hierarchies and measures, then generates the physical aggregate tables in the database along with updated schema definitions. This significantly reduces query response times by allowing the system to serve results from pre-computed summaries rather than calculating them on-demand from large fact tables.
Building it requires components for schema analysis, performance modeling, aggregate recommendation algorithms, and deployment utilities that handle the database changes and schema updates needed to implement the optimizations.
Start PAD.
cd
cd ~/Pentaho/design-tools/aggregation-designer
./startaggregationdesigner.sh
Last updated
Was this helpful?