Free OLAP Development
Free OLAP Development
I'd like to know if there exists a free tool for cube development that can connect to an Oracle 11g database. Thanks.
- Michel Zijlema
- Site Admin
- Posts: 712
- 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
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.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.
Michel
-
- Community Contributor
- Posts: 126
- Joined: Sun Jun 29, 2008 9:33 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
- Location: Karlsruhe
Re: Free OLAP Development
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
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