On Sat, Jun 27, 2009 at 02:04:13PM -0700, Michal Szymanski wrote: > > > I've used Pentaho with pgsql and it worked pretty well. I'm pretty > > sure jasper as well can work with pgsql. > > Where can I find information how to install Pentaho on Postgres? Do > you use free edition? We also both the free and enterprise versions, and both work with PostgreSQL. Note that there are two different things you might be talking about, here: 1) PostgreSQL contains your data warehouse, or pieces thereof. 2) PostgreSQL contains the Pentaho repository The first is easy; simply configure data sources pointed at the PostgreSQL database. Note that the JDBC drivers that ship with Pentaho are, in my experience, of inconsistent version, and you might want to update them to the latest available for your PostgreSQL and Java versions. The second is more difficult, but also very possible. There are PostgreSQL scripts in Pentaho's biserver/data/postgresql directory. These create the necessary databases. Though they're poorly written, IMO, they'll give you a good idea what you really need to create. The hardest bit is editing all the configuration files for the various bits of the Java stack (spring, hibernate, acegi, pentaho...). It's best to find instructions for using MySQL as the repository, and substitute "PostgreSQL" for "MySQL". One possible such reference is http://www.prashantraju.com/pentaho/guides/biserver-2.0-final/biserver2.0-local-final.pdf - Josh / eggyknap
Attachment:
signature.asc
Description: Digital signature
