You must have a report file open in order to proceed, and your data source must be
accessible before you can connect to it in Report Designer. As mentioned previously in this
guide, the first time you create a Kettle data source you must also copy all of the JAR files
from /pentaho/design-tools/data-integration/libext/ and all of its
subdirectories except the JDBC subdirectory to /pentaho/design-tools/report-designer/lib/ in order to access it through Report
Designer.
Follow this procedure to add a Pentaho Data Integration (Kettle) data source in Report
Designer.
-
Select the Data tab in the upper right pane.
By default, Report Designer starts in the Structure tab, which shares a pane with
Data.
-
Click the yellow cylinder icon in the upper left part of the Data pane, or right-click Data Sets.
A drop-down menu with a list of supported data source types will appear.
-
Select Pentaho Data Integration from the drop-down menu.
The Kettle Datasource window will appear.
-
Click the round green + icon to add a new query.
-
Type a concise yet sufficiently descriptive name into the Name field.
-
Click Browse and navigate to your Pentaho Data Integration KTR file.
-
Review the imported steps and modify their parameters accordingly, then click OK.