Skip to content

>Using a Pentaho Data Integration Data Source with the Pentaho Report Designer

May 10, 2011


Pentaho Report Designer can consume an exported Pentaho Data Integration Transformation file (.ktr) as a data source to provide data to a Pentaho Report. The following steps walk you through the best practice when using this type of data source.

1. Export your transform to XML… from Pentaho Data Integration and save your .ktr file to a location on your computer

2. Import your transformation into your report as a Resource. In Report Designer, create a new blank report, select File -> Resources… -> IMPORT -> Select the “..” and browse to the transformation you exported in step 1, input an Entry Name (this name will be referenced later so please remember it), and then select text/xml for the Content-Type, then click OK and Close.

3. Right click on Data Sets and Select “Pentaho Data Integration”, click the “add a new query” button

4. Build your report and publish it to the server as you normally would.

5. Please note that a Transformation with a limited result set (limited number of rows) is recommended at first. The design process will pull data from the transformation in real-time.

6. Publish to and access from Pentaho BI Server as you normally would any other Pentaho Report

7. There is a reference Techcast in greater detal located here:

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: