Open Source OLAP Software

Mondrian is an OLAP (online analytical processing) engine written in Java. It reads from JDBC data sources, aggregates data in a memory cache, and implements the MDX language and the olap4j and XML/A APIs.

The PalOOCa Project offers a fast, flexible and intuitive Office-based Business Intelligence solution based on Jedox. It provides an extension for OpenOffice.org Calc which allows both, read and write, access to data from within the Jedox OLAP Server via Calc. If used together with the Open Source Jedox/Palo OLAP Server it completes the Open Source MOLAP-Stack for Business Intelligence. Additionally to Jedox OLAP it is also (read-only) compatible to (almost) all OLAP servers supporting XMLA. Intended audiences are: - scientific research & teaching - financial analysis & controlling Consult the FAQ in the Wiki.

olap4j is an open Java API for connecting to OLAP servers and writing analytic applications. Code is at https://github.com/olap4j/olap4j.

jdbc4olap is a ready-to-use JDBC 3.0 driver that provides access to OLAP databases. Relying on a relational representation of multidimensional environments, it includes a SQL-MDX converter and uses XMLA to dialog with OLAP servers.

AlphaMiner is an open source data mining platform that offers versatile data mining model building and data cleansing features with an user friendly workflow interface.

The BEE Project is a suite of tools supporting Business Intelligence project implementation including ETL tool and OLAP server and a thin client. The ROLAP server ensures multipass SQL generation and powerful cache management (utilizes MySQL RDBMS).

BIOLAP - OLAP for Genome and Biology Data Sets. This project extends Mondrian OLAP to biology data sets. We provide tools to slice and dice genomic sequence similarities and more easily explore large genomic data sets.

Reporting solution that collects data from multiple MySQL databases and presents important metrics and reports related to performance and usage.

ConDEnSE (Confidential Data Enabled Statistical Exploration) will be a web-based environment for statistical analysis of confidential data from various database sources, based on Plone and R, and using the Jackknife method of confidentiality protection.

OLAP aggregation engine with MDX support, web interface (slice & dice) and relational database backend. See "Documentation" for more. Presentation: http://cubulus.sourceforge.net/. See online demo courtesy of Webfaction, http://alxtoth.webfactional.com

DATAPTURE offers a novel way for creating Database driven PHP sites with a minimun programming. Simplify SQL queries, Intuitive Content Management System (CMS). Session Management. Enhaced XML and JSON data exchange.

A Windows multithreaded application written in C#.Net designed to provide automated discovery and processing of various forms of source data. Each feed can be processed according to a basic syntax. All input parameters are defined by XML.

Please us FREEANALYSIS Project On SourceForge for last releases - FreeOlap (now FreeAnalysis) is a complete java (Eclipse RCP) and Web (Apache Shale) application that provide Olap functions against leading Mondrian Olap Server. FreeOlap audience are user

The JasperSoft Business Intelligence Suite provides integrated reporting, analysis, and data integration to make faster, better decisions. * Integrated or stand-alone * Analytic & operational data integration * Embeddable with ERP or CRM

LucidDB is a DBMS optimized for business intelligence. Besides architectural innovations such as column-store, it supports many advanced features from SQL:2003, including SQL/MED and user-defined transformations written in Java.

MiningMart is a graphical tool for transforming data from relational databases. It provides two dual graphical views on the transformations, a data view and a process view. The focus is on the preparation of data for data mining.

something for OLAP :-)

OLAP Query Designer is a fork of JRubik, and will incorportate an all new interface and query designer. I allows querying of OLAP Datasources like Mondrian, and is based around JPivot and the Pentaho project.

OLAP mapper is an OLAP engine written in Java. It enables you to interactively analyze very large datasets stored in SQL databases without writing SQL. The main concept of application is based on the star schema visualization.

Google Web Toolkit-based tool for publishing user-friendly OLAP views, reports and dashboards. Uses Mondrian OLAP and a relational database as the back-end.

Palo ETL Server is a Java based Tool for Extraction, Transformation and Loading of mass data into the Palo OLAP Server. Palo ETL Server is one part of the Palo Suite.

Server which supports Palo MOLAP (www.jedox.com) HTTP API but uses as data storage traditional relational database.

JRubik is a set of tools for navigating and reporting over OLAP Datasources, mainly Mondrian and XMLA servers. This project is based on the components developed by the JPivot project.

Tockit tries to build a framework for Conceptual Knowledge Processing (CKP) and Formal Concept Analysis (FCA) in Java, using a component-based approach, XML formats and a three-tier architecture.

Standalone Java application to view any hierarchical data structures in a JTree. Keys and names to show in the tree are solely driven by SQL statements. The same applies to the additional node's data, which is shown in a separate table panel aside.