Big Data Sources: Details
This table shows the Big Data sources that are compatible with specific Pentaho tools.
Data Source
Versions
Analyzer
PIR/PDD
Pentaho Reporting
DSW
PDIServer/Client
PRD
PSW
PME
Amazon EMR
5.21, 5.24, 5.32f
Yes
Yes
No
No
Yes
Yes
No
Yes
Cloudera
6.1, 6.2, 6.3a (for job execution)
No
No
No
No
Yes
Yes
No
Yes
via Hive2c(as data source)
No
Yes
Yes
Yes
Yes
Yes
No
Yes
Cloudera Data Platform
7.1.x (for job execution)
No
No
No
No
Yes
Yes
No
Yes
via Hive3i (as data source)
No
Yes
Yes
Yes
Yes
Yes
No
Yes
Datastax
4.6, 4.8
No
No
No
No
Yes
No
No
No
Google Dataprocg (for job execution)
1.4, 2.2j
No
No
No
No
Yes
Yes
No
No
via Hive2 and Google BigQuery (as data source)
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
Greenplum
4.2, 4.3
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Hortonworks
3.0, 3.1
(for job execution)
No
No
No
No
Yes
Yes
No
Yes
via Hive2c(as data source)
No
Yes
Yes
Yes
Yes
Yes
No
Yes
via Spark SQLd
(as data source)
No
No
No
No
Yes
No
No
No
Microsoft Azure HDInsight
4.0
Yes
Yes
No
No
Yes
No
No
Yes
MongoDB
4.0.2
No
No
Yes
No
Yes
Yes
No
No
Netezza
7.1, 7.2
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
SAP HANA
SPS
No
No
No
No
Yes
No
No
No
Teradata
14.10, 15.0
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Vertica
9.3.0.0
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Notes: A generic Apache Hadoop driver is included in the Pentaho distribution for version 9.3: Other supported drivers can be downloaded from the Hitachi Vantara Lumada and Pentaho Support Portal.a You must have the current version of the Pentaho release to use the CDH 6.1 driver. The CDH 6.1 driver 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 driver 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.
dThe Simba Spark SQL driver needs to be downloaded, installed, and configured to be used as a data source for Hortonworks. See our Install Pentaho Data Integration and Analytics document for more information.
e The Simba driver required for Google BigQuery is the JDBC 4.2-compatible version. See https://storage.googleapis.com/simba-bq-release/jdbc/SimbaJDBCDriverforGoogleBigQuery42_1.2.2.1004.zip.
f Use the EMR 5.21 driver for your EMR 5.24 or EMR 5.32 cluster. The EMR 5.21 driver is certified to work for EMR 5.24 and EMR 5.32.
g HBase is not supported with Google Dataproc.
h 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.
i Hive3 as a data source for CDP also supports Hive LLAP, and Hive3 on Tez.
j 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.
Last updated
Was this helpful?