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-tools

Check for client plugins.

cd
cd ~/Downloads/'Client Tools'/'PDI (Spoon)'
ls

Unjar 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.zip

Change the permission for all .sh files.

All .sh files will need executable permission.

cd
cd ~/Pentaho/design-tools
find . -iname "*.sh" -exec bash -c 'chmod +x "$0"' {} \;

Check that it matches the following directory structure:

~/Pentaho

design-tools

data-integration

jdbc-distribution

license-installer

PDI plugins are installed in the plugins folder.

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-common

Add 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 update

Install package.

sudo apt-get install -qq libwebkitgtk-1.0-0

sudo apt-get install libcanberra-gtk-module

Start 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.zip

Change the permission for all .sh files.

All .sh files will need executable permission.

cd
cd ~/Pentaho/design-tools
find . -iname "*.sh" -exec bash -c 'chmod +x "$0"' {} \;

Check that it matches the following directory structure:

~/Pentaho

design-tools

data-integration

jdbc-distribution

license-installer

metadata-editor

The PME plugins are installed in the plugins folder.

Metadata Editor

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.zip

Change the permission for all .sh files.

All .sh files will need executable permission.

cd
cd ~/Pentaho/design-tools
find . -iname "*.sh" -exec bash -c 'chmod +x "$0"' {} \;

Check that it matches the following directory structure:

~/Pentaho

design-tools

data-integration

jdbc-distribution

license-installer

metadata-editor

schema-workbench

The PSW plugins are installed in the plugins folder.

Schema Workbench

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.zip

Change the permission for all .sh files.

All .sh files will need executable permission.

cd
cd ~/Pentaho/design-tools
find . -iname "*.sh" -exec bash -c 'chmod +x "$0"' {} \;

Check that it matches the following directory structure:

~/Pentaho

design-tools

data-integration

jdbc-distribution

license-installer

metadata-editor

schema-workbench

aggregation-designer

The PAD plugins are installed in the plugins folder.

Aggregation Designer

Start PAD.

cd
cd ~/Pentaho/design-tools/aggregation-designer
./startaggregationdesigner.sh

PreviousServer Plugins NextEE Plugins

Last updated 1 day ago

Was this helpful?