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.

If you have questions about your particular computing environment, please 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
  • 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 2012 Server R2 & 2016 Server
  • CentOS 6 & 7
  • Red Hat Enterprise 6 & 7
  • Ubuntu Server 16.04 LTS & 18.04 LTS
  • SUSE Linux SLES 11 (SP3+)

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
  • Processors

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

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

  • Disk Space

    2 GB free after installation

  • Minimum Screen Size

    1280 x 960

  • Microsoft Windows 7, 8, & 10
  • Ubuntu Desktop 16.04 LTS & 18.04 LTS
  • macOS 10.12 & 10.13

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
  • 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 2012 Server R2 & 2016 Server
  • CentOS 6 & 7
  • Red Hat Enterprise 6 & 7
  • Ubuntu Server 16.04 LTS & 18.04 LTS
  • SUSE Linux SLES 11 (SP3+)

Application servers

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

  • JBoss EAP 7.0 with Oracle Java 8.x
  • Tomcat 8.0 & 8.5 (default) with Oracle Java 8.x (as shipped)

Solution database repositories

Pentaho software stores processing artifacts in these database repositories:

  • PostgreSQL 9.5.xx* & 9.6.xx
  • MySQL 5.6.xx & 5.7.xx (SQL 92)
  • Oracle 11.2 & 12.1 (SQL 92) (including patched versions)
  • MS SQL Server 2014 & 2016 (including patched versions)

* The default installed solution database.

Data sources

Pentaho software connects to these relational and non-relational data sources.

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 your convenience, we provide a list of drivers used to get data from relational JDBC databases.

Big data sources

Pentaho software connects to these big data sources.

Data SourceVersionsAnalyzerPIR/PDDPentaho ReportingDSWPDIServer/ClientPRDPSWPME
Amazon EMRg5.11, 5.13, 5.21, 5.24YesYesNoNoYesYesNoYes
Cloudera5.14, 6.1, 6.2, 6.3a (for job execution)NoNoNoNoYesYesNoYes
via Impalab (as data source)YesYesYesYesYesYesNoYes
via Hive2c(as data source)NoYesYesYesYesYesNoYes
Datastax4.6, 4.8NoNoNoNoYesNoNoNo
Google BigQuery1.1.5.1005fYesYesYesYesYesYesYesYes
Greenplum4.2, 4.3YesYesYesYesYesYesYesYes
Hortonworks

3.0, 3.1

(for job execution)

NoNoNoNoYesYesNoYes
via Hive2c(as data source)NoYesYesYesYesYesNoYes

via Spark SQLd

(as data source)

NoNoNoNoYesNoNoNo
MapR5.2, 6.0e (for job execution)NoNoNoNoYesNoNoNo
via Hive2​ (as data source)NoYesYesYesYesYesNoYes
Microsoft Azure HDInsight3.5NoNoNoNoYesNoNoNo
MongoDB3.4, 3.6NoNoYesNoYesYesNoNo
Netezza7.1, 7.2YesYesYesYesYesYesYesYes
SAP HANASPSNoNoNoNoYesNoNoNo
Teradata14.10, 15.0YesYesYesYesYesYesYesYes
Vertica7.1, 7.2YesYesYesYesYesYesYesYes
Notes: The following shims are included in the Pentaho Big Data plugin for Pentaho Version 8.3: Cloudera Distribution for Hadoop 6.1, Amazon EMR 5.11, Hortonworks 3.0, and MapR 6.0. Other supported shims can be downloaded from the Pentaho Customer Support Portal.

a The CDH 5.14 shim has been certified with the Impala JDBC Connector 2.5.43 Cloudera driver. You must have the current version of the Pentaho release to use either the CDH 5.14 or CDH 6.1 shim. The CDH 6.1 shim requires the Impala JDBC Connector 2.6.4 Cloudera driver. CDH 6.1 requires Pentaho Service Pack 8.2.0.4 or later. The CDH 6.1 shim works with CDH 6.2 and CDH 6.3.

b As with any data source, the performance of Pentaho Analyzer on Impala will be dependent upon the data shape, Impala’s configuration, and the types of queries. See the Customer Portal best practice article concerning Pentaho Analyzer on Impala for more information.

c Hive2 as a data source for CDH also supports Hive on Spark. Hive2 as a data source for HDP also supports Hive on Tez.

d The Simba Spark SQL driver needs to be downloaded, installed, and configured to be used as a data source for Hortonworks. See our instructions on downloading, installing, and configuring for more information.

e MapR client 6.0 only supports MapR-DB, which requires an additional setting. See the MapR Mapping to HBase Table Namespaces documentation for more information on this setting. Due to MapR limitations, Hbase comparators are not supported.

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

g Use the EMR 5.11 shim for your EMR 5.13 cluster and EMR 5.21 shim for your EMR 5.24 cluster. The EMR 5.11 shim has been certified to work for EMR 5.13. The EMR 5.21 shim has been certified to work for EMR 5.24.

SQL dialect-specific

Pentaho software generates dialect-specific SQL when communicating with these data sources.

Pentaho SoftwareData Source
Pentaho Analyzer
  • Access
  • Amazon Redshift
  • DB2
  • Derby
  • Firebird
  • Greenplum
  • Hsqldb
  • Impala
  • Infobright
  • Informix
  • Ingres
  • Interbase
  • Microsoft SQL Server
  • MonetDB
  • MySql
  • Neoview
  • Netezza
  • Oracle
  • PostgreSQL
  • Snowflake
  • SqlStream
  • Sybase
  • Teradata
  • Vectorwise
  • Vertica
  • Other SQL-89 compliant*
Pentaho Metadata
  • Amazon Redshift
  • ASSQL
  • DB2
  • Firebird
  • H2
  • Hive 2
  • Hypersonic
  • Impala
  • Ingres
  • Interbase
  • MS Access
  • MS SQL Server (JTDS Driver)
  • MS SQL Server (Microsoft Driver)
  • MySql
  • Netezza
  • Oracle
  • PostgreSQL
  • Snowflake
  • Sybase
  • Vertica
  • Other SQL-92 compliant*
Pentaho Data Integration
  • Amazon Redshift
  • Apache Derby
  • AS/400
  • InfiniDB
  • Exasol 4
  • Firebird SQL
  • Greenplum
  • H2
  • Hive
  • Hive 2
  • Hypersonic
  • IBM DB2
  • Impala
  • Infobright
  • Informix
  • Ingres
  • Ingres VectorWise
  • MaxDB (SAP DB)
  • MonetDB
  • MS SQL Server (JTDS Driver)
  • MS SQL Server (Microsoft Driver)
  • MySQL
  • Neoview
  • Netezza
  • Oracle
  • Oracle RDB
  • PostgreSQL
  • SAP HANA
  • Snowflake
  • SQLite
  • Teradata
  • UniVerse database
  • Vertica
  • 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.

Security

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

  • Active Directory
  • CAS
  • Integrated Microsoft Windows Authentication
  • LDAP
  • RDBMS

Java virtual machine

Pentaho software requirements for Java Runtime Environment (JRE). Certified indicates the JRE is tested and validated for each Pentaho release. Support is available for non-certified JREs.

Pentaho SoftwareCertifiedSupported
All Pentaho software
  • Oracle Java 8 Update 251
  • Oracle OpenJDK 8 Update 252
  • AdoptOpenJDK
  • Zulu from Azul Systems

Web browsers

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

Pentaho SoftwareSupported Browsers

Pentaho User Console (PUC)

(Pentaho recommends 2GB RAM for the web client.)

  • Apple Safari 10 (On macOS only) and later
  • Google Chrome 64 and later
  • Microsoft Edge 40.15063 and later
  • Microsoft Internet Explorer 11 (Does not render PUC correctly using Compatibility Mode)
  • Mozilla Firefox 58 and later
Pentaho Report Designer
  • Apple Safari 10 (On macOS only) and later
  • Google Chrome 64 and later
  • Microsoft Edge 40.15063 and later
  • Microsoft Internet Explorer 11 (Does not render PUC correctly using Compatibility Mode)
  • Mozilla Firefox 58 and later
Pentaho Data Integration (PDI) client*
  • Apple Safari 10 (On macOS only) and later
  • Google Chrome 64 and later
  • Microsoft Edge 40.15063 and later
  • Microsoft Internet Explorer 11 and later (Does not render PUC correctly using Compatibility Mode)
  • Mozilla Firefox 58 and later
*Linux requires libwebkitgtk-1.0. See Use the Pentaho Installation Wizard to Install the PDI Client, Utilities, and Plugins for more information.