Palo (OLAP database)
| Palo
|
|
|---|---|
|
|
| Basic data
|
|
| developer | Jedox AG |
| Current version |
2018.1 ( June 4, 2018 ) |
| operating system | Linux , Windows |
| programming language | Java |
| License | Dual license system ( proprietary , GPL v2, LGPL and LGPL ) |
| German speaking | Yes |
| www.jedox.com | |
Palo is a memory-based, multi-dimensional Real-Time OLAP - database server ( MOLAP ) to manage business or statistical databases ( Multidimensional Database ). In addition to the multidimensional query, data can also be written back and consolidated in real time.
Palo keeps all data completely in the main memory to enable quick access to the data. The server is open source . A Microsoft Excel add-in component carries out the communication between the Palo OLAP database and Excel. A complete ETL server and client libraries are also available.
Palo can be integrated into other software environments via APIs in Java, PHP, C / C ++ or .NET. There is also an open source integration in OpenOffice.org under the name PalOOCa (Palo for OpenOffice.org Calc).
In conjunction with Microsoft Excel, Palo is used as a business intelligence and performance management application, mostly for controlling and financial planning . With Palo, any number of Excel workstations can be linked online, all of which access a central database (“ Single Point of Truth ”).
Palo is part of the Jedox business intelligence software solution . Data can be written back to the Palo OLAP database via the frontend used, both via a local Excel add-in and via a web interface. The server is available as open source and proprietary software.
The MOLAP server Palo is developed by Jedox AG from Freiburg im Breisgau .
literature
- Bernd Held, Hartmut Erb: Advanced Controlling with Excel. Corporate management with OLAP and PALO, m. CD-ROM. , Franzis, Poing 2006, ISBN 978-3-7723-7585-9
- Stefan Müller, Leif Mergener: Business intelligence in sales based on open source solutions. In: Ronald Gleich, Andreas Klein (Ed.): Marketing and Sales Controlling (The Controlling Consultant Vol. 11). Haufe-Lexware, Freiburg 2010, ISBN 978-3-648-00489-0 .
Web links
- Jedox - open source MOLAP server for Windows / Linux with Microsoft Excel interface, documentation, demos and forum
- Palo on sourceforge.net - Source code from Palo
- PalOOCa on sourceforge.net - PalOOCa: Palo for OpenOffice.org Calc
- Jedox's PALO server as an open source BI solution - IT Director, Kristian Raue, November 17, 2011
- Free open source BI tools and suites TecChannel, Dr. Klaus Manhart, September 10, 2009
Individual evidence
- ↑ Palo is now called Jedox . iBusiness, December 7, 2011.