pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
analytics
5+ messages / 5 participants
[nested] [flat]

* analytics
@ 2004-09-22 14:21 Ben Kim <bkim@coe.tamu.edu>
  2004-09-22 14:29 ` Re: analytics Bradley Kieser <brad@kieser.net>
  2004-09-22 15:37 ` Re: analytics Ray Ontko <rayo@ontko.com>
  2004-09-22 18:19 ` Re: analytics Michael Adler <adler@pobox.com>
  0 siblings, 3 replies; 5+ messages in thread

From: Ben Kim @ 2004-09-22 14:21 UTC (permalink / raw)
  To: pgsql-admin


Dear list,

I wonder if I could get recommendations/reviews/experience for analytics
tools that can work off Postgresql database. I guess ROLAP will be the
natural solution, but is there a MOLAP engine that can work with
Postgresql database?

But established vendors' products don't seem to include support for
Postgresql. (I may be wrong so I'm seeking opinion.)

For example, Business Objects OLAP doesn't seem to work with Postgresql.
Also, this may not be directly related with the database, but could anyone
offer some opinions about Business Objects Crystal Enterprise Express?

What we want is a ready-made capability to do usual business intelligence
stuff, including analytical processing, ad-hoc report generation, allow
users to dice/slice and drilldown/rollup the data, etc.

Is there someone who uses Postgresql for data warehousing or data mining
application? If so, what tools (ETL, ad-hoc reporting, etc.) work well
with Postgresql? Is there any plans or projects for Postgresql in this
application?



Thanks.


Regards,

Ben Kim
Database Developer/Systems Administrator
College of Education 
Texas A&M University




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: analytics
  2004-09-22 14:21 analytics Ben Kim <bkim@coe.tamu.edu>
@ 2004-09-22 14:29 ` Bradley Kieser <brad@kieser.net>
  2004-09-28 14:46   ` Re: analytics Ben Kim <bkim@COE.TAMU.EDU>
  2 siblings, 1 reply; 5+ messages in thread

From: Bradley Kieser @ 2004-09-22 14:29 UTC (permalink / raw)
  To: Ben Kim <bkim@coe.tamu.edu>; +Cc: pgsql-admin

I may be wrong but I am pretty sure that Cognos can work with it.

Brad

Ben Kim wrote:

>Dear list,
>
>I wonder if I could get recommendations/reviews/experience for analytics
>tools that can work off Postgresql database. I guess ROLAP will be the
>natural solution, but is there a MOLAP engine that can work with
>Postgresql database?
>
>But established vendors' products don't seem to include support for
>Postgresql. (I may be wrong so I'm seeking opinion.)
>
>For example, Business Objects OLAP doesn't seem to work with Postgresql.
>Also, this may not be directly related with the database, but could anyone
>offer some opinions about Business Objects Crystal Enterprise Express?
>
>What we want is a ready-made capability to do usual business intelligence
>stuff, including analytical processing, ad-hoc report generation, allow
>users to dice/slice and drilldown/rollup the data, etc.
>
>Is there someone who uses Postgresql for data warehousing or data mining
>application? If so, what tools (ETL, ad-hoc reporting, etc.) work well
>with Postgresql? Is there any plans or projects for Postgresql in this
>application?
>
>
>
>Thanks.
>
>
>Regards,
>
>Ben Kim
>Database Developer/Systems Administrator
>College of Education 
>Texas A&M University
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>  
>



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: analytics
  2004-09-22 14:21 analytics Ben Kim <bkim@coe.tamu.edu>
  2004-09-22 14:29 ` Re: analytics Bradley Kieser <brad@kieser.net>
