Palo (OLAP database)

Palo is a memory resident multidimensional (OLAP or MOLAP) database server. This type of database is particularly suitable to handle complex data models for business management and statistics. Apart from multidimensional queries, data can also be written back and consolidated real-time. In order to give rapid access to all data, Palo stores them in the memory during run time. The server is Open Source and there is a free Add-In for Microsoft Excel. Palo can also be integrated into other systems via its Java, PHP, C and .NET interfaces.

Palo is typically used as a Business Intelligence tool for Controlling and Budgeting purposes with Microsoft Excel as a user interface. Beyond the multidimensional data concept, Palo enables multiple users to share one centralised data storage ("Single version of the truth").

Palo is being developed by Jedox, a company based in Freiburg (Germany).