Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com. 

 
Version Data Integration and Analytics
Hitachi Vantara Lumada and Pentaho Documentation

What's new in Pentaho 9.3

  1. Last updated
  2. Save as PDF
 

The Pentaho 9.3 Enterprise Edition delivers a variety of features and enhancements, including the Java upgrade to version 11, Docker container deployment, and component upgrades. Pentaho 9.3 also continues to enhance the Pentaho business analytics experience.

Along with these features and enhancements, Pentaho 9.3 is a Long Term Support (LTS) release. LTS refers to a widely adopted release that provides stability and flexibility for customers to upgrade when best suited. Such a release is for customers who have rigid environments and cannot frequently upgrade.

Java 11

With Oracle's support of Java 8 ending, Pentaho 9.3 is built on the latest release of Java, version 11. See Components reference for more information.

Docker container deployment

You can now create and deploy Docker containers of Pentaho products with a command line tool. For example, you can use your Pentaho Server, based on your licensed Pentaho software installation, to create a standardized Docker container with data integration, business analytics, and Carte server components. See Docker container deployment of Pentaho for more information.

MongoDB improvements

You can now use MongoDB Atlas string format to connect Pentaho to MongoDB. With this type of string, you no longer need to specify all your cluster members in the connection. Also, you can now continue processing aggregation pipeline data when it exceeds the standard 100MB RAM allocation. See MongoDB Input and MongoDB Output for more information.

Component upgrades

Pentaho 9.3 contains many upgraded components, including Snowflake, ElasticSearch, IBM MQ, Postgres, Oracle, SQL Server, Windows Server, MacOS 11 Big Sur, and Ubuntu. See Components Reference for more information.

Security improvements

Log4j has been upgraded to version 2.17.1 to improve logging and address Log4j security issues. See Hitachi Vantara Lumada and Pentaho Support Portal for more information.

Reduced Pentaho installation download size and improved startup time

The download size of the Pentaho installation is reduced by almost half, leading to a smaller footprint and quicker download time. Pentaho's start time is also significantly improved now that only your specific drivers are loaded at startup instead of the entire set. See Adding a driver for instructions on downloading and adding your specific drivers.

Analyzer enhancements

Pentaho 9.3 includes the following Analyzer improvements:

  • Query performance inprovement

    Improved Analyzer's caching of queries to increase performance.

  • Improved handling of daylight savings when scheduling reports

    The new Ignore daylight saving adjustment option permits your report to run at least once every 24 hours, regardless of daylight saving. See Schedule a Report for more information.

  • Enable or disable report options at the server level

    The new Show Empty Rows where the Measure cells is blank property improves performance by avoiding cross-joins. See Control empty rows in reports for more information.

  • Select parameter values when scheduling reports

    You can now add parameters values when scheduling an Analyzer report from Pentaho User Console and set default values at the time a report is scheduled to run. See Add query parameters to Analyzer reports for more information.

  • Drill up or down a dimension

    You have new options for drilling up or down a dimension. See Working with Analyzer fields for more information.

  • Export an Analyzer report as a JSON file through a URL

    You can now export an Analyzer report as a JSON file from a Pentaho repository through a URL, which can be useful when you want to export reports from a different scheduler. See Export an Analyzer report through a URL for more information.