Jedox

from Wikipedia, the free encyclopedia
Jedox

Jedox logo
Basic data

developer Jedox AG
Publishing year 2002
Current  version 2020.1
( February 26, 2020 )
operating system Linux , Windows
License Proprietary
German speaking Yes
www.jedox.com

Jedox is a cloud- based enterprise performance management software for creating performance management solutions for planning, analysis and reporting. The central component is a cell-oriented, multidimensional in-memory OLAP server, which was specially developed for budgeting and forecasting, as well as for data consolidation. The software is based on a modular SaaS platform. It uses Microsoft Excel as the user interface and Jedox's own spreadsheet , both browser-independent. Jedox is developed by the software company of the same name, Jedox AG from Freiburg im Breisgau .

Areas of application and distribution

Jedox was specially developed for tasks in planning, analysis and reporting and data consolidation and can be used across industries and departments. The basic principle of the software is that Jedox extracts the necessary operational data from the upstream systems, brings them into analysis-ready form and makes them available to various user groups in needs-based evaluations or access options via various user-friendly front ends .

The specialty of the software is that not only backward-oriented business intelligence applications, e.g. B. OLAP analyzes and reporting are covered, but also performance management solutions, such as what-if analyzes , demand planning, simulations, budgeting, financial planning and balanced scorecards can be created.

Jedox is used in around 120 countries and is delivered in 23 languages. Companies that have built performance management solutions with Jedox include: a. the Süddeutsche Verlag , Metro Group , Endress + Hauser and Swissport .

Components

In-memory database

Jedox's in-memory database is a memory-based, multidimensional real-time OLAP server ( MOLAP ) for managing business or statistical databases ( multidimensional database ). In addition to the multi-dimensional query data can also be written back (write back) and consolidated in real time. The server keeps all data in the main memory to enable fast data access. Via APIs in Java, PHP, C / C ++ or. NET, the Jedox OLAP database can be integrated into other software environments.

Excel add-in

A Microsoft Excel add-in component carries out the communication between the Jedox OLAP database and the Excel frontend. Any number of Excel workstations can be linked online, all of which access a central database ( single point of truth ). The data written in Microsoft Excel is written back to the OLAP cube structure via the add-in and aggregated. By using the well-known Excel interface, business users without IT knowledge can work independently with Jedox and carry out planning, analysis and reports.

Web client

Via the Jedox web client, users can access the centrally stored data in the OLAP database from a web browser . Reports created locally are transformed into server-based web applications and called up and adapted in the web browser. Analysis results and modifications of existing reports can also be written back consistently to the database in web mode. Analysis and calculation models with Excel are made available to multiple users via the web browser without the need to install Microsoft Excel. Users therefore access the OLAP database with their web browser even with mobile devices.

GPU module

The optional GPU module from Jedox uses the computing power and main memory of Tesla graphics processors to analyze company data. Complex OLAP calculations are accelerated many times over by the additional GPU component compared to an Intel multicore architecture, whereby the acceleration factor depends on the respective data model. The GPU module, developed in cooperation with the University of Freiburg and the University of Western Australia Perth , is mainly used in multidimensional data analyzes. The GPU component is switched on on the server side. Except for the graphics card, it does not require any additional hardware installation.

Integrator

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

SAP interface

The Jedox SAP Connector, an ETL module specially tailored to SAP landscapes , acts as an additional interface . The component supports all SAP Netweaver based SAP systems, such as SAP-R / 3 , SAP-ERP and SAP Business Warehouse (BW). As a result, Business Intelligence and Performance Management solutions from Jedox are integrated into existing SAP systems.

Mobile use

Jedox offers two options so that users can also access the central OLAP database and functionalities of the software on mobile devices: On the one hand, users can access existing reports via the touch-optimized Jedox web server and these can be accessed via gesture and finger control on smartphones and customize tablet PCs. The manufacturer also offers a native mobile app for iOS and Android operating systems. All data can also be written back to the Jedox OLAP database using mobile devices.

Jedox models

With the release of the Jedox 7 software version, users have access to "Jedox models". These are pre-configured applications for profit and loss account , cost center , personnel costs and sales, u. a. be delivered with databases, reports and input masks, business logic and workflow processes.

License packages

The company sells its software suite in a rental model. Customers can choose between a cloud-based service from the IaaS provider Microsoft Azure or an on-premises model. Jedox also offers a 14-day cloud trial version.

Awards

Jedox AG has been voted one of the leading business intelligence providers several times by IT analysts. For the use of parallel graphics processors ( GPU ) for OLAP servers, Jedox AG was named a “Cool Vendor” in the “ In-Memory Computing ” area by the international software analyst Gartner in 2013 . Jedox AG received the Deloitte "Technology Fast 50" award in 2017 and also in 2018 , which honors the fastest growing technology companies in Germany.

Companies

