CERN Turns to Pentaho to Optimize Operations | Hitachi Vantara
Hamburger Hamburger Hamburger


CERN Turns to Pentaho to Optimize Operations



Information Technology





CERN needed a compliant, secure unified business analytics and reporting platform and data warehouse to provide a 360-degree view of its data.



Pentaho Data Integration and Pentaho Business Analytics provide end-to-end integration, analytics and access control, and a real-time data warehouse.


  • Enables researchers to access and use advanced analytics.
  • Automates ETL to create a near real-time data warehouse.
  • Improves query and execution performance.
  • Provides granular access control with custom data access layer for analysis.

CERN, Europe's nuclear research organization, has 15,000+ scientists and other users accessing data.

The Challenge: Replace Outgrown Systems with a Unified Data, Analytics Platform

CERN's Advanced Information Services (AIS) group is responsible for delivering integrated and reliable corporate information systems to the entire organization. The AIS group sought to replace its existing installation of commercial and home-grown systems serving more than 650,000 report executions per year with a unified Business Analytics, reporting platform and data warehouse to provide a single, 360-degree view of its operational data to the CERN community of more than 15,000 users.

As an international non-governmental organization, CERN has unique challenges facing its corporate information systems. Not only fulfilling the roles of an employer of around 2,500 staff, but also a university (hosting hundreds of students, and thousands of visiting scientists every year), as well a "state", providing its staff and their families with the social cover (pension, health insurance, etc.). As such, the data CERN holds on its employees is subject to rigorous data protection and compliance regulations. The individual’s role in the CERN community – full-time scientist or engineer, short-term trainee or fellow, security guard or fireman, etc. – subjects their data to unique security and access privileges.

CERN's operational systems support a vast range of decision making – from providing employee access to the largest and most complex particle accelerators in the world to more routine matters like allocating budget to projects.

After a $150 million upgrade CERN restarted its main accelerator, the Large Hadron Collider (LHC), in June, therefore it’s vital that administrative processes do not interrupt the ground-breaking research ongoing at the laboratory. Systems need to be fast, simple and embedded into familiar processes and applications.

CERN's systems need to manage high volumes of confidential data on its employees and their families, so security, data governance and data integrity are all paramount. After a review of five different proprietary and open source platforms, Pentaho emerged as best adapted to our needs.

– Jan Janke, Deputy Group Leader, CERN

The Solution: Pentaho Data Integration and Pentaho Business Analytics

CERN selected Pentaho Business Analytics and Pentaho Data Integration platform to replace several heterogeneous systems and provide a single, 360-degree view of all its native operational data.

CERN’s five developer team, following initial learning and the collaboration with the Pentaho partner Ancud IT from Germany, developed an innovative approach to guaranteeing consistent access rights across application boundaries including data exposed through Pentaho. Access rights are calculated using a rules engine taking into consideration business needs and legal requirements. In Pentaho, those rights are enforced by extending Pentaho’s analysis engine (Mondrian).

Pentaho Data Integration enabled CERN to migrate from a manually-intensive ETL environment to an automated one, decoupled from proprietary data.

CERN is embedding reporting and analytics via Pentaho’s web service API to enable 15,000+ users to access these services through their normal day-to-day applications.

The Outcome: Pentaho Solution Improves Speed, Security, and Usability

CERN currently runs Pentaho in a production environment and will be fully operational as a single platform for AIS by year end 2015, replacing the majority of its legacy systems.

CERN has rolled out a series of test reports to end users. Their enthusiastic feedback has already shown that they are easier to use and run faster than the previous BI solution.

CERN’s security implementation with Pentaho is complete and currently being tested internally. CERN's goal is to deliver a new common data warehouse that will be the main source for all corporate data.

The development team is excited and proud to be working on a mission-critical project, using modern technologies.

The Pentaho solution gave the skilled AIS developer team control over the platform to customize it for CERN’s complex security and data protection requirements, including the rule-based secure access levels.

Explore More

First Name
Last Name
Business Email Address
Postal Code
Additional Information(optional)

Thank you. We will contact you shortly.

Note: Since you opted to receive updates about solutions and news from us, you will receive an email shortly where you need to confirm your data via clicking on the link. Only after positive confirmation you are registered with us.

If you are already subscribed with us you will not receive any email from us where you need to confirm your data.

Explore more about us:

To Talk to a Representative,
Call 1.678.403.3035

Corporate Headquarters

Hitachi Vantara LLC
2535 Augustine Drive
Santa Clara, CA 95054

You’re in the Right Place!

Hitachi Data Systems, Pentaho and Hitachi Insight Group have merged into one company: Hitachi Vantara.

The result? More data-driven solutions and innovation from the partner you can trust.

You’re in the Right Place!

REAN Cloud is now a part of Hitachi Vantara.
The result? Robust data-driven solutions and innovation, with industry-leading expertise in cloud migration and modernization.

You’re in the Right Place!

Waterline Data is now Lumada Data Catalog, provided by Hitachi Vantara. Lumada Data Catalog, available stand-alone, is now part of the Lumada Data Services portfolio.

You’re in the Right Place!

Hitachi Consulting and Hitachi Vantara have integrated into a new company under the Hitachi Vantara brand. We help you connect what’s now to what’s next.

{ "FirstName": "First Name", "LastName": "Last Name", "Email": "Business Email", "Title": "Job Title", "Company": "Company Name", "Address": "Address", "City": "City", "State":"State", "Country":"Country", "Phone": "Business Telephone", "LeadCommentsExtended": "Additional Information(optional)", "LblCustomField1": "What solution area are you wanting to discuss?", "ApplicationModern": "Application Modernization", "InfrastructureModern": "Infrastructure Modernization", "Other": "Other", "DataModern": "Data Modernization", "GlobalOption": "If you select 'Yes' below, you consent to receive commercial communications by email in relation to Hitachi Vantara's products and services.", "GlobalOptionYes": "Yes", "GlobalOptionNo": "No", "Submit": "Submit", "EmailError": "Must be valid email.", "RequiredFieldError": "This field is required." }