- Previous thread: [GENERAL] pasting into psql garbles text
- Next thread: [GENERAL] Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
- Threads sorted by date: pgsql 200906
Hi,
I'm looking for free software that provide OLAP functionality (or more
general BI) for data that are stored in Postgres database. I've found
Pentaho and Jasper but both sollution are configured for MySQL. Can
you recomend something that works with postgres?
Regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm looking for free software that provide OLAP functionality (or more
general BI) for data that are stored in Postgres database. I've found
Pentaho and Jasper but both sollution are configured for MySQL. Can
you recomend something that works with postgres?
Regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, Jun 27, 2009 at 1:45 PM, Michal Szymanski wro=
te:
> Hi,
> I'm looking for free software that provide OLAP functionality (or more
> general BI) for data that are stored in Postgres database. I've found
> Pentaho and Jasper =A0but both sollution are configured for MySQL. Can
> you recomend something that works with postgres?
I've used Pentaho with pgsql and it worked pretty well. I'm pretty
sure jasper as well can work with pgsql.
--=20
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
te:
> Hi,
> I'm looking for free software that provide OLAP functionality (or more
> general BI) for data that are stored in Postgres database. I've found
> Pentaho and Jasper =A0but both sollution are configured for MySQL. Can
> you recomend something that works with postgres?
I've used Pentaho with pgsql and it worked pretty well. I'm pretty
sure jasper as well can work with pgsql.
--=20
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Scott Marlowe wrote:
> On Sat, Jun 27, 2009 at 1:45 PM, Michal Szymanski wrote:
>> Hi,
>> I'm looking for free software that provide OLAP functionality (or more
>> general BI) for data that are stored in Postgres database. I've found
>> Pentaho and Jasper but both sollution are configured for MySQL. Can
>> you recomend something that works with postgres?
>
> I've used Pentaho with pgsql and it worked pretty well. I'm pretty
> sure jasper as well can work with pgsql.
It can -- just use JDBC
Joe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> On Sat, Jun 27, 2009 at 1:45 PM, Michal Szymanski wrote:
>> Hi,
>> I'm looking for free software that provide OLAP functionality (or more
>> general BI) for data that are stored in Postgres database. I've found
>> Pentaho and Jasper but both sollution are configured for MySQL. Can
>> you recomend something that works with postgres?
>
> I've used Pentaho with pgsql and it worked pretty well. I'm pretty
> sure jasper as well can work with pgsql.
It can -- just use JDBC
Joe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> I've used Pentaho with pgsql and it worked pretty well. =A0I'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?
Regards
Michal Szymanski
--=20
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, Jun 27, 2009 at 3:04 PM, Michal Szymanski wro=
te:
>
>> I've used Pentaho with pgsql and it worked pretty well. =A0I'm pretty
>> sure jasper as well can work with pgsql.
>
> Where can =A0I find information how to install Pentaho on Postgres? Do
> you use free edition?
We used the free version, and the docs that came with it covered jdbc
connection. It's been a couple of years since I was part of that
project, so the memories aren't real clear. Just remember hooking it
up to pgsql was the easy part.
--=20
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
te:
>
>> I've used Pentaho with pgsql and it worked pretty well. =A0I'm pretty
>> sure jasper as well can work with pgsql.
>
> Where can =A0I find information how to install Pentaho on Postgres? Do
> you use free edition?
We used the free version, and the docs that came with it covered jdbc
connection. It's been a couple of years since I was part of that
project, so the memories aren't real clear. Just remember hooking it
up to pgsql was the easy part.
--=20
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, Jun 27, 2009 at 02:04:13PM -0700, Michal Szymanski wrote:
>=20
> > I've used Pentaho with pgsql and it worked pretty well. =A0I'm pretty
> > sure jasper as well can work with pgsql.
>=20
> 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 PostgreSQ=
L.
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 t=
he
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, hiberna=
te,
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-l=
ocal-final.pdf
- Josh / eggyknap
>=20
> > I've used Pentaho with pgsql and it worked pretty well. =A0I'm pretty
> > sure jasper as well can work with pgsql.
>=20
> 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 PostgreSQ=
L.
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 t=
he
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, hiberna=
te,
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-l=
ocal-final.pdf
- Josh / eggyknap
> 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.
>
In my experience you don't want to upgrade the jars that come with
Pentaho. If it is not the versions that they come with the chances are
that things will not work. The JDBC driver might be upgradeable, I
believe we downloaded that by ourselves.
Also we had a much better experience with Jasper (free version) then
Pentaho (free version).
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jun 29, 2009 at 09:02:30AM +0300, Sim Zacks wrote:
>=20
> > The first is easy; simply configure data sources pointed at the Postgre=
SQL
> > 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.
> > =20
> In my experience you don't want to upgrade the jars that come with
> Pentaho. If it is not the versions that they come with the chances are
> that things will not work. The JDBC driver might be upgradeable, I
> believe we downloaded that by ourselves.
We've not had problems upgrading the JDBC drivers (or indeed installing the=
m,
as IIRC, some components just haven't had a PostgreSQL driver in the default
installation). Your Mileage May Vary. We haven't touched any other libraries
that ship with Pentaho, which I tend to think is a wise decision on our part
:)
> Also we had a much better experience with Jasper (free version) then
> Pentaho (free version).
When we tried to decide between the two, we took both out for brief test
drives. They seemed almost functionally equivalent, and there were no major
advantages or deficiencies we found to indicate one over the other. But tha=
t's
a decision made with regard only to those features we cared about.
- Josh / eggyknap
>=20
> > The first is easy; simply configure data sources pointed at the Postgre=
SQL
> > 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.
> > =20
> In my experience you don't want to upgrade the jars that come with
> Pentaho. If it is not the versions that they come with the chances are
> that things will not work. The JDBC driver might be upgradeable, I
> believe we downloaded that by ourselves.
We've not had problems upgrading the JDBC drivers (or indeed installing the=
m,
as IIRC, some components just haven't had a PostgreSQL driver in the default
installation). Your Mileage May Vary. We haven't touched any other libraries
that ship with Pentaho, which I tend to think is a wise decision on our part
:)
> Also we had a much better experience with Jasper (free version) then
> Pentaho (free version).
When we tried to decide between the two, we took both out for brief test
drives. They seemed almost functionally equivalent, and there were no major
advantages or deficiencies we found to indicate one over the other. But tha=
t's
a decision made with regard only to those features we cared about.
- Josh / eggyknap