Skip to main content

Pentaho+ documentation is moving!

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

 

Hitachi Vantara Lumada and Pentaho Documentation

Components Reference

Parent article

Pentaho aims to accommodate diverse computing environments. This list provides details about the environment components and versions we support. Where applicable, versions are listed as certified or supported:

  • Certified

    The version has been tested and validated for compatibility with Pentaho.

  • Supported

    Support is available for listed non-certified versions.

If you have questions about your particular computing environment, contact Pentaho Support.

Server

The Pentaho Server is hardware-independent and runs on server-class computers that comply with these specifications for minimum hardware and required operating systems:

Hardware—64 bitOperating System—64 bit
CertifiedSupported
  • Processor

    Intel EM64T or AMD64 Dual-Core

  • RAM

    8 GB with 4 GB dedicated to Pentaho servers

  • Disk Space

    20 GB free after installation

  • Microsoft Windows 2022 Server
  • CentOS Stream 8
  • Red Hat Enterprise 8
  • Ubuntu Server 20.04 LTS
  • Microsoft Windows 2019 Server & 2022 Server
  • CentOS Linux 7, Linux 8, & Stream 8
  • Red Hat Enterprise 7.x & 8.x
  • Ubuntu Server 18.x LTS & 20.x LTS

Container deployment

Supported technology for deploying Pentaho in containers.

TechnologyCertifiedSupported
Docker20.10.1020.x

Workstation

These Pentaho design tools are hardware-independent and run on client-class computers that comply with these specifications for minimum hardware and required operation systems.

  • Pentaho Aggregation Designer
  • Pentaho Data Integration
  • Pentaho Metadata Editor
  • Pentaho Report Designer
  • Pentaho Schema Workbench

Hardware—64 bitOperating System—64 bit
CertifiedSupported
  • Processors

    • Apple Macintosh Dual-Core
    • Intel EM64T or AMD64 Dual-Core
  • RAM

    2 GB RAM for most of the design tools, PDI requires 2 GB dedicated

  • Disk Space

    2 GB free after installation

  • Minimum Screen Size

    1280 x 960

  • Ubuntu Desktop 20.04
  • Microsoft Windows 11
  • macOS 12 (Monterey)
  • Ubuntu Desktop 18.x & 20.x
  • Microsoft Windows 10 & 11
  • macOS 11 (Big Sur) & 12 (Monterey)

Embedded software

When embedding Pentaho software into other applications, the computing environment should comply with these specifications for minimum hardware and required operation systems.

  • Embedded Pentaho Reporting
  • Embedded Pentaho Analysis
  • Embedded Pentaho Data Integration
Hardware—64 bitOperating System—64 bit
CertifiedSupported
  • Processors

    Intel EM64T or AMD64 Dual-Core

  • RAM

    8 GB with 4 GB dedicated to Pentaho servers

  • Disk Space

    20 GB free after installation

  • Microsoft Windows 2022 Server
  • CentOS 8
  • Red Hat Enterprise 8
  • Ubuntu Server 20.04 LTS
  • Microsoft Windows 2019 Server & 2022 Server
  • CentOS 7 & 8
  • Red Hat Enterprise 7.x & 8.x
  • Ubuntu Server 18.x LTS & 20.x LTS

Application servers

Servers to which you deploy Pentaho software must run one of these application servers:

  • JBoss EAP 7.3
  • Tomcat 9.0.xx (shipped with 9.0.65) with Oracle Java 11.x (shipped with 11.0.13)

Solution database repositories

Pentaho software stores processing artifacts in these database repositories:

CertifiedSupported
PostgreSQL 14PostgreSQL 12.x & 13.x *
MySQL 8.026MySQL 5.7
Oracle 21cOracle 19c & 21c (including patched versions)
MS SQL Server 2019Microsoft SQL Server 2017 & 2019 (including patched versions)

* The default installed solution database.

Hadoop Vendors

Pentaho software supports data sources from these Hadoop Vendors.

VendorDriver Version
Cloudera Data Platform (CDP) Private Cloud7.1
Google Dataproc1.4
EMR5.21
Microsoft Azure HDInsight4.0

Data Sources: General

Pentaho software supports the following data sources. Check this list if you are evaluating Pentaho or checking for general compatibility with a specific vendor.

