Palo – business intelligence tool

Last Updated on July 12, 2021

Palo is an open source memory resident multidimensional (online analytical processing (OLAP) or multidimensional online analytical processing (MOLAP)) database server. This application is often deployed as a business intelligence tool for controlling and budgeting purposes with spreadsheet software acting as the user interface.

Palo Suite combines all core applications (OLAP Server, Palo Web, Palo ETL Server and Palo for Excel) into one comprehensive and customisable Business Intelligence platform. The Palo Suite allows users direct access via Microsoft Excel and Open office Calc by including Palo for Excel.

The suite includes an in-memory OLAP Server, an Ajax-based online spreadsheet with DynaRanges and a web-based ETL-Tool. Palo is the open-source version of Jedox Suite.

Features include:

• Excel Add-in.
• OLAP server:
  • Multi-user.
  • High performance data server application.
  • Real-time aggregation through its multi-dimensional data model.
• Web client:
  • Web spreadsheet.
• • Web Pivot (Java Web Client).
• • File Manager.
• • User Manager.
• • ETL Manager.
• ETL Server:
  • Extract, transform and load data from transactional systems, data warehouses and other external sources.
  • Accepts data from relational database management systems, SAP, Web services.
• XML for Analysis.
• Open (REST) API.
• Client Libraries for C/C++, Java, .NET, PHP.
• Web MOLAP Manager.
• MultiDimensional eXpressions (MDX) APIs for connectivity.
• OLE DB for OLAP interface.
• Supports SDX dialect of LINQ.

Website: www.jedox.com
Support:
Developer: Jedox AG
License: Proprietary (early versions were GNU GPL v3)

Return to Business Intelligence Home Page

Explore Linux
	Best Free and Open Source Software - A huge collection of recommended free and open source software covering every major category.
	In-depth Linux Software Reviews - Detailed assessments of Linux software covering features, usability and overall quality.
	The Big List of Active Linux Distros - An extensive collection of actively developed Linux distributions.
	Open Source Alternatives - Alternatives to software and services from Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle and others.
	Essential Linux System Tools - Indispensable utilities for monitoring, maintaining and managing Linux systems.
	Linux Productivity Tools - Useful utilities for improving productivity and streamlining everyday tasks.
	Alternatives to Popular CLI Tools - Modern alternatives to familiar command-line utilities supplied with Linux systems.
	Awesome Free Linux Game Tools - Tools, utilities and companion software that improve gaming on Linux.
	Machine Learning on Linux - Machine learning and deep learning software, self-hosted applications and practical tools.
	Saving Money with Linux - Practical ways to reduce electricity consumption and lower computing costs with Linux.
	Linux Candy - Fun, entertaining and sometimes delightfully quirky software from the lighter side of Linux.