Skip to main content
Version Pentaho
Hitachi Vantara Lumada and Pentaho Documentation

Supported Data Sources

  1. Last updated
  2. Save as PDF

Pentaho Report Designer supports the following data source types:

  • JDBC: Any JDBC-compliant database will work with Report Designer, but you will probably have to provide your own JDBC driver JAR. This is accomplished by copying the appropriate JAR file to the /pentaho/design-tools/report-designer/lib/ directory.
  • Metadata: A Pentaho Metadata XMI file.
  • Pentaho Data Integration (Kettle): Kettle KTR files can act as a data source, but you must copy all of the JAR files from /pentaho/design-tools/data-integration/lib/ and all of its subdirectories except the JDBC subdirectory to /pentaho/design-tools/report-designer/lib/.
  • OLAP: Report Designer only supports Pentaho Analysis (Mondrian) OLAP sources at this time.
    • Pentaho Analysis: A Mondrian schema file.
    • Pentaho Analysis Denormalized: A Mondrian schema file, denormalized.
    • Pentaho Analysis Legacy: A Mondrian data source imported from a report created with a version of Report Designer older than 3.5.0.
  • XML: An XQuery file.
  • Table: Create your own data table by entering information manually, or importing it from an Excel spreadsheet file (XLS).
  • MongoDB: Use data stored in this document-oriented NoSQL database.
  • Advanced: The data sources in this category are typically for software developers and special-use cases.
    • JDBC (Custom): Allows designers to dynamically create a query from a formula or function.
    • Scriptable: Allows designers to generate a data set via JavaScript, Bean Shell, Groovy, Netrexx, XSLT, JACL, or Jython.
    • External: Used only if the report is going to run on the Pentaho Server, which means the data is retrieved via a component in an action sequence. The query name for the report has to be mapped to the result set in the .xaction file.