Palo API
We support Java developers, who would like to create custom applicaitons using Palo, with the definition and development of an object oriented Java API for Palo. Using this API you can easily access Palo while implementing Java based business applications, web portals or web services. Another highlight of the current APIs is the access to XMLA supporting OLAP databases using the Java API. If you connect to a XMLA data source, you can use the same interfaces, which you use to query the Palo Server, to retrieve information about OLAP databases that support XMLA. OLAP databases that support XMLA are e.g. Microsoft Analysis Services, SAP BW or Mondrian. The Palo Java API is used by the Palo Client, Palo Web Client , Palo ETL Server and the Palo OpenOffice Addin. It is subject to constant extension and optimization. It also provides additional functionalities or utilities, which extend the core API functionality of the Palo Server. New features of new Palo Server versions are provided as soon as possible. |
![]() |
Features
The Palo Java API 1.5 has been developed for the usage of Palo Server 1.5 and is also compatible with Palo Server 2.0.
API
- Support of the HTTP Protocol
- Complete object oriented API to query and model Palo database objects
- Object oriented Java API to query databases supporting XMLA
- Utility API's to manage subsets and views
- Utility API for attribute s
- Local Cache for databases, cubes, dimensions and elements
Additional Material
- JavaDocs to document the class model
- Sample programs to show the usage to the API
Download
Click on the link below to download the Palo Java API files. The Palo Java API download files contain the API itself, the documentation (JavaDoc) and sample code.
|
Palo Java API for Palo Server 2.0 and XMLA databases |
|
You can still download the APIs for older Version of the Palo Server. The API for Palo Server Version 1.0 was based on JNI.
|
Palo Java API for Palo Server 1.5 |
Palo Java API for Palo Server 1.0c |
JPalo is also available on SourceForge.
Roadmap
Java API 3.0
- Optimized performance for XMLA Datenbanken
- Single Sign On for supported databases
- Extended view options
- Format views including traffic lights
- PDF and CSV export
- Custom Properties for all objects
- Persistence of view definitions in relational databases
- Organisation of views in folders regarding access restrictions by right definitions
