Time to Update BI Tools

It’s time to test what has open source developers had worked hard to achieve in 2021 and let us play with the new version of:

Pentaho

On august 02 Pedro Alves published on his blog that Pentaho 9.2 was available.

You can download the BI server, the ETL client tool (PDI/Kettle), report designer, the metadata editor to build the query models for your users, and for your multidimensional database the schema designer and aggregation designer.

Project HOP

There is also an ETL in its 0.9 version for testing.

Knowage

On my previous post Knowage 8.0, could be run from containers downloading a docker compse scrip tfrom Github, but you can try to download its binaries from a low bandwidth link here 8.0 RC. There is also a 7.4 documentation.

Pentaho 9.0 Links

Just in July Pentaho 8.3 was announced. Now on January we got 9.0 with big data improvements, installation and step improvements. These are the links available in sourceforge. And as always we can see the relevant changes in Pedro Alves blog (here)

There is also the metadata, mondrian schema and aggregation editors in the files section.


Edit July 2020:
After updating to Ubuntu 20.04 LTS, an error in ‘libwebkitgtk-1.0-0’ stops PDI from starting.
In my case this post in Ask Ubuntu (How do I install libwebkitgtk-1.0-0 on Ubuntu 19.04) solved my problem:
1. Browse to https://launchpad.net/ubuntu/+source/webkitgtk
2. There is a long list of files, I selected:
libwebkitgtk-1.0-0_2.4.11-3ubuntu3_amd64.deb)
3. Install in a terminal (Last one is for dependencies):
$ sudo dpkg -i libwebkitgtk-1.0-0_2.4.11-3ubuntu3_amd64.deb
$ sudo apt install -f


Edit May 2021:
It is getting harder to install old software. As more dependencies cannot be found in Ubuntu 20.10.
The PDI will start but without the tabbed panel (Welcome page, etc.).
If you want the full experience, modify:
$ sudo vi /etc/apt/sources.list
And add:
deb http://security.ubuntu.com/ubuntu bionic-security main
$ sudo apt update
It worked after retries and manual installs. Your system will may vary.
Try to download and install some of these of this:
libicu60 libenchant1c2a libjavascriptcoregtk-1.0-0 libicu60
1. sudo dpkg -i libicu60_60.2-3ubuntu3.1_amd64.deb
2. sudo dpkg -i libjavascriptcoregtk-1.0-0_2.4.11-3ubuntu3_amd64.deb
3. sudo apt install libenchant1c2a
4. sudo apt install libwebkitgtk-1.0-0

Pentaho Data Integration (PDI) 9.1

Pentaho 8.3 CE

The third release of Pentaho under Hitachi was made on July instead of the usual date that was October. Pedro Alves describes lots of improvements, specially to PDI. The community version can be downloaded from SourceForge.

The Client Tools folder contains the superb ETL (pdi-ce-8.3.0.0-371.zip). And the Report Editor (prd-ce-8.3.0.0-371.zip), also the metadata editor (pme-ce-8.3.0.0-371.zip) and tools for multidimentional database design such as the schema workbench editor (psw-ce-8.3.0.0-371.zip) or aggregation designer (pad-ce-8.3.0.0-371.zip).

The Web Server to assign access rights to users, schedule automatic runs from ETL or reports and design dashboards is directly under the server folder (pentaho-server-ce-8.3.0.0-371.zip).

Edited 2020:
Edited: Remember that you only need to unzip the files to run the tools. The only requirement is java. To install the OpenJDK 8 version it you can:

sudo apt-get install openjdk-8-jdk

or:

  1. Browse to https://adoptopenjdk.net/ or https://openjdk.java.net/install/ and download
    (Java 8 & HotSpot options):
    OpenJDK8U-jdk_x64_linux_hotspot_8u252b09.tar.gz.
  2. Uncompress it into a DIRECTORY:
    sudo tar -C /<ANY-DIRECTORY> -zxf ~/Downloads/OpenJDK8U-jdk_x64_linux_hotspot_8u252b09.tar.gz
  3. Change its user:
    sudo chown -R root:root /opt/jdk8u252-b09
  4. Add it to your path:
    sudo gedit /etc/profile
    adding at the end two lines:
    export JAVA_HOME=”/opt/jdku8222-b10
    export PATH=$JAVA_HOME/bin:$PATH
  5. Adding at the beginning of startup files (start-pentaho.sh, spoon.sh):
    export PENTAHO_JAVA_HOME=”/ANY-DIRECTORY/jdk8u252-b09″