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