Data SourceCertifiedSupported
Salesforce5454.x
Amazon Redshift1.2.34.10581.2.34.x
Snowflake3.13.163.13.x
Hitachi Content Platform8.0.0.98.0.0.x

Pentaho Tools

This table summarizes which data sources are compatible with the main Pentaho tools.

Pentaho SoftwareData Source
Pentaho Reporting
  • JDBC 3/4*
  • ODBC
  • OLAP4J
  • XML
  • Pentaho Analysis
  • Pentaho Data Integration
  • Pentaho Metadata
  • Scriptable
  • Snowflake
Pentaho Server, Action Sequences
  • Relational (JDBC)
  • Hibernate
  • Javascript
  • Metadata (MQL)
  • Mondrian (MDX)
  • XML (XQuery)
  • Security User/Role List Provider
  • Snowflake
  • Data Integration Steps (PDI)
  • Other Action Sequences
  • Web Services
  • XMLA
Pentaho Data Integration
  • JDBC 3/4*
  • OLAP4J
  • Salesforce
  • Snowflake
  • XML
  • CSV
  • Microsoft Excel
* Use a JDBC 3.x or 4.x compliant driver that is compatible with SQL-92 standards when communicating with relational data sources. For a list of drivers to use with relational JDBC databases, see the JDBC drivers reference.

Big Data Sources: General

Pentaho software supports the following Big Data sources. Check this list if you are evaluating Pentaho or checking for general compatibility with a specific vendor.

Data SourceSupported Version
Amazon EMR (via Hive)5.21, 5.24, 5.36
Cloudera Data Platform (via Hive or Impala)7.1.x
Datastax4.6, 4.8
Google BigQuery1.2.25
Google Dataproc1.4, 2.2
Greenplum4.2, 4.3
Microsoft Azure HDInsight4.0
MongoDB4.4
Netezza7.1, 7.2
SAP HANASPS
Teradata16.20
Vertica10, 11

Big Data Sources: Details

This table shows the Big Data sources that are compatible with specific Pentaho tools.

Data SourceVersionsAnalyzerPIR/PDDPentaho ReportingDSWPDIServer/ClientPRDPSWPME
Amazon EMRa 5.21, 5.24, 5.36YesYesNoNoYesYesNoYes
Cloudera Data Platform (CDP) Private Cloud7.1.x (for job execution)NoNoNoNoYesYesNoYes
via Impalab (as data source)YesYesYesYesYesYesNoYes
via Hive3c (as data source)NoYesYesYesYesYesNoYes
Datastax4.6, 4.8NoNoNoNoYesNoNoNo
Google BigQuery1.2.25dYesYesYesYesYesYesYesYes
Google Dataproce (for job execution) 1.4, 2.2fNoNoNoNoYesYesNoNo
via Hive2 and Google BigQuery (as data source)YesYesYesYesYesYesNoYes
Greenplum4.2, 4.3YesYesYesYesYesYesYesYes
Microsoft Azure HDInsight4.0YesYesNoNoYesNoNoYes
MongoDB4.4NoNoYesNoYesYesNoNo
Netezza7.1, 7.2YesYesYesYesYesYesYesYes
SAP HANASPSNoNoNoNoYesNoNoNo
Teradata16.20YesYesYesYesYesYesYesYes
Vertica10 & 11YesYesYesYesYesYesYesYes
Notes: A generic Apache Hadoop driver is included in the Pentaho distribution for version 9.4: Other supported drivers can be downloaded from the Hitachi Vantara Lumada and Pentaho Support Portal.

a Use the EMR 5.21 driver for your EMR 5.24 or EMR 5.36 cluster. The EMR 5.21 driver is certified to work for EMR 5.24.

b You must have the current version of the Pentaho release to use the CDP 7.1.4 driver. The CDP 7.1.4 driver requires the Impala JDBC Connector 2.6.4 Cloudera driver.

c Hive3 as a data source for CDP also supports Hive LLAP, and Hive3 on Tez.

d The Simba driver required for Google BigQuery is the JDBC 4.2-compatible version. See https://cloud.google.com/bigquery/partners/simba-drivers/ .

e HBase is not supported with Google Dataproc.

