Use the Pentaho Data Integration data source option if you want to create a report containing data from any step in a PDI transformation. As you probably know, Pentaho Data Integration is one of the core tools of the Pentaho suite and it is designed and developed to implement a fully featured ETL and data integration solution (for a complete introduction, checkout Chapter 16, Using Reports in Pentaho Data Integration). This type of data source is particularly useful if you want to create a report that includes data from transformation steps such as Excel input or other PDI steps.
Note
If you are using this type of data source, remember to copy all the JAR files from <data-integration>/lib to <report-designer>/lib in order to access it through Pentaho Report Designer.
Once this data source type is selected, a modal window is shown, as follows:
On the left side of the window the list of queries is shown with the well-known green plus icon (
...