Agenda
Data are always part of the game.
Company Jedox
Overview of the solution of Jedox
Installation
Palo – Analyze Data
ETL – Build ETL Process
Summary
Company Jedox
German Company, Freiburg
specialist of
planning, analysis and reporting systems multidimensional In-Memory OLAP
Excel und Enterprise Spreadsheets
offer of commercial open software
partner of
SAP AG und Deutsche Forschungsgemeinschaft
rapid growth
Agenda
Data are always part of the game.
Company Jedox
Overview of the solution of Jedox
Installation
Palo – Analyze Data
ETL – Build ETL Process
Summary
Palo Open Source Business Intelligence Suite
JPalo
Java full client
Palo OLAP Server
64 Bit In-Memory OLAP database
Palo Supervision Server
compliance module for the Palo OLAP Server
Palo Worksheet Server
JPalo (1)
Universal Java api
Read data and meta data from Palo and other OLAP Databases (XMLA, SAP BW, Mondrian) to create palo databases
Java full client
Reporting and modeling of Palo databases and reports of OLAP databases (XMLA)
Web client
Zero installation client with latest technology
JPalo (2)
WebClient von Tensegrity, Köln
Palo OLAP Server
Multidimensional database
thinking in terms of cubes and dimensions and cells
Memory-based & real-time
Palo is a memory-based database, calculation in memory, basically means
speed
Server-bases
installed locally or server
Front-end Microsoft Excel
basically front-end is Microsoft Excel, alternative Web-Front-end
Write-back
New data directly into the cube, save data and calculated the aggregation in the
cube
Palo Supervision Server (1)
Monitor and control data
Monitors, controls and logs all data inputs made in Enterprise Spreadsheet and
Palo OLAP Server
Warning and alert
Supervision Server can trigger warnings and alerts, correct inputs
Central Event and Process management
Linkages between Palo data ranges and supervision scripts, written in PHP or
Java
Palo Supervision Server (2)
Client A Client B
Palo Server
Supervision Server
PHP Script for client A
„GetTriggeringArea“ PHP Script for client B„OnUserLoginIn“
change a value
in datacell of cube Palo serverlogin on
datacell receive limit of value
PHP Script for limit „SendEmail“
Palo Worksheet Server (1)
Web application
Modeling web application, based on excel sheets
Easy usability
Business users develop with Excel reports and publish with Worksheet Server
Not an Open Source Software
Palo ETL Server (1)
Focus on OLAP and Palo
Integrate data from different sources:
Flat files (csv, text) with
ODBC (DB2, Oracle, MySQL, Microsoft SQL Server, JDBC)
ODBO (Palo)
LDAP
SAP (end of 2008)
User Interface
Define the ETL Process in XML, integrated in Eclipse Dev. Tool
Drill Through
Agenda
Data are always part of the game.
Company Jedox
Overview of the solution of Jedox
Installation
Palo – Analyze Data
ETL – Build ETL Prozess
Summary
Installation
Agenda
Data are always part of the game.
Company Jedox
Overview of the solution of Jedox
Installation
Palo – Analyze Data
ETL – Build ETL Process
Summary
Palo – Analyse Data (1)
Palo – Analyse Data (2)
Palo – Analyse Data (3)
Agenda
Data are always part of the game.
Company Jedox
Overview of the solution of Jedox
Installation
Palo – Analyze Data
ETL – Build ETL Process
ETL – Build ETL Process (2)
Structure of xml file
<project>
<connections> connection to databases
<connection> </connection> </connections> <sources> <source> </source> </sources> <pipelines> transformations <pipeline> </pipeline> </pipelines>
<exports> cube, dimension, flates create, add or update
<export> </export>
Agenda
Data are always part of the game.
Company Jedox
Overview of the solution of Jedox
Installation
Palo – Analyze Data
ETL – Build ETL Process
Palo Strengths and Weaknesses
Easy to install
Basic functions of OLAP
Good integration in Microsoft Excel API for Java
Integration enterprise web portal (but not open source)
64 bit version for large data volume
Other commercial or open source analysis tool use Palo
No business functions (e.g. planning) Small or medium data volume
Medium performance (e.g. calculation) Small user administration
Palo - Core Messages
Knowledge transfer is only the beginning. Knowledge application is what counts.
