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

"" 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-choosing-solutions-run-pgsql-ftopict237068.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.
.

Relevant Pages

  • Re: Access and Postgresql
    ... end on the same machine that is hosting the Postgresql program. ... If you have a split Access database with back-end (tables, data, and ... relationships) on the server, and the front-end (queries, forms, reports, ... the fact is they are _hoping_ that it is some other software interfering ...
    (comp.databases.ms-access)
  • Re: Python Database Apps
    ... make an app that has a local DB and a server side DB. ... It maybe overkill for a client side database. ... The psycopg package makes interfacing to PostgreSQL very easy and there is a package for Linux and Windows to make cross-platform development a breeze. ... If an app comes already designed for mysql, oracle, sqlite, db2, dbm, ...
    (comp.lang.python)
  • Re: [PHP] warning message to hide
    ... PostgreSQL database, my code displays the following error message: ... Unable to connect to PostgreSQL server: could not connect to server: ... I would like instead of that, to display my own error message... ...
    (php.general)
  • Re: Access and Postgresql
    ... Purchased a billing program that uses Postgresql. ... If you have a split Access database with back-end (tables, data, and ... relationships) on the server, and the front-end (queries, forms, reports, ...
    (comp.databases.ms-access)
  • Re: help choosing OLAP solutions that run on/with pgsql
    ... the web component could run on a Linux based ... The performance on PostGreSQL depended on the SQL generated by MSTR ... and the underlying database itself. ...
    (comp.databases.olap)