Every movement is in some way logistics, and logistics is always moving.

Klaus Siebe

Ministry of Transport, Jordan

The Ministry of Transport (MOT) in Jordan is improving economic growth in Jordan by initiating infrastructure and legislative measures.

The MOT was set up in 1965 out of the Ministry of Communications (Railway, Aviation and Seaports) and received official status as the Jordanian transport ministry in 1972.

As a result of Transport Law No. 89, the core duties of the MOT include monitoring and development of transportation in Jordan in cooperation with all relevant entities in
road transport, rail transport, air freight, sea transport


with internal and bilateral connections, the official representation of Jordan in bilateral transport agreements and research and strategic development of transportation in Jordan.

THE SOLUTION FOR THE CUSTOMER

The Ministry of Transportation (MOT) in Jordan is improving economic growth in Jordan by initiating infrastructure and legislative measures.

This works optimally if all transport-relevant data are recorded comprehensively, corrected and analysed to evaluate strategic decisions on the basis of facts.

In our solution, we have over 100 data sources integrated from 20 authorities, ministries and private companies, and from this we made over 80 KPI reports, dashboards and geo reports available. In this way, for example, we can detect and rectify accident blackspots or make checks in customs, shipping and air traffic more productive and efficient.

By using a data-warehouse framework developed specifically, we were able to implement the project with a three-person team within the shortest possible time. By using a web-based administration interface, we could quickly implement any changes and requirements arising during the ongoing development process.

In the course of the project, not only was a software solution implemented, but the installation and initial startup of appropriate hardware consisting of 16 servers with redundant load balancers, firewalls and SANs were also successfully implemented for the customer.

IMPLEMENTATION

In the course of the DWH project for the Ministry of Transport, the complete implementation chain was covered by Proventa. In this context, Proventa not only arranged the provision of the software but also the necessary hardware.

Only well-known manufacturers such as Dell, EMC, Fortigate and F5 Networks were selected to provide the hardware, and all components, from servers to network, firewall, load balancers and the SAN storage system, have redundant designs to allow uninterrupted operation. The use of Linux and the compartmentalisation of the software on virtual machines contributed further to the redundancy as well as to the security of the system.

Based on Proventa's years of experience, the best of two worlds were linked for the software solution: the use of Oracle Database Enterprise with the open-source Pentaho Data Integration and Pentaho Business Intelligence Server.

Fast and flexible implementation of the data warehouse was carried out with the DWH framework developed specifically.

The focus was not only on a flexible, easily configurable ETL chain, but also on the connection of any interface for data supply and data retrieval.

As well as a web interface that allows uploading of all kinds of data and direct entry in configurable forms, interfaces such as sFTP, Oracle Database Links, REST and SOAP web services were also incorporated.

For the MOT, two very important focuses were a high level of automation of the system and the simplest possible administration of all components.

A web-based GUI was implemented for this that allowed the employees to take on all tasks independently: the configuration of the complete data warehouse; setting up new data supplies and interfaces; preparation of new reports, cubes and KPI; and monitoring of all system components.

All changes are now made in the system in real time and are immediately available.

The administrative complexity of a data warehouse was broken down thus to what is important:
Not only administering data, but analysing data.

DEPLOYED PRODUCTS

DATA-WAREHOUSE FRAMEWORK

The data-warehouse framework developed specifically allows the development and implementation of a complete data warehouse in the shortest possible time. Flexible interfaces allow the integration of all data sources.

 

METADATA WEB TOOL

The web interface developed specifically allows the complete configuration and maintenance of the data-warehouse framework. New data sources and reports can be integrated in the shortest possible time by the end users themselves.