Palo (OLAP database)
 |
|
| Developer(s) | Jedox AG |
|---|---|
| Stable release | Version 3.2 SR3 / May 31, 2011 |
| Operating system | Cross-platform |
| Available in | English, German, French |
| Type | OLAP |
| License | GNU General Public License (version 2) or proprietary EULA |
| Website | jedox.com |
Palo is a memory resident multidimensional (OLAP or MOLAP) database server and typically used as a Business Intelligence tool for Controlling and Budgeting purposes with Spreadsheet software acting as the user interface. Beyond the multidimensional data concept, Palo enables multiple users to share one centralised data storage ("Single version of the truth").
This type of database is 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 available as Open Source and Closed Source.
Jedox was founded by Kristian Raue in 2002 and developed by Jedox AG, a company based in Freiburg, Germany. The company currently employs approximately 60 people.
|
[edit] Features
Palo for Excel is a Open Source Add-in for Microsoft Excel. There is also an Open Source Add-In for OpenOffice.org named PalOOCa, with Java and web client also available from the JPalo project [1]. Palo can also be integrated into other systems via its Java, PHP, C/C++, .NET client libraries. It is fairly easy to communicate with Palo OLAP Server, since it uses REST.
Starting in October 2008, Palo supports XML for Analysis and MDX APIs for connectivity, as well as OLE DB for OLAP interface which allows standard Excel Pivot Tables to serve as a client tool.[1]
[edit] Architecture
Palo Suite is a tightly integrated framework consisting of: Palo MOLAP Server, Palo ETL Server, Palo Web (Palo Spreadsheet - Connection, User, ETL, File and Report Manager), Palo for Excel, Palo Supervision Server and the Palo Client Libraries.
The Data in Palo database is stored as a cube in the Palo MOLAP server. The Palo Excel Add-In component is used as a service to communicate between the Excel and the Palo MOLAP Server.
[edit] References
[edit] Footnotes
[edit] Additional Sources
- Bernd Held, Hartmut Erb: Advanced Controlling mit Excel. Unternehmenssteuerung mit OLAP und PALO, m. CD-ROM., Franzis, Poing 2006, ISBN 978-3-7723-7585-9 (in German)
- Guides - Documentation to Palo (pdf) in the download section of the website
- Interview with Kristian Raue - CEO of Jedox about Palo
- Business Intelligence: One Version of the Truth ComputerWorld, Julia King, 2003-12-22
- Announcing Enterprise Excel Exceluser.com, Charley Kyd, Dec 2006
- b-eye network article - Open Source OLAP in the Retail Environment. John Hobson, Feb 2008
- Palo 3.0 Manual - Advanced Palo Manual (FREE Download), Palo Toolbox, Aug 2009, (German)
- Localised RUSSIAN PALOOCA - Russian localised client Palo Server
[edit] See also
[edit] External links
- Palo - Open-Source MOLAP Server for Windows/Linux and Microsoft Excel interface, documentation, demos and forum
- Palo project on SourceForge.net - Palo project on SourceForge.net
- Palo project page on ohloh.net - Palo project page on ohloh.net
- JPalo - Java software for Palo
- Russian Forum - Forum Russian users
