View Full Version : Embedd Pentaho report(s) into our own (customer-) website, some pointers please..

09-15-2011, 09:29 AM
We are trying to have an independent java/eclipse environment that we can use to control and build our own portal and embed url links of some sort to Pentaho in it for displaying reports and analysis. Also some manipulation is required.

The only samples I can find are the ones that are embedded into the pentaho environment when actually we would like to do something of the following:
- Login using the java classes of pentaho on a remote Pentaho server
- Get the list of documents for the user (reports etc)
- Open a report and read the filters
- Display that report using a remote (url) call of some sort as part of a portal (webpart or iframe or anything that might be usefull)

We are planning on using JSP/Java within tomcat. The site will (for now) be running on the same server as Pentaho is but at some point in the future might be placed on a different server. So therefore we find it unlikely that the Pentaho login facilities can be used.

Can anyone give me some pointers?

09-15-2011, 01:41 PM
We do most of what you want to do in the report-designer publish feature. The server allows you to read the contents of the solution repository via a rather cryptic HTTP-call.

Reading the list of documents on a server: http://localhost:8080/pentaho/SolutionRepositoryService?component=getSolutionRepositoryDoc
Have a look at "libpensol" inside Pentaho reporting for a Apache-VFS plugin that handles all that ugly XML handling business for you.

Displaying the report then is a matter of calling the right URL on the server:

09-16-2011, 03:27 AM

mostly interested in the best way to remotely sign into pentaho. The url bit i found.

Am thinking of actually posting the credentials as a http post but wondering if there is a better way of doing this.