Skip to main content
Pentaho Documentation

Components Reference

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 bit Operating 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 2008 Server R2 & 2012 Server R2
  • CentOS 6 & 7
  • Red Hat Enterprise 6 & 7
  • Ubuntu Server 14.04 LTS & 16.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 bit Operating System—64 bit
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

  • Microsoft Windows 7, 8, & 10
  • Ubuntu Desktop 14.04 LTS & 16.04
  • OS X 10.11 & 10.12

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 bit Operating 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 2008 Server R2 & 2012 Server
  • CentOS 6 & 7
  • Red Hat Enterprise 6 & 7
  • Ubuntu Server 12.04 LTS & 14.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 6.4.x with Oracle Java 8.x
  • Tomcat 7.0.x with Oracle Java 8.x
  • Tomcat 8.0.x with Oracle Java 8.x (as shipped)

Solution Database Repositories

Pentaho software stores processing artifacts in these database repositories:

  • MySQL 5.6 & 5.7 (SQL 92) 
  • Oracle 11.2 & 12.1 (SQL 92)
  • PostgreSQL 9.4 & 9.5*
  • MS SQL Server 2012, 2014

*Default installed solution database

Data Sources

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

Pentaho Software Data Source
Pentaho Reporting
  • JDBC 3**/4** 
  • ODBC
  • OLAP4J
  • XML
  • Pentaho Analysis
  • Pentaho Data Integration
  • Pentaho Metadata
  • Scriptable
Pentaho Server, Action Sequences
  • Relational (JDBC)
  • Hibernate
  • Javascript
  • Metadata (MQL)
  • Mondrian (MDX)
  • XML (XQuery)
  • Security User/Role List Provider
  • Data Integration Steps (PDI)
  • Other Action Sequences
  • Web Services
  • XMLA
Pentaho Data Integration
  • JDBC 3**/4**
  • OLAP4J
  • Salesforce
  • 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 Source Versions Analyzer PIR/
PDD
PR DSW PDI Server/
Spoon
PRD PSW PME
Amazon EMR 4.1, 4.6, 5.2* close check close close check check close check
Cloudera 5.7, 5.8, 5.9, 5.10**
(for job execution)
close close close close check close close close
via Impala***
(as data source)
check check check check check check check check
via Hive2****
(as data source)
close check check check check check close check
Datastax 4.6, 4.8 close close close close check close close close
Greenplum 4.2, 4.3 check check check check check check check check
Hortonworks

2.3, 2.4, 2.5

(for job execution)

close close close close check close close close
via Hive2****
(as data source)
close check check check check check close check

via Spark SQL*****

(as data source)

close close close close check close close close
MapR 4.1.0, 5.1.0, 5.2******
(for job execution)
close close close close check close close close
via Hive2
​(as data source)
close check check check check check close check
MongoDB 3.0, 3.2 check close check close check check close close
Netezza 7.1, 7.2 check check check check check check check check
SAP HANA SPS close close close close check close close close
Teradata 14.10, 15.0 check check check check check check check check
Vertica 7.1, 7.2 check check check check check check check check

The following shims are included in the Pentaho Big Data plugin for Pentaho Version 7.0: Cloudera Distribution for Hadoop 5.8, Amazon EMR 4.1, Hortonworks 2.4, and MapR 5.1. You can download other supported shims from the Pentaho Customer Support Portal

* EMR 4.1 shim does not support HBase. EMR 4.1, 4.6, and 5.2 shims do not support Impala. Due to an existing Amazon EMR issue, the EMR 4.6 and 5.2 shims do not support S3 Block Storage type as output for PMR jobs.

** The CDH 5.7 and 5.8 shims were certified with the Impala JDBC Connector 2.5.31 Cloudera Simba driver. The CDH 5.9 and CDH 5.10 shims have been certified with the Impala JDBC Connector 2.5.36 Cloudera Simba driver. You must have the current version of the Pentaho release to use either the CDH 5.7, CDH 5.8, CDH 5.9, or CDH 5.10 shim.

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

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

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

****** If using MapR client, we recommend using the MapR client 5.1 on Windows client with version flexjson-2.1 for successful connection to a secured MapR server.

SQL Dialect-Specific

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

Pentaho Software Data Source
Pentaho Analysis
  • Access
  • Amazon Redshift
  • DB2
  • Derby
  • Firebird
  • Greenplum
  • Hsqldb
  • Impala
  • Infobright
  • Informix
  • Ingres
  • Interbase
  • LucidDb
  • Microsoft SQL Server
  • MonetDB
  • MySql
  • Neoview
  • Netezza
  • Oracle
  • PostgreSQL
  • SqlStream
  • Sybase
  • Teradata
  • Vectorwise 
  • Vertica
  • Other SQL-89 compliant****
Pentaho Metadata
  • Amazon Redshift
  • DB2
  • Firebird
  • H2
  • Hive 2
  • Hypersonic
  • Impala
  • Ingres
  • MS Access
  • ASSQL
  • MS SQL Server (JTDS Driver)
  • MS SQL Server (Microsoft Driver)
  • MySQL
  • Netezza
  • Oracle
  • PostgresSQL
  • 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
  • LucidDB
  • MaxDB (SAP DB)
  • MonetDB
  • MS SQL Server (JTDS Driver)
  • MS SQL Server (Microsoft Driver)
  • MySQL
  • Neoview
  • Netezza
  • Oracle
  • Oracle RDB
  • PostgreSQL
  • SAP HANA
  • 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).

Pentaho Software Java Runtime Environment
All Pentaho software, except Pentaho Mobile App
  • Oracle Java 8

Web Browsers

Pentaho supports major versions of Web browsers that are publicly available six weeks prior to the finalization of a Pentaho release, except as noted below.

Pentaho Software Web Browser

Pentaho User Console (PUC)

 

  • Apple Safari 9.x & 10.x (Note: On OS X only)
  • Google Chrome 53 & 54
  • Microsoft Edge
  • Microsoft Internet Explorer 11 (Note: Does not render PUC correctly using Compatibility Modes)
  • Mozilla Firefox 48 & 49
Pentaho Report Designer
  • Apple Safari 9.x & 10.x (Note: On OS X only)
  • Google Chrome 53 & 54
  • Microsoft Edge
  • Microsoft Internet Explorer 11
  • Mozilla Firefox 48 & 49
Pentaho Data Integration (PDI) client***** 
  • Apple Safari 9.x & 10.x (Note: On OS X only)
  • Google Chrome 53 & 54
  • Microsoft Internet Explorer 11 (Note: Required on Windows for data inspection and other features.)
  • Mozilla Firefox 48 & 49 

*****Linux requires libwebkitgtk-1.0.

Mobile Apps

The Pentaho mobile app runs on the Apple iPad 2, 3, and Air (iOS 8 - Retina).