Skip to main content
Pentaho Documentation

Components Reference

Overview

This list provides details about the environment components and versions we support.

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

Pentaho server software is hardware-independent and runs on server-class computers that comply with these specifications for minimum hardware and required operation systems.

  • Pentaho Business Analysis Server
  • Pentaho Data Integration Server
Hardware—64 bit Operating System—64 bit
Processor:
  • Apple Macintosh Pro Quad-Core or Macintosh Mini Quad-Core
  • Intel EM64T or AMD64 Dual-Core

RAM: 8 GB with 4 GB dedicated to Pentaho servers

Disk Space: 20 GB free after installation

  • Apple Macintosh OS X Server 10.8 & 10.9
  • CentOS Linux 5 & 6
  • Microsoft Windows 2008 Server R2, 2012 Server R2
  • Red Hat Enterprise Linux 5 & 6
  • Solaris 10
  • Ubuntu Server 12.x & 14.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
  • Pentaho Mobile
Hardware—32 or 64 bit Operating System—32 or 64 bit
Processors:
  • Apple Macintosh Dual-Core, 64 bit only
  • 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

  • Apple Macintosh OS 10.8 & 10.9, 64 bit only
  • Microsoft Windows 7 & 8
  • Ubuntu Desktop 12.x & 14.x
  • iPad 2, 3, & Air (iOS 6.x & 7.x)

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:
  • Apple Macintosh Pro Quad-Core or Macintosh Mini Quad-Core
  • Intel EM64T or AMD64 Dual-Core
RAM: 8 GB with 4 GB dedicated to Pentaho servers

Disk Space: 20 GB free after installation

  • Apple Macintosh OS X Server 10.7 & 10.8
  • CentOS Linux 5 & 6
  • Microsoft Windows 2008 Server R2
  • Microsoft Windows 7
  • Red Hat Enterprise Linux 5 & 6
  • Solaris 10
  • Ubuntu Server 12.x & 14.x

Application Servers

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

Pentaho Software Application Server
Pentaho Business Analysis  Server

Pentaho Data Integration Server

  • JBoss EAP 6.1.x or 6.2.x
  • Tomcat 6.0.x (shipped)
  • Tomcat 7.0

Solution Database Repositories

Pentaho software stores processing artifacts in these solution database repositories.

Use Postgres JDBC driver 8.4 if you are using Redshift. You will also have to move the repository to a RDBMS other than PostgreSQL to be able to use Redshift because the default BA Server Repository requires the use of the Postgres 9.3-1102 JDBC driver.

Pentaho Software Database Repository
Pentaho Business Analysis Server

Pentaho Data Integration Server

  • MySQL 5.5, 5.6
  • Oracle 10/11
  • PostgreSQL 9.1*, 9.2

*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**
  • ODBC
  • OLAP4J
  • XML
  • Pentaho Analysis
  • Pentaho Data Integration
  • Pentaho Metadata
  • Scriptable
Pentaho Business Analysis 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**
  • OLAP4J
  • Salesforce
  • XML
  • CSV
  • Microsoft Excel

**Use a JDBC 3.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 DI Server/ Spoon PRD PSW PME
Apache  0.20.2* Y Y Y Y Y Y Y Y
Cloudera 4.7, 5.1 N N N N Y N N N
via Impala 1.3.x Y Y Y Y Y Y Y Y
Datastax 4.0, 4.5 N N N N Y N N N
Hortonworks 1.3.3, 2.1 N N N N Y N N N
via Hive2 Stinger 0.13 N Y Y Y Y Y N Y
MapR   3.0, 3.1.1 N N N N Y N N N
via Hive2 0.13 N Y Y Y Y Y N Y
Greenplum 4.2, 4.3 Y Y Y Y Y Y Y Y
MongoDB 2.4, 2.6 Y N Y N Y Y N N
Netezza 7.0.3, 7.1.0 Y Y Y Y Y Y Y Y
Teradata 14.0, 14.10 Y Y Y Y Y Y Y Y
Vertica 7.0, 7.1 Y Y Y Y Y Y Y Y

* Pentaho is pre-configured for Apache Hadoop 0.20.2. 

Acronyms: PIR - Pentaho Interactive Reporting, PDD - Pentaho Dashboard Designer, PR - Published Reports, DSW - Data Source Wizard, PRD - Pentaho Report Designer, PSW - Pentaho Schema Workbench, PME - Pentaho Metadata Editor

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
  • MicrosoftSqlServer
  • 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
  • MSSQLNative
  • MySQL
  • Netezza
  • Oracle
  • PostgresSQL
  • Sybase
  • Vertica
  • Other SQL-92 compliant****
Pentaho Data Integration
  • 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
  • MySQL
  • Neoview
  • Netezza
  • Oracle
  • Oracle RDB
  • PostgreSQL
  • 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.

Pentaho Software Authentication System

Pentaho Business Analysis Server

Pentaho Data Integration Server

  • 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 7
  • Oracle Java 6 (build targets).

Web Browsers

Pentaho supports these major versions of Web browsers that are publicly available six weeks prior to when Pentaho begins to finalize a release. We also support the preceding major version.

Pentaho Software Web Browser

Pentaho User Console

Pentaho Report Designer*****

  • Apple Safari 6.x & 7.x on OSX and iOS only
  • Google Chrome 36 - 37
  • Microsoft Internet Explorer 8 - 11******
  • Mozilla Firefox 31 - 32

*****Requires a web browser to preview exported HTML reports.

******Microsoft Internet Explorer does not render the Pentaho User Console correctly if you are using Compatibility Modes.

Mobile Apps

The Pentaho mobile app runs on the Apple iPad 2 and later, with iOS 6.x & 7.x using Safari mobile.