The company was founded in Freiburg im Breisgau in 2002 by Kristian Raue and currently employs around 200 people. Jedox has been a stock corporation since 2008 and is supported by KfW Bank and the venture capital companies Wecken & Cie, eCapital and Iris Capital. Florian Winterstein has been CEO of Jedox AG since October 2018. Jedox AG has had its headquarters in Freiburg im Breisgau since it was founded in 2002. Further company locations are in Frankfurt / Main, Düsseldorf, Paris and Boston. In January 2015, the takeover of the mobile BI company Reboard AG was announced. In addition, Jedox AG acquired the Australian IT company and partner company Naked Data in July 2015, which opened new locations in Melbourne, Sydney and Singapore. Another location was established in Seattle in 2019.

literature

  • Bernd Held, Hartmut Erb: Advanced Controlling with Excel. Corporate management with OLAP and PALO, m. CD-ROM. , Franzis, Poing 2006, ISBN 978-3-7723-7585-9
  • Stefan Müller, Leif Mergener: Business intelligence in sales based on open source solutions. In: Ronald Gleich, Andreas Klein (Ed.): Marketing and Sales Controlling (The Controlling Consultant Vol. 11). Haufe-Lexware, Freiburg 2010, ISBN 978-3-648-00489-0 .
  • Martin Schürmann, Mathias Fischer, Rolf Gegenmantel: BI implementation in medium-sized companies: From static reporting to active corporate management. In: Andreas Klein, Jens Gräf (Ed.): Reporting and Business Intelligence. Haufe-Lexware, Freiburg 2017, ISBN 978-3-648-09263-7 .
  • Angelika Grom, Norbert Grimm: Introduction of an integrated BI solution for planning and reporting in a medium-sized company. In: Ronald Gleich, Kai Grönke, Markus Kirchmann, Jörg Leyk (Eds.): Strategic corporate management with advanced analytics. Haufe-Lexware, Freiburg 2017, ISBN 978-3-648-10422-4 .

Web links

  • Jedox - open source MOLAP server for Windows / Linux with Microsoft Excel interface, documentation, demos and forum
  • PalOOCa on sourceforge.net - PalOOCa: Palo for OpenOffice.org Calc

Individual evidence

  1. ↑ Jedox Suite . Business Application Research Center, Dr. Christian Fuchs, undated
  2. ↑ Development of a benchmark for the performance of in-memory OLAP systems . Karlsruhe University of Applied Sciences, Christian Kolodziej, October 31, 2010, p. 54 ff.
  3. ↑ Süddeutscher Verlag relies on Jedox for SAP reporting . Computerwoche, Thomas Cloer, April 10, 2008.
  4. ↑ Climate balance at the Metro Group . CFO World, April 17, 2013.
  5. ↑ a b Mastering the Excel chaos in finance . Computerworld.ch, February 22, 2013.
  6. ↑ OLAP Tools II - PALO . TecChannel, Dr. Klaus Manhardt, September 10, 2009.
  7. ↑ Jedox releases OLAP Accelerator for productive use . CloudComputing Insider, Dirk Srocke, June 16, 2011.
  8. ↑ Jens Orlik: Concept of a medium-sized controlling solution based on open source software. Diplomica Verlag, Hamburg 2010, p. 31 ff.
  9. ↑ Palo Suite Premium with extended SAP connection . Heise, January 28, 2010.
  10. ↑ Analyze at the touch of a finger with Jedox 3.3 . IT Director, Immo Gehde, December 8, 2011.
  11. ↑ Jedox 7 software release . IT-Daily, November 30, 2016.
  12. ↑ Marc Tröndle: Jedox models | Preconfigured applications for planning and analysis. Retrieved December 12, 2018 .
  13. ↑ Jedox for Azure . Microsoft.com.
  14. ↑ Big Data and HANA are spurring the market . Business Application Research Center, Sascha Alexander.
  15. ↑ ERP: User satisfaction drops . Computerwoche, Frank Niemann, July 24, 2007.
  16. ↑ Cool Vendors 2013 . Gartner, Inc.
  17. ↑ Accolade for Jedox Badische Zeitung, May 28, 2013.
  18. ↑ Jedox AG honored with the Deloitte “Technology Fast 50” award 2017. Accessed December 12, 2018 (German).
  19. ↑ Deloitte Awards Jedox AG as "Technology Fast 50" star. In: SalesTechStar. November 15, 2018. Retrieved December 12, 2018 (American English).
  20. ↑ https://www.linkedin.com/company/jedox/about/
  21. ↑ Jedox becomes an AG . Computerwoche, o.A., January 22, 2008.
  22. ↑ 20 million EUR capital injection for Jedox . In: VC magazine . ( vc-magazin.de [accessed on June 6, 2018]).
  23. ↑ Freiburg software specialist Jedox has a new boss . CRN, Samba Schulte, September 24, 2018
  24. ↑ Jedox buys Australian dealer . Econo, o.A., July 25, 2015.
  25. ↑ Jedox takes over reboard . Computerwelt, Rudolf Felser, January 13, 2015.
  26. ↑ Jedox takes over Australian BI company . Computerwelt, Rudolf Felser, July 22, 2015.