reporting solution for postgresql

Started by Dino Vlietalmost 21 years ago4 messagesgeneral
Jump to latest
#1Dino Vliet
dino_vliet@yahoo.com

Hi folks,

Maybe a little bit off topic, but I want to convince
my managers of the value of opensource products and
decided that I will reverse engineer the datawarehouse
at my company. We are a small player and our
datawarehouse solution is based on an ETL tool from
Informatica, Oracle and Business Objects.

I have already written the most ETL defenitions in
Ruby. So I will manage to get the data in the
postgresql database, in a star schema.

However, to convince management I need a slick,
opensource reporting tool to show the reports that
already have been defined in Business Objects. Or I
should try to use Business Objects through ODBC.

Can anyone tell me about his/her findings in a similar
approach?
What decent but opensource Query tools exist today
which can support this architecture (web based OR a
client-server), where the clients MUST be windows 2000
because that's what they use at the office.

Thanks in advance and hope I will get some good
feedback (as I always do from this excellent list)

Brgds
Dino

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

#2Aly Dharshi
aly.dharshi@telus.net
In reply to: Dino Vliet (#1)
Re: reporting solution for postgresql

Hello Dino,

I think that there is something called openrpt http://www.openrpt.com/ have you
looked at this ?

Cheers,

Aly.

Dino Vliet wrote:

Hi folks,

Maybe a little bit off topic, but I want to convince
my managers of the value of opensource products and
decided that I will reverse engineer the datawarehouse
at my company. We are a small player and our
datawarehouse solution is based on an ETL tool from
Informatica, Oracle and Business Objects.

I have already written the most ETL defenitions in
Ruby. So I will manage to get the data in the
postgresql database, in a star schema.

However, to convince management I need a slick,
opensource reporting tool to show the reports that
already have been defined in Business Objects. Or I
should try to use Business Objects through ODBC.

Can anyone tell me about his/her findings in a similar
approach?
What decent but opensource Query tools exist today
which can support this architecture (web based OR a
client-server), where the clients MUST be windows 2000
because that's what they use at the office.

Thanks in advance and hope I will get some good
feedback (as I always do from this excellent list)

Brgds
Dino

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Aly Dharshi
aly.dharshi@telus.net

"A good speech is like a good dress
that's short enough to be interesting
and long enough to cover the subject"

In reply to: Aly Dharshi (#2)
Re: reporting solution for postgresql

Try http://www.agata.org.br/us/index.php
Is very good and free

Show quoted text

On 5/24/05, Aly Dharshi <aly.dharshi@telus.net> wrote:

Hello Dino,

I think that there is something called openrpt http://www.openrpt.com/have you
looked at this ?

Cheers,

Aly.

Dino Vliet wrote:

Hi folks,

Maybe a little bit off topic, but I want to convince
my managers of the value of opensource products and
decided that I will reverse engineer the datawarehouse
at my company. We are a small player and our
datawarehouse solution is based on an ETL tool from
Informatica, Oracle and Business Objects.

I have already written the most ETL defenitions in
Ruby. So I will manage to get the data in the
postgresql database, in a star schema.

However, to convince management I need a slick,
opensource reporting tool to show the reports that
already have been defined in Business Objects. Or I
should try to use Business Objects through ODBC.

Can anyone tell me about his/her findings in a similar
approach?
What decent but opensource Query tools exist today
which can support this architecture (web based OR a
client-server), where the clients MUST be windows 2000
because that's what they use at the office.

Thanks in advance and hope I will get some good
feedback (as I always do from this excellent list)

Brgds
Dino

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Aly Dharshi
aly.dharshi@telus.net

"A good speech is like a good dress
that's short enough to be interesting
and long enough to cover the subject"

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

#4Geoffrey
esoteric@3times25.net
In reply to: Evandro's mailing lists (Please, don't send personal messages to this address) (#3)
Re: reporting solution for postgresql

Listas Evandro (N�o use este endere�o para mensagens pessoais) wrote:

Try http://www.agata.org.br/us/index.php
Is very good and free

We looked at agata, but I have a real problem with the following
installation instructions on the agata page:

rpm -i --force <package>

That's not something I care to do (--force) in a production environment,
particularily with 9 different rpms. There's no telling what else you
might break.

Further, we could not get it to build on RHWS 4, which is our
development environment.

Limited documentation is available in English, which may or may not be a
problem with others on the list.

--
Until later, Geoffrey