The Solution: Open Source Platform That Simplifies Analytics
Hitachi Vantara’s Pentaho was chosen because it is open source, has an open interface, and is able to fulfill the organization’s data integration and data warehousing requirements. Thanks to Pentaho, they are now able to provide all data and analysis on time.
Previously the German Federal Police faced issues resulting from having data scatted across countless systems. Pentaho has enabled them to consolidate all important data into one analysis tool.
The German Federal Police creates incoming statistics with Pentaho and calculates the changing needs of mission forces for huge airports, including employee work schedules. The incoming statistics encompass 20 areas of activities such as entry numbers at the borders, asylum caseload, criminal offences or trace successes. Pentaho enables them to blend data from different sources and process it uniformly to serve as basis for analysis. Based on these datasets, they have gained a complete picture of the situation and are able to give different user groups access to the analysis via the web.
The German Federal Police have developed numerous software applications that have been built with various parts of Hitachi Vantara’s big data integration and analytics suite. The primary component is their PES-Web, the German Federal Police’s data cleansing functionality for all statistics provided by their police force. The data is taken from their transaction processing system and is enriched and validated with Pentaho Data Integration (PDI). Next, PDI extracts the data and moves it to their data warehouse where it is available for analysis.
Bundespolizei’s data comes from a myriad of internal and external sources. Some of these sources are:
- Mission-control center system
- Transaction processing system
- Time records
- Flight plans from various German airports
- Personnel management system.
The organization has solved their authorization and onboarding challenges through Pentaho. Bundespolizei is now able to authenticate via their active directory; they are able to provide correct access based on the cohort’s responsibilities. They have implemented user authorization with their Dynamic Schema Processor (DSP); this ensures that users only see data they should have access to.
Through Pentaho, they have gained operational flexibility as the system can adapt quickly if political, social or economic circumstances change. This enables the authority to extend their reporting duties to national and European institutions – for example, the European Border and Coast Guard Agency (Frontex) – much faster.
Hitachi Vantara’s partner in the German-speaking market for the Pentaho platform is it-novum. Since 2009, it-novum has rolled out countless Pentaho projects, including the German Federal Police. During their Pentaho deployment, the German Federal Police worked with it-novum, who supplies the agency with Pentaho licensing, consulting, implementation, and support services. This collaboration with Bundespolizei is planned to last for seven years, during which time the authorities will gradually expand the solution and integrate it even further.