Components Reference
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:
RAM: 8 GB with 4 GB dedicated to Pentaho servers Disk Space: 20 GB free after installation |
|
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—32 or 64 bit | Operating System—32 or 64 bit |
---|---|
Processors:
Disk Space: 2 GB free after installation Minimum Screen Size: 1280 x 960 |
|
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:
Disk Space: 20 GB free after installation |
|
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 |
|
Solution Database Repositories
Pentaho software stores processing artifacts in these solution database repositories.
Pentaho Software | Database Repository |
---|---|
Pentaho Business Analysis Server
Pentaho Data Integration Server |
|
*Default installed solution database
Data Sources
Pentaho software connects to these relational and non-relational data sources.
Pentaho Software | Data Source |
---|---|
Pentaho Reporting |
|
Pentaho Business Analysis Server, Action Sequences |
|
Pentaho Data Integration |
|
**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 | PDIServer/ Spoon | PRD | PSW | PME |
---|---|---|---|---|---|---|---|---|---|
Apache | 0.20.2*** | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Cloudera | 4.7, 5.3 (with Apache Spark 1.2.0), 5.4** | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
via Impala 1.4.x | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
|
Datastax | 4.5, 4.6 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Amazon EMR | 3.4 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Hortonworks | 1.3.3, 2.2, 2.3**** | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
via Hive2 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
|
MapR | 3.1.1, 4.0.2, 4.1* | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
via Hive2 0.13 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
|
Greenplum | 4.2, 4.3 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
MongoDB | 2.6, 3.0 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Netezza | 7.0.3, 7.1.0 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
SAP HANA | SPS 09 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Teradata | 14.10, 15.0 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Vertica | 7.0, 7.1 | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
*MapR 4.1 support was added in Jul 2015. See https://support.pentaho.com/entries/83190125-Hadoop-Shim-for-MapR-4-1 in the Pentaho Support Portal for details.
**CDH 5.4 support was added in August 2015. See https://support.pentaho.com/entries/83516765-Hadoop-Shim-for-Cloudera-CDH-5-4 in the Pentaho Support Portal for details.
*** Pentaho is pre-configured for Apache Hadoop 0.20.2.
***** You can use the HDP 2.2 shim to connect to HDP 2.2 or HDP 2.3 clusters. If you use the HDP 2.2 shim to connect to an HDP 2.3 cluster, note that only HDP 2.2 functionality is supported for the HDP 2.3 clusters.
Acronyms: PIR - Pentaho Interactive Reporting, PDD - Pentaho Dashboard Designer, PR - Published Reports, DSW - Data Source Wizard, PDI - Pentaho Data Integration, 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 |
|
Pentaho Metadata |
|
Pentaho Data Integration |
|
****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 |
|
Java Virtual Machine
Pentaho software requirements for Java Runtime Environment (JRE).
Pentaho Software | Java Runtime Environment |
---|---|
All Pentaho software, except Pentaho Mobile App |
|
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***** |
|
*****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 7.x & 8.x using Safari mobile.