Re: help choosing OLAP solutions that run on/with pgsql

#1

Have a look at http://www.jedox.com/

"cono" <UseLinkToEmail (AT) dbForumz (DOT) com> wrote

Quote:

Hi,

I have to choose an OLAP solution for the company I work for. I've
been pushing for months until I could finally move our servers away
from windows (we moved to FreeBSD). Now we need to build a solution
that integrates OLAP and (if possible) has a web client, and I need to
pick one that runs on linux/freebsd, and uses mysql or postgresql (I
prefer postgresql).

I came up with a few options:

-Actuate: they say they run on RH linux, not sure how good the
performance is. I don't know if they use postgresql, although I think
it's possible to use ODBC.

-Microstrategy: they say it runs on linux, not sure about the DB or
the performance

-Hyperion: I read a post of a guy who got it to run on several distros
of linux, and I've also read that it interacts with pgsql using odbc.

I apologize in advance if the information is available on vendor's
site and I couldn't find it. I am sick of corporate sites with MBA
mumbo-jumbo-BS and no useful technical info.

Any advices and information are welcomed, and if you can point me in
the right direction or simply want to share your experience even
better

thanks

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL:
http://www.dbforumz.com/OLAP-help-ch...ict237068.html
Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbforumz.com/eform.php?p=823230

#2

We have a client that is running Microstrategy on PostGreSQL 8.0,
BizGres to be precise (www.bizgres.com). However the metadata for MSTR
resides on another database, for support reasons and the server
component is running on Windows 2003, Linux might be possible but
wasn't at the time, the web component could run on a Linux based
Application server if need be.

The performance on PostGreSQL depended on the SQL generated by MSTR
(which can be tweaked) and the underlying database itself. Basically if
you can write a quicker query by hand then you can always register the
query in MSTR.

Alternatively.
Using a combination of PostGreSQL for the warehouse and Jasper or BIRT
for the reporting layer, you can achieve a certain level of OLAP
reporting. If you add Mondrian to the mix things might go a little
further but it depends on what you are trying to do.

cono wrote:

Quote:

Hi,

I have to choose an OLAP solution for the company I work for. I've
been pushing for months until I could finally move our servers away
from windows (we moved to FreeBSD). Now we need to build a solution
that integrates OLAP and (if possible) has a web client, and I need to
pick one that runs on linux/freebsd, and uses mysql or postgresql (I
prefer postgresql).

I came up with a few options:

-Actuate: they say they run on RH linux, not sure how good the
performance is. I don't know if they use postgresql, although I think
it's possible to use ODBC.

-Microstrategy: they say it runs on linux, not sure about the DB or
the performance

-Hyperion: I read a post of a guy who got it to run on several distros
of linux, and I've also read that it interacts with pgsql using odbc.

I apologize in advance if the information is available on vendor's
site and I couldn't find it. I am sick of corporate sites with MBA
mumbo-jumbo-BS and no useful technical info.

Any advices and information are welcomed, and if you can point me in
the right direction or simply want to share your experience even
better

thanks

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/OLAP-help-ch...ict237068.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=823230

#3

"" wrote:

Quote:

We have a client that is running Microstrategy on PostGreSQL
8.0,
BizGres to be precise (www.bizgres.com). However the metadata
for MSTR
resides on another database, for support reasons and the
server
component is running on Windows 2003, Linux might be possible
but
wasn't at the time, the web component could run on a Linux
based
Application server if need be.

The performance on PostGreSQL depended on the SQL generated by
MSTR
(which can be tweaked) and the underlying database itself.
Basically if
you can write a quicker query by hand then you can always
register the
query in MSTR.

Alternatively.
Using a combination of PostGreSQL for the warehouse and Jasper
or BIRT
for the reporting layer, you can achieve a certain level of
OLAP
reporting. If you add Mondrian to the mix things might go a
little
further but it depends on what you are trying to do.

cono wrote:
Hi,

I have to choose an OLAP solution for the company I work
for. I've
been pushing for months until I could finally move our
servers away
from windows (we moved to FreeBSD). Now we need to build a
solution
that integrates OLAP and (if possible) has a web client, and
I need to
pick one that runs on linux/freebsd, and uses mysql or
postgresql (I
prefer postgresql).

I came up with a few options:

-Actuate: they say they run on RH linux, not sure how good
the
performance is. I don't know if they use postgresql,
although I think
it's possible to use ODBC.

-Microstrategy: they say it runs on linux, not sure about
the DB or
the performance

-Hyperion: I read a post of a guy who got it to run on
several distros
of linux, and I've also read that it interacts with pgsql
using odbc.

I apologize in advance if the information is available on
vendor's
site and I couldn't find it. I am sick of corporate sites
with MBA
mumbo-jumbo-BS and no useful technical info.

Any advices and information are welcomed, and if you can
point me in
the right direction or simply want to share your experience
even
better

thanks

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet
standards
Topic URL: http://www.dbforumz.com/OLAP-help-ch...ict237068.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=823230

great! thank you so much for your post, I’ll look into that.

#4

Microstrategy just announced it will run on 64-bit linux, if you are
still looking into this.
http://biz.yahoo.com/prnews/050714/nyth079.html?.v=12

cono wrote:

Quote:

"" wrote:
We have a client that is running Microstrategy on PostGreSQL
8.0,
BizGres to be precise (www.bizgres.com). However the metadata
for MSTR
resides on another database, for support reasons and the
server
component is running on Windows 2003, Linux might be possible
but
wasn't at the time, the web component could run on a Linux
based
Application server if need be.

The performance on PostGreSQL depended on the SQL generated by
MSTR
(which can be tweaked) and the underlying database itself.
Basically if
you can write a quicker query by hand then you can always
register the
query in MSTR.

Alternatively.
Using a combination of PostGreSQL for the warehouse and Jasper
or BIRT
for the reporting layer, you can achieve a certain level of
OLAP
reporting. If you add Mondrian to the mix things might go a
little
further but it depends on what you are trying to do.

cono wrote:
Hi,

I have to choose an OLAP solution for the company I work
for. I've
been pushing for months until I could finally move our
servers away
from windows (we moved to FreeBSD). Now we need to build a
solution
that integrates OLAP and (if possible) has a web client, and
I need to
pick one that runs on linux/freebsd, and uses mysql or
postgresql (I
prefer postgresql).

I came up with a few options:

-Actuate: they say they run on RH linux, not sure how good
the
performance is. I don't know if they use postgresql,
although I think
it's possible to use ODBC.

-Microstrategy: they say it runs on linux, not sure about
the DB or
the performance

-Hyperion: I read a post of a guy who got it to run on
several distros
of linux, and I've also read that it interacts with pgsql
using odbc.

I apologize in advance if the information is available on
vendor's
site and I couldn't find it. I am sick of corporate sites
with MBA
mumbo-jumbo-BS and no useful technical info.

Any advices and information are welcomed, and if you can
point me in
the right direction or simply want to share your experience
even
better

thanks

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet
standards
Topic URL: http://www.dbforumz.com/OLAP-help-ch...ict237068.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=823230

great! thank you so much for your post, I'll look into that.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: help choosing OLAP solutions that run on/with pgsql

comp.databases.olap comp.databases.olap

Re: help choosing OLAP solutions that run on/with pgsql - 07-04-2005 , 11:46 PM

Re: help choosing OLAP solutions that run on/with pgsql - 07-06-2005 , 05:10 PM

Re: Re: help choosing OLAP solutions that run on/with pgsql - 07-09-2005 , 01:35 AM

Re: help choosing OLAP solutions that run on/with pgsql - 07-14-2005 , 02:08 PM