PDA

View Full Version : Pentaho With PHP



silnachandra.madayi
09-09-2008, 06:37 AM
Hi

Is there a way to make PHP work for Pentaho.
I read some blogs at pentaho community forums
http://forums.pentaho.org/archive/index.php/t-25955.html (http://forums.pentaho.org/archive/index.php/t-25955.html)

If this is not done .....What steps needs to be followed for PHP to work with pentaho ..?:confused:

Thanks
Silna

nbaker
09-09-2008, 08:26 AM
As far as I know, we have no direct integration with PHP. You can find various techniques for bridging between the two languges on the web, just google "PHP Java".

I've used the stock PHP/Java integration before with mixed success. It allows you to interact with Java objects as if they were PHP objects.
http://us3.php.net/java

My most successful work used CURL to invoke web services I had written in Java on the application server. That's assuming you have java development skills. Lacking that, you can always "screen-scrape" reports from your Pentaho server with CURL. You would need to setup detection for the login page being shown, re-log in and then run the request again.

There seems to be a rich tradition on the web for the latter:
http://www.google.com/search?q=PHP+screen+scrape+curl+xpath

Lastly, you may want to consider picking up some Java skills and write some servlets to handle Pentaho integration. If you've made the transition to full OO PHP 5, then you're not that far away.

-Nick Baker

mlowery
09-15-2008, 10:31 AM
I second the web service approach. Try doing a search on these forums for web services.

guzaldon
09-16-2008, 06:48 PM
I had some good conversation about this.

check out
http://forums.pentaho.org/showthread.php?t=60751

should bring you up to speed.

in short I wanted a php portal to utilize pentaho. the best solution is to utilize the SOAP aspect of pentaho and feed that into your php portal.

Instead of messing with all that. I decided to investigate Liferay and pentaho intergration and you should be able to find a bunch of info about that.

Hope that might help.

Nic