Обсуждение: reporting solution for postgresql
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
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"
Re: reporting solution for postgresql
От
Listas Evandro (Não use este endereço para mensagens pessoais)
Дата:
Is very good and free
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
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