f Use the Google Dataproc 1.8 driver for your Google Dataproc 2.2 cluster. The Google Dataproc 1.8 driver is certified to work for Google Dataproc 2.2.

SQL dialect-specific

Pentaho software generates dialect-specific SQL when communicating with these data sources. Certified indicates the SQL dialect has been tested for compatibility with Pentaho.

Pentaho SoftwareData Source
Pentaho Analyzer

Certified

  • Amazon Redshift
  • Azure SQL
  • Impala
  • MySQL
  • Microsoft SQL Server
  • Oracle
  • PostgreSQL
  • Snowflake

Supported

  • Access
  • Derby
  • Firebird
  • Greenplum
  • Hsqldb
  • IBM DB2
  • IBM MQ 9.2
  • Informix
  • Ingres
  • Interbase
  • Neoview
  • Netezza
  • SqlStream
  • Sybase
  • Teradata
  • Vectorwise
  • Vertica
  • Other SQL-89 compliant*
Pentaho Metadata

Certified

  • Azure SQL
  • Hive 2
  • Impala
  • MySQL
  • PostgreSQL

Supported

  • Amazon Redshift
  • ASSQL
  • Firebird
  • H2
  • Hypersonic
  • IBM DB2
  • IBM MQ 9.2
  • Ingres
  • Interbase
  • MS Access
  • MS SQL Server (JTDS Driver)
  • MS SQL Server (Microsoft Driver)
  • Netezza
  • Snowflake
  • Sybase
  • Vertica
  • Other SQL-92 compliant*
Pentaho Data Integration

Certified

  • Amazon Redshift
  • Azure SQL
  • Hive
  • Hive 2
  • Impala
  • MS SQL Server (JTDS Driver)
  • MS SQL Server (Microsoft Driver)
  • MySQL
  • Oracle
  • PostgreSQL
  • Snowflake
  • Vertica

Supported

  • Apache Derby
  • AS/400
  • InfiniDB
  • Exasol 4
  • Firebird SQL
  • Greenplum
  • H2
  • Hypersonic
  • IBM DB2
  • IBM MQ 9.2
  • Informix
  • Ingres
  • Ingres VectorWise
  • MaxDB (SAP DB)
  • Neoview
  • Netezza
  • Oracle RDB
  • SAP HANA
  • SQLite
  • Teradata
  • UniVerse database
  • Other SQL-92 compliant*
* If your data source is not in this list and is compatible with SQL-92, Pentaho software uses a generic SQL dialect.

Third-party libraries

Pentaho software is compatible with the following third-party web framework, file system, engine, and utility libraries:

  • AngularJS 1.7.8
  • HTTPClient 4.5.9
  • Apache VFS 2.3
  • Apache Axis2 1.7.9
  • Apache Log4j 2.17.1

Security

Pentaho software integrates with these third-party security authentication systems:

  • Active Directory
  • CAS 5.x and CAS 6.5
  • Integrated Microsoft Windows Authentication
  • LDAP
  • RDBMS

Java virtual machine

Pentaho software requirements for Java Runtime Environment (JRE).

Pentaho SoftwareCertifiedSupported
All Pentaho software
  • Oracle Java 11.0.13
  • Oracle OpenJDK 11.0.13
  • Oracle Java 8.x & 11.x
  • Oracle OpenJDK 8.x & 11.x
  • AdoptOpenJDK
  • Zulu from Azul Systems

NoteSome Hadoop clusters using Java 8 may not be fully compatible when running Pentaho with Java 11, see Compatability issues running Pentaho on Java 11 with your Hadoop cluster for details.

Web browsers

Pentaho supports major versions of web browsers that are publicly available six weeks prior to the finalization of a Pentaho release.

Certified BrowsersSupported Browsers
  • Apple Safari 15.6.1 (On macOS only)
  • Google Chrome 106.0.5249.119
  • Microsoft Edge 106.0.1370.42
  • Mozilla Firefox 105
  • Apple Safari 15 (On macOS only) and later
  • Google Chrome 106 and later
  • Microsoft Edge 106 and later
  • Mozilla Firefox 105 and later
*Linux requires libwebkitgtk-1.0. See Use the Pentaho Installation Wizard to Install the PDI Client, Utilities, and Plugins for more information.