Install Client Tools

Installation of Clients 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.

Pentaho Pro Suite

The following steps install the client plugins into a Linux Desktop - for Windows

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

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 Client Directories

1. Create ~/Pentaho/design-tools directory.

cd
mkdir -p ~/Pentaho/design-tools

1. Check for client plugins.

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

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

1. 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"' {} \;

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

This section is for reference.

The required packages are now installed v10.1+

Just start PDI to check UI and licenses.

Ubuntu 22.04 the Repository is:

• missing libwebgtk: webkit browser extensions.

• and fails to load canberra-gtk-module

1. Add package repository.

sudo apt-get install -qq software-properties-common

1. 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'

1. Update repositories.

sudo apt-get update

1. Install package.

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

sudo apt-get install libcanberra-gtk-module

1. Start PDI.

cd
cd ~/Pentaho/design-tools/data-integration
./spoon.sh

Spoon UI

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

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

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

1. 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"' {} \;

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

---

Metdata Editor

1. Start PME.

cd
cd ~/Pentaho/design-tools/metadata-editor
./metadata-editor.sh

Pentaho Metadata Editor

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

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

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

1. 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"' {} \;

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

1. Start PSW.

cd
cd ~/Pentaho/design-tools/schema-workbench
./workbench.sh

Schema Workbench

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

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

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

1. 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"' {} \;

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

1. Start PAD.

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

Aggregation Designer