Free OLAP Development

Not related to a specific OLAP tool. (Includes forum policies and rules).
Post Reply
alevisen
Posts: 1
Joined: Mon Jun 01, 2009 11:26 am
Version: 9.1 sp3
Excel Version: 2003

Free OLAP Development

Post by alevisen » Mon Jun 01, 2009 11:32 am

I'd like to know if there exists a free tool for cube development that can connect to an Oracle 11g database. Thanks.

User avatar
Michel Zijlema
Site Admin
Posts: 701
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Free OLAP Development

Post by Michel Zijlema » Tue Jun 02, 2009 7:08 pm

alevisen wrote:I'd like to know if there exists a free tool for cube development that can connect to an Oracle 11g database. Thanks.
PALO is an open source OLAP tool from Jedox. You can use their ETL Server to connect (through ODBC) to Oracle 11g. You could also use the freeware IMP:PALO tool to connect (through ODBC) to Oracle and load into PALO.

Michel

Marcus Scherer
Community Contributor
Posts: 125
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 9.5 10.1 10.2
Excel Version: 2007
Location: Karlsruhe

Re: Free OLAP Development

Post by Marcus Scherer » Wed Jun 03, 2009 5:46 am

You could use Pentaho Mondrian,
it's a different concept. The data storage takes place in the relational database. Mondrian has no storage of its own. Thus the cube is a virtual one. It uses the RDBMS aggregator (GROUP BY) for aggregating and materialized views of the relational database. You can base it on an existing dimensional model. It is queried with MDX. But there is no writeback.

http://mondrian.pentaho.org/documentati ... ecture.php

Regards,

Marcus

Post Reply