analytics

Discussion:

analytics

(too old to reply)

Ben Kim

2004-09-22 14:21:54 UTC

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

Bradley Kieser

2004-09-22 14:29:14 UTC

Permalink

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

Brad

Post by Ben Kim
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Ben Kim

2004-09-28 14:46:01 UTC

Permalink

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

Post by Bradley Kieser
I may be wrong but I am pretty sure that Cognos can work with it.
Brad

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

Ray Ontko

2004-09-22 15:37:41 UTC

Permalink

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

Ray

----------------------------------------------------------------------
Ray Ontko ***@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

Michael Adler

2004-09-22 18:19:05 UTC

Permalink

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

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html