Jump to content

Palo (OLAP database): Difference between revisions

Edit links
From Wikipedia, the free encyclopedia
Browse history interactively
← Previous editNext edit →
Content deleted Content added
VisualWikitext
Addbot (talk | contribs)
Bots
2,838,809 edits
m Bot: Migrating 1 interwiki links, now provided by Wikidata on d:q1671618
Ungzd (talk | contribs)
187 edits
URL changed to http://www.palo.net/
Line 11: Line 11:
|genre = [[OLAP]]
|genre = [[OLAP]]
|license = [[GNU General Public License]] (version 2) or proprietary [[EULA]]
|license = [[GNU General Public License]] (version 2) or proprietary [[EULA]]
|website = {{URL|www.jedox.com}}
|website = {{URL|http://www.palo.net/}}
}}
}}
'''Palo''' is a memory resident multidimensional ([[online analytical processing]] (OLAP) or multidimensional online analytical processing ([[MOLAP]])) [[database]] server and typically used as a [[business intelligence]] tool for [[management accounting|controlling]] and [[budget]]ing 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]]).
'''Palo''' is a memory resident multidimensional ([[online analytical processing]] (OLAP) or multidimensional online analytical processing ([[MOLAP]])) [[database]] server and typically used as a [[business intelligence]] tool for [[management accounting|controlling]] and [[budget]]ing 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]]).

Revision as of 11:24, 21 March 2013

Palo Suite
Developer(s)Jedox AG
Stable release
3.2 SR3 / May 31, 2011; 13 years ago (2011-05-31)
Operating systemCross-platform
Available inEnglish, German, French
TypeOLAP
LicenseGNU General Public License (version 2) or proprietary EULA
Websitewww.palo.net

Palo is a memory resident multidimensional (online analytical processing (OLAP) or multidimensional online analytical processing (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. To give rapid access to all data, Palo stores them in the memory during run time. The server is available as open source and proprietary software.

Jedox was founded by Kristian Raue in 2002 and developed by Jedox AG, a company based in Freiburg, Germany. The firm currently employs approximately 60 people.

Features

Palo for Excel is an open source plug-in for Microsoft Excel. There is also an open source plug-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 client libraries for Java, PHP, C/C++, or .NET Framework. It is fairly easy to communicate with Palo OLAP Server, since it uses representational state transfer (REST).

Starting in October 2008, Palo supports XML for Analysis and MultiDimensional eXpressions (MDX) APIs for connectivity, and OLE DB for OLAP interface which allows standard Excel pivot tables to serve as a client tool.[2] Starting September 2011, Palo supports SDX dialect of LINQ.

Palo also provides a web-based spreadsheet interface called Palo Web.[3]

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.

References

  1. ^ Tools, Consulting and Service for Palo
  2. ^ "Palo Open Source OLAP Server now supports MDX and Excel Pivot Tables".
  3. ^ Palo Web

Additional sources

See also

Retrieved from "https://en.wikipedia.org/w/index.php?title=Palo_(OLAP_database)&oldid=545959963"