What's new in Pentaho 9.3

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 the Components reference in the Try Pentaho Data Integration and Analytics document 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 the Install Pentaho Data Integration and Analytics document 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 the MongoDB Input anf MongoDB Output steps in the Pentaho Data Integration document 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 the Components reference in the Try Pentaho Data Integration and Analytics document 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 the Install Pentaho Data Integration and Analytics document 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 in the Pentaho Business Analytics document 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 in the Pentaho Business Analytics document 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 in the Pentaho Business Analytics document 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 in the Pentaho Business Analytics document 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 in the Pentaho Business Analytics document for more information.