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.