Try Pentaho Data Integration and Analytics

Pentaho Tools

This table summarizes which data sources are compatible with the main Pentaho tools.

Pentaho Software

Data 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 a list of drivers to use with relational JDBC databases, see the JDBC drivers reference.

PreviousData Sources: GeneralNextBig Data Sources: General

Last updated

Was this helpful?