@ 2004-09-28 14:46   ` Ben Kim <bkim@COE.TAMU.EDU>
  0 siblings, 0 replies; 5+ messages in thread

From: Ben Kim @ 2004-09-28 14:46 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Bradley Kieser <brad@kieser.net>; Ray Ontko <rayo@ontko.com>; Michael Adler <adler@pobox.com>


Thanks to all who replied. 

I guess I realize odbc may work for most of the products as long as the
analytics tool works with RDBMS.

We'll be explore the Mondrian option as well.


Regards,

Ben Kim
Database Developer/Systems Administrator
College of Education 
Texas A&M University

On Wed, 22 Sep 2004, Bradley Kieser wrote:

> I may be wrong but I am pretty sure that Cognos can work with it.
> 
> Brad
> 
> Ben Kim wrote:
> 
> >Dear list,
> >
> >I wonder if I could get recommendations/reviews/experience for analytics
> >tools that can work off Postgresql database. I guess ROLAP will be the
> >natural solution, but is there a MOLAP engine that can work with
> >Postgresql database?
> >
> >But established vendors' products don't seem to include support for
> >Postgresql. (I may be wrong so I'm seeking opinion.)
> >
> >For example, Business Objects OLAP doesn't seem to work with Postgresql.
> >Also, this may not be directly related with the database, but could anyone
> >offer some opinions about Business Objects Crystal Enterprise Express?
> >
> >What we want is a ready-made capability to do usual business intelligence
> >stuff, including analytical processing, ad-hoc report generation, allow
> >users to dice/slice and drilldown/rollup the data, etc.
> >
> >Is there someone who uses Postgresql for data warehousing or data mining
> >application? If so, what tools (ETL, ad-hoc reporting, etc.) work well
> >with Postgresql? Is there any plans or projects for Postgresql in this
> >application?
> >
> >
> >
> >Thanks.
> >
> >
> >Regards,
> >
> >Ben Kim
> >Database Developer/Systems Administrator
> >College of Education 
> >Texas A&M University
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 5: Have you checked our extensive FAQ?
> >
> >               http://www.postgresql.org/docs/faqs/FAQ.html
> >
> >  
> >
> 




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: analytics
  2004-09-22 14:21 analytics Ben Kim <bkim@coe.tamu.edu>
@ 2004-09-22 15:37 ` Ray Ontko <rayo@ontko.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Ray Ontko @ 2004-09-22 15:37 UTC (permalink / raw)
  To: Ben Kim <bkim@coe.tamu.edu>; +Cc: pgsql-admin

We have been happily using Brio/Hyperion Intelligence with postgresql
via odbc.

Ray

On Wed, Sep 22, 2004 at 09:21:54AM -0500, Ben Kim wrote:
> 
> Dear list,
> 
> I wonder if I could get recommendations/reviews/experience for analytics
> tools that can work off Postgresql database. I guess ROLAP will be the
> natural solution, but is there a MOLAP engine that can work with
> Postgresql database?
> 
> But established vendors' products don't seem to include support for
> Postgresql. (I may be wrong so I'm seeking opinion.)
> 
> For example, Business Objects OLAP doesn't seem to work with Postgresql.
> Also, this may not be directly related with the database, but could anyone
> offer some opinions about Business Objects Crystal Enterprise Express?
> 
> What we want is a ready-made capability to do usual business intelligence
> stuff, including analytical processing, ad-hoc report generation, allow
> users to dice/slice and drilldown/rollup the data, etc.
> 
> Is there someone who uses Postgresql for data warehousing or data mining
> application? If so, what tools (ETL, ad-hoc reporting, etc.) work well
> with Postgresql? Is there any plans or projects for Postgresql in this
> application?
> 
> 
> 
> Thanks.
> 
> 
> Regards,
> 
> Ben Kim
> Database Developer/Systems Administrator
> College of Education 
> Texas A&M University
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: analytics
  2004-09-22 14:21 analytics Ben Kim <bkim@coe.tamu.edu>
@ 2004-09-22 18:19 ` Michael Adler <adler@pobox.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Michael Adler @ 2004-09-22 18:19 UTC (permalink / raw)
  To: Ben Kim <bkim@coe.tamu.edu>; +Cc: pgsql-admin

Mondrian just went 1.0 and support PostgreSQL. Never tried it, though.

http://perforce.eigenbase.org:8080/open/mondrian/doc/index.html

On Wed, Sep 22, 2004 at 09:21:54AM -0500, Ben Kim wrote:
> 
> Dear list,
> 
> I wonder if I could get recommendations/reviews/experience for analytics
> tools that can work off Postgresql database. I guess ROLAP will be the
> natural solution, but is there a MOLAP engine that can work with
> Postgresql database?
> 
> But established vendors' products don't seem to include support for
> Postgresql. (I may be wrong so I'm seeking opinion.)
> 
> For example, Business Objects OLAP doesn't seem to work with Postgresql.
> Also, this may not be directly related with the database, but could anyone
> offer some opinions about Business Objects Crystal Enterprise Express?
> 
> What we want is a ready-made capability to do usual business intelligence
> stuff, including analytical processing, ad-hoc report generation, allow
> users to dice/slice and drilldown/rollup the data, etc.
> 
> Is there someone who uses Postgresql for data warehousing or data mining
> application? If so, what tools (ETL, ad-hoc reporting, etc.) work well
> with Postgresql? Is there any plans or projects for Postgresql in this
> application?
> 
> 
> 
> Thanks.
> 
> 
> Regards,
> 
> Ben Kim
> Database Developer/Systems Administrator
> College of Education 
> Texas A&M University
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2004-09-28 14:46 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-22 14:21 analytics Ben Kim <bkim@coe.tamu.edu>
2004-09-22 14:29 ` Bradley Kieser <brad@kieser.net>
2004-09-28 14:46   ` Ben Kim <bkim@COE.TAMU.EDU>
2004-09-22 15:37 ` Ray Ontko <rayo@ontko.com>
2004-09-22 18:19 ` Michael Adler <adler@pobox.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox