Page 1 of 1
Free OLAP Development
Posted: Mon Jun 01, 2009 11:32 am
by alevisen
I'd like to know if there exists a free tool for cube development that can connect to an Oracle 11g database. Thanks.
Re: Free OLAP Development
Posted: Tue Jun 02, 2009 7:08 pm
by Michel Zijlema
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
Re: Free OLAP Development
Posted: Wed Jun 03, 2009 5:46 am
by Marcus Scherer
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