Jedox

Jedox is a client-server software for creating business intelligence and performance management solutions for the systematic analysis of data. The central component is a cell- oriented, multi-dimensional in-memory OLAP server, which was developed specifically for use in planning, analysis, reporting and data consolidation. The software has a modular structure and uses for a Microsoft Excel as the user interface, the other a Jedox own spreadsheet ( spreadsheet ), which can be used in popular browsers. Jedox is developed by the same software company Jedox from Freiburg im Breisgau.

Areas of application and dissemination

Jedox was developed especially in the area of ​​planning, analysis and reporting and data consolidation for tasks and can be used sectors and across disciplines. Basic principle of the software is that Jedox extracted the necessary operating data from legacy systems, this brings in executable form of analysis and different user groups in need-based evaluations or access through a range of user-friendly front-ends provides.

The peculiarity of the software consists in the fact that not only past-oriented business intelligence applications, such as OLAP analysis and reporting, are covered, but also performance management solutions, such as what-if analysis, demand planning, simulations, budgeting, financial planning and balanced scorecards can be created.

Jedox is used in some 120 countries and is delivered in 23 languages. Companies that have built up with Jedox business intelligence and performance management solutions that include the Süddeutsche Verlag, Metro Group, Endress Hauser and Swissport.

Components

OLAP server

The OLAP database Jedox is a memory-based, multi-dimensional real-time OLAP Server (MOLAP ) to manage business or statistical datasets ( multidimensional database). In addition to query multidimensional data can also be written back ( write back) and are consolidated in real time. The server keeps all data in memory to allow fast access to data. About APIs in Java, PHP, C / C or. NET Jedox OLAP database can be integrated into other software environments.

Excel Add- in

A Microsoft Excel add- in component manages communication between the Jedox OLAP database and the Excel front-end. Any number of Excel jobs online can be linked together, all on a central database access ( Single Point of Truth ). The data written in Microsoft Excel data is written back on the add-in in the OLAP cube structure and aggregated. By using the known Excel interface, business users can without IT skills to work independently with Jedox and implement plans, analyzes and reports.

Web client

About the Jedox Web client users can access from a Web browser on the centrally stored data from the OLAP database. Local reports created are transformed into server-based web applications and called in the web browser and adjusted. In Web mode analysis results and modifications to existing reports can be consistently written back to the database. Analysis and calculation models with Excel will be provided via the Web browser several users available without requiring an installation of Microsoft Excel. Users access to the web browser, therefore, a mobile terminal to the OLAP database.

GPU module

The optional GPU module Jedox uses computing power and memory of Nvidia Tesla GPUs for the analysis of corporate data. Complex OLAP calculations are the GPU additional component, compared with an Intel multi-core architecture to accelerate a multiple of, the acceleration factor depends on the particular data model. Developed in collaboration with the University of Freiburg and the University of Western Australia Perth GPU module is mainly used in multi-dimensional data analysis use. The GPU component is switched on the server side. You needed to on the graphics card, no additional hardware installation.

Extraction Tool

Jedox ETL is a client- server - based application for automated data import, which extracts data from heterogeneous sources, transformed and in the Jedox OLAP server uploads. The ETL component works with all major relational database systems such as Oracle, Microsoft SQL Server, MySQL and PostgreSQL, and linked them via JDBC interface. In addition, users can extract more data from flat files, XML files, Web services, and LDAP systems. Through a SOAP-based web service interface to Jedox ETL can be integrated into other software applications. In addition to the data import into Jedox the ETL module also supports the " drill-through " from the OLAP database to the document data in the source systems.

SAP interface

As an additional interface of Jedox SAP connector, a specially tailored to SAP landscapes ETL module acts. The component supports all SAP Netweaver based SAP systems, such as SAP R / 3, SAP ERP and SAP Business Warehouse ( BW). This integrated business intelligence and performance management solutions Jedox in existing SAP systems.

ODBO XMLA interface

Jedox ODBO XMLA is an additional component of Jedox. About this standard interface, all ODBO -enabled Windows clients, such as Microsoft Excel Pivot Tables and XMLA based web service consumers to access Jedox data and display this and visualize. The communication between Jedox and Excel pivot tables running on the MDX query language for OLAP databases.

Mobile use

Thus, users can access on mobile devices to the central OLAP data base and software functionalities, Jedox offers two options: For one user can use the touch-optimized Jedox Web server access existing reports and those by gestures and finger control on smartphones customize and tablet PCs. In addition, the manufacturer offers a native mobile app for iOS and Android operating systems. All data can be written back to the Jedox OLAP database with mobile devices.

Versions (Licensing )

The company pursues a dual licensing system and distributes its core product as an open source and proprietary software. In addition, an operation on the Amazon AWS cloud service is possible.

Base vs. Premium

As of Release 5.0, the software is offered in a free basic version, which includes the Jedox OLAP server and a function limited version of Excel add- ins. The licensed premium version contains all the software components, and other service services software vendor, such as technical support.

Open Source ( PALO )

The Premium edition of the software was renamed as part of Release 3.3 of the "Palo " to " Jedox ". Furthermore, the Jedox OLAP server is license-free distributed as commercial open source software under the name PALO. In addition, an open source integration exists in OpenOffice under the name PalOOCa ( Palo for OpenOffice.org Calc).

Awards

Jedox was chosen by IT analysts repeatedly among the leading business intelligence provider. For the use of parallel graphics processors (GPU) for OLAP server Jedox was awarded by the international software analysts Gartner 2013 "Cool Vendor " in the " In - Memory Computing ".

Business

The company was founded in 2002 in Freiburg im Breisgau by Kristian Raue, and currently employs approximately 100 employees. Since 2008 Jedox is a corporation and is supported among others by the KfW and the venture capital firms Awakening & Cie and eCapital. The Company's Board consists of the company's founder Kristian Raue (CEO), Chief Technology Officer Matthias Krämer and sales and marketing director Bernd iron sheets. Jedox is headquartered in Freiburg since the company's founding in 2002. More Companies facilities are located in Frankfurt / Main, Dusseldorf and Paris.