Open Source Linux OLAP Software

Pentaho couples data integration with business analytics in a modern platform to easily access, visualize and explore data that impacts business results. Use it as a full suite or as individual components that are accessible on-premise, in the cloud, or on-the-go (mobile). Pentaho enables IT and developers to access and integrate data from any source and deliver it to your applications all from within an intuitive and easy to use graphical tool. The Pentaho Enterprise Edition Free Trial can be obtained from https://pentaho.com/download/

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.

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

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.

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.

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.

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.

Advanced Analysis Services is a Business Intelligence (BI) tool to let users analyze OLAP sources like Pentaho, Mondrian, Microsoft Analysis Services (MSAS) or Hyperion, in an intuitive way, based on analysis templates like Paretto, Ranking and BCG

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

FreeAnalysis is a complete java (Eclipse RCP) and Web 2.0 (Dojo) application that provide Olap functions against Pentaho Mondrian Olap Server and other MDX/XMLA compliant cubes datasources such as Microsoft Analysis or Hyperion.

Syoncloud Logs enables you to process log files from various applications using Hadoop, Flume and HBase. It has an easy installation and configurations interface. It has Syoncloud HBase web client. It displays tree of HBase tables and column families linked to paginated grid of data.

Comprehensive & high performance data distribution &transformation system. Features a simple, user-friendly event driven scripting interface transparently generates & execs highly efficient Perl/C code. Uses:ETL,datawarehousing,statistics,data-cleansing.

911 Call Tracker is a Java app that tracks 911 phone calls. It provides detailed reports of: calls per operator/answer times, abandoned calls/ring times, calls over answer limit and more. Provides real-time access to call info,TDD,address, and cell info.

With Alfresco Audit Analysis and Reporting (A.A.A.R.) is provided a solution to extract, store and query audit data together with the document/folder informations at a very detailed level, with the goal to be useful to the end-user in a very easy way. To reach that goal, to make the data more friendly for the end-user, the data are published in reports in well-known formats (pdf, Microsoft Excel, csv, etc.) and stored directly in Alfresco as static documents organized in folders, versioned, authorized and published. On the top of the A.A.A.R. solution, the A.A.A.R. Analytics is a set of powerful tools to analyze data in an interactive and customizable way with a user console composed by dashboards, reports and free analysis.

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.

Use Pentaho open source business intelligence tools and MySQL to collect & distribute web analytics (clickstream) data. Extract data from logs, load database tables, & present the information in dashboards, analysis cubes, and reports for business users. This project has been moved to github - https://github.com/cjlavigne/breadboard

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

Creating beautiful dashboards and thousands of reports that can be embedded into your application can be easily done with Caxpy. Its a very lightweight application which can be used to create reports from just plain SQL queries.

Chaman is a web-based, relational OLAP tool, built over Apache Cocoon.

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.

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.

DeciGen is an ERP with added features for help in decision making process. DeciGen incorporates Decision Support System over an framework of ERP to provide a feature rich solution. It aims to achieve the final goal of IT - to run business smoothly. Dec

We have develop data mining 'Plug and Play' WYSIWYG Tool on commercial ERP Baan IVc4 which uses Baan 4 GL as extract and transform engine and MS excel as load client . For more information about the tool and the company , please visit www.erpjewels